Business Intelligence Automation Consultant

Prophecy Technologies

$110K — $130K *
Business Services
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8-10 years of experience in Business Intelligence and data automation.
  • Proficiency in SQL for data extraction and transformation.
  • Strong understanding of Python for workflow automation.
  • Familiarity with analytics platforms such as Domino.
  • Experience with data visualization tools like Sigma and Tableau.

Responsibilities

  • Assess existing reporting processes for automation potential.
  • Design and maintain automated reporting solutions.
  • Optimize and troubleshoot SQL queries for data manipulation.
  • Develop Python scripts for automation of data workflows.
  • Create dashboards and self-service reporting solutions in Sigma/Tableau.
  • Collaborate with users to gather and translate reporting needs into solutions.
  • Document automated processes and maintain records of reporting logic.

Benefits

  • Opportunities for professional development and training.
  • Collaborative work environment with cross-functional teams.
  • Access to advanced analytics tools and platforms.
  • Potential for flexible work arrangements.
Full Job Description
Role Overview:

This role focuses on assessing existing recurring reporting processes to identify and implement automation opportunities. The consultant will be responsible for designing, developing, and maintaining automated reporting solutions that significantly reduce manual effort and enhance reliability. The position requires a strong emphasis on Business Intelligence, data automation, and the operationalization of analytics workflows.

Key Responsibilities:
  • Assess existing recurring reporting processes and identify automation opportunities.
  • Design, develop, and maintain automated reporting solutions that reduce manual effort and improve reliability.
  • Write, optimize, and troubleshoot SQL queries to extract and transform data from multiple sources.
  • Develop Python scripts and workflows to automate data preparation, report generation, quality control checks, and distribution.
  • Build and enhance dashboards and self-service reporting solutions in Sigma and/or Tableau.
  • Utilize Domino or related analytics platforms to support reporting automation and operationalization of analytics workflows.
  • Collaborate with business users to gather reporting requirements and translate them into scalable solutions.
  • Create documentation for automated processes, data sources, and reporting logic.
  • Monitor automated jobs and troubleshoot issues as needed.
  • Recommend best practices for reporting governance, automation, and data quality.

Required Skills:
  • SQL
  • Python
  • Domino
  • Sigma
  • Tableau

Qualifications:
  • 8-10 years of experience in relevant skills.

Preferred Skills:
  • Data Quality
  • Data Governance
  • ETL/Data Integration

More Jobs at Prophecy Technologies

More Business Services Jobs

Find similar Business Intelligence Automation Consultant jobs: