Senior Data Warehouse & BI Developer - Johannesburg - up to R500 per hour

Ats Client; Johannesburg; Sur place; ZAR 568 260 - 809 340; Plein temps

Résumé du poste

Our Client in the Insurance space is seeking a Senior Data Warehouse & BI Developer to join the data and analytics team. The role focuses on designing, developing, and maintaining enterprise data solutions for BI, regulatory reporting, and financial analytics.

The candidate will work with data warehousing, ETL, data lakes, and multidimensional modelling, with exposure to cloud/big data technologies. Contract role based in Johannesburg, offering an hourly rate of R500 (negotiable).

Qualifications

• Minimum 5 years in Data Warehousing, Data Lake, ETL/ELT, and Kimball dimensional modelling.
• Experience designing and supporting enterprise Data Lake architectures and ingestion frameworks.
• Experience with structured, semi-structured, and streaming data in modern analytics environments.
• 5+ years in SSIS development.
• 5+ years in SSRS report development.
• 5+ years in SSAS cube development and MDX.

Responsabilités

• 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 for regulatory, financial reporting.
• Manage data integration, QA, testing, and UAT activities.
• Monitor and report on data acquisition progress and reporting requirements.
• Troubleshoot data and system issues to ensure reliable data delivery.
• Collaborate with business stakeholders and technical teams to gather requirements.
• Contribute to database design, optimization, security, and data governance initiatives.
• Support cloud, big data, and streaming data technologies where applicable.
• Apply structured problem‑solving approaches to meet objectives and deadlines.

Connaissances

Data Warehousing

ETL/ELT Development

Dimensional Modelling

Kimball Methodology

Formation

IT-related Degree or Diploma

Microsoft/Cloud/Data Engineering Certifications

Outils

SSIS

SSRS

SSAS MDX

Description du poste

Our Client in the Insurance space is seeking an experienced Senior Data Warehouse & BI Developer to join their growing data and analytics team. The successful candidate will play a key role in designing, developing, and maintaining enterprise data solutions that support business intelligence, regulatory reporting, financial accounting, and operational decision‑making. This role requires strong expertise in Data Warehousing, ETL development, BI reporting, and multidimensional data modelling, with a particular focus on the insurance industry. Exposure to modern cloud and big data technologies will be highly advantageous.

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, optimization, 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.

Qualifications & Experience

• IT‑related Degree, Diploma, or equivalent qualification.
• Relevant Microsoft, Cloud, or Data Engineering certifications will be advantageous.
• 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.
• Experience working with structured, semi‑structured, and streaming data in modern analytics environments.
• 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.

Reference Number: NG61374
Job Type: Contract
Location: Johannesburg
Hourly Rate: R500 per hour (negotiable)