Analytics Engineer: Data Modeling & ETL Expert

The Focus Group; Sandton; On-site; ZAR 500,000 - 700,000; Full time

Job summary

The Focus Group is seeking an Analytical Engineer in Gauteng, Sandton, responsible for transforming raw data into analytics-ready datasets. The role involves strong data modelling expertise and collaboration with business stakeholders to enable advanced reporting and decision-making.

Ideal candidates will have proficiency in SQL and Python, experience with ETL processes, and an understanding of data governance frameworks. The position offers opportunities within an innovative environment focused on data-driven solutions.

Qualifications

• Strong experience in data modelling (Data Vault, dimensional modelling).
• Proficiency in SQL and Python for data transformation and analysis.
• Experience with modern data platforms (e.g., Azure, Databricks, Microsoft Fabric).
• Solid understanding of data warehousing, ETL/ELT, and analytics pipelines.

Responsibilities

• Design and implement scalable data models to support analytical use cases.
• Develop and maintain ETL/ELT processes to transform data into trusted datasets.
• Enable business intelligence and reporting through high-quality data provisioning.
• Ensure data integrity, lineage, and compliance across datasets.

Skills

Data modelling (Data Vault, dimensional modelling)

SQL and Python proficiency

Experience with Azure, Databricks, Microsoft Fabric

Data governance and quality frameworks

Job description

The Focus Group is seeking an Analytical Engineer in Gauteng, Sandton, responsible for transforming raw data into analytics-ready datasets. The role involves strong data modelling expertise and collaboration with business stakeholders to enable advanced reporting and decision-making.

Ideal candidates will have proficiency in SQL and Python, experience with ETL processes, and an understanding of data governance frameworks. The position offers opportunities within an innovative environment focused on data-driven solutions.