Senior BI & Data Warehouse Developer — ETL/Data Lake

E-Merge; Johannesburg; On-site; ZAR 568,000 - 809,000; Full time

Job summary

E-Merge is seeking a Senior Data Warehouse & BI Developer to join its Data & Analytics team in Johannesburg. You will design, develop, and maintain enterprise data warehouse and data lake architectures to support BI, regulatory, financial reporting, and analytics for the insurance sector.

The ideal candidate has 5+ years in data warehousing, ETL/ELT, SSIS, SSRS, and SSAS MDX, with Kimball dimensional modelling. Contract role offering up to R500 per hour, based on experience.

Qualifications

• Minimum 5 years' experience in Data Warehousing, Data Lake implementation, ETL/ELT development, and dimensional modelling using Kimball methodology.
• Experience designing and supporting enterprise Data Lake architectures and data ingestion frameworks.
• Minimum 5 years' experience developing ETL solutions using SSIS.
• Minimum 5 years' experience in SSRS report development.
• Minimum 5 years' experience in SSAS cube development and MDX.

Responsibilities

• Design, develop, and maintain end-to-end data acquisition, ETL, and data management solutions.
• Build and support data pipelines, data lakes, and enterprise data warehouse environments.
• Develop dimensional data models and BI solutions to support business, regulatory, and financial reporting.
• Manage data integration, quality assurance, testing, and user acceptance testing (UAT) activities.
• Monitor and report on data acquisition progress, project delivery, and reporting requirements.
• Troubleshoot data and system issues, ensuring reliable and accurate data delivery.
• Collaborate with business stakeholders, technical teams, and clients to gather requirements and deliver solutions.
• Contribute to database design, optimisation, security, and data governance initiatives.
• Support cloud, big data, and streaming data technologies where applicable.
• Apply structured problem‑solving approaches to meet project objectives and deadlines.

Skills

Data Warehousing

Data Lake

ETL/ELT

Dimensional Modelling

Kimball Methodology

SSIS

SSRS

SSAS MDX

Cloud Platforms

Education

IT-related Degree

Tools

SSIS

SSRS

SSAS MDX

Job description

E-Merge is seeking a Senior Data Warehouse & BI Developer to join its Data & Analytics team in Johannesburg. You will design, develop, and maintain enterprise data warehouse and data lake architectures to support BI, regulatory, financial reporting, and analytics for the insurance sector.

The ideal candidate has 5+ years in data warehousing, ETL/ELT, SSIS, SSRS, and SSAS MDX, with Kimball dimensional modelling. Contract role offering up to R500 per hour, based on experience.