Hybrid BI & Data Lakes ETL Developer

e-Merge IT Recruitment; Johannesburg; Hybrid; ZAR 682,000 - 971,000; Full time

Job summary

e-Merge IT Recruitment seeks an experienced ETL Data Lakes BI Developer for a hybrid contract in Johannesburg. You will build and maintain data pipelines, data lakes and data warehouses to fuel BI, reporting and regulatory needs.

The role centers on Kimball dimensional modelling, MDX, SSIS, SSRS and SSAS, with emphasis on accuracy, performance, and governance across insurance data environments.

Qualifications

• IT related degree, diploma or equivalent qualification.
• 5+ years in data warehousing, Data Lake, ETL/ELT and dimensional modelling.
• Hands-on SSIS development experience.
• Experience with SSRS reports and SSAS cubes with MDX.
• Experience with Data Lake architecture and data ingestion frameworks.
• Kimball dimensional modelling knowledge.
• Insurance industry experience is essential.

Responsibilities

• Build and maintain ETL processes and data pipelines.
• Design enterprise data warehouses and Data Lake solutions.
• Develop Kimball dimensional models and MDX cubes.
• Create and maintain SSIS packages, SSRS reports, SSAS cubes.
• Support financial, regulatory and business reporting.
• Collaborate with stakeholders to translate requirements into solutions.
• Ensure data quality and governance.

Skills

Analytical thinking

Problem solving

Stakeholder collaboration

Education

IT degree or diploma

Tools

SSIS

SSRS

SSAS

MDX

Data Lake

Kimball modelling

SQL Server

Job description

e-Merge IT Recruitment seeks an experienced ETL Data Lakes BI Developer for a hybrid contract in Johannesburg. You will build and maintain data pipelines, data lakes and data warehouses to fuel BI, reporting and regulatory needs.

The role centers on Kimball dimensional modelling, MDX, SSIS, SSRS and SSAS, with emphasis on accuracy, performance, and governance across insurance data environments.