Business Intelligence Engineer (Cape Town)

We are looking for a skilled Business Intelligence Engineer to design, build, and optimize scalable data models and reporting solutions that drive business decision-making. You will work closely with data analysts, engineers, and stakeholders to transform raw data into actionable insights using modern data stack technologies.

This role is ideal for someone who enjoys solving complex data challenges, building reliable pipelines, and enabling self-service analytics across the organization.

Responsibilities:

• Design and maintain scalable data models and transformation pipelines using SQL and dbt
• Develop and optimize data solutions in BigQuery
• Build robust ETL/ELT workflows to support analytics and reporting
• Collaborate with stakeholders to understand reporting and analytics requirements
• Ensure data quality, governance, and documentation standards are maintained
• Create and maintain dashboards, datasets, and semantic layers for business users
• Optimize query performance and manage cost-efficient data processing in BigQuery
• Use Python for automation, scripting, and data processing tasks
• Support data validation, testing, and deployment processes
• Contribute to best practices in analytics engineering and BI development

Qualifications and experience:

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field
• Relevant certifications are advantageous
• Proven experience as a Business Intelligence Engineer, Analytics Engineer, or similar role
• Strong SQL skills with experience writing complex and optimized queries
• Hands-on experience with dbt for data transformation and modeling
• Experience working with Google BigQuery in production environments
• Proficiency in Python for data manipulation and automation
• Understanding of data warehousing concepts and dimensional modeling
• Experience with ETL/ELT processes and modern data stack tools
• Familiarity with Git/version control and CI/CD practices
• Strong analytical thinking and problem-solving skills
• Excellent communication and stakeholder management abilities

The Reference Number for this position is NG61323 which is a Permanent, Hybrid position based in the Western Cape offering a cost to company of up to R800k CTC negotiable on experience and ability. Contact Nokuthula at nokuthulag@ e-merge.co.za or call her on 011 463 3633 to discuss this and other opportunities.