BI Developer (ETL & Data Lake up to R500 per hour

Our client, a leading organisation in the insurance sector, 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 warehouse and data lake solutions that serve as the foundation for business intelligence, regulatory reporting, financial reporting, and enterprise-wide analytics.

This role requires extensive experience in enterprise data architecture, ETL development, dimensional data modelling, and business intelligence reporting, with the ability to build scalable, high-performance data solutions that support strategic and operational decision-making. Experience with in the insurance industry is essential, while exposure to modern cloud platforms, big data technologies, and advanced analytics environments will be highly advantageous.

• 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.

• 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.
• 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.

The Reference Number for this position is NG61374 which is a Contract position in Johannesburg offering an hourly rate of up to R500 per hour negotiable based on experience.