Senior Data Warehouse & BI Developer (Johannesburg)

Our Client in the Insurance space is seeking 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 and 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.