Senior Data Engineer - BI, ETL Pipelines & Data Warehousing

Datonomy Solutions; Parow; On-site; ZAR 600,000 - 1,000,000; Full time

Job summary

Datonomy Solutions is seeking a Data Engineer to design, build and maintain data pipelines, models and warehouse structures. The role focuses on trusted data delivery to analysts and stakeholders across the Group, with hands-on Microsoft BI engineering and dashboard development.

You will own data quality, governance and production support, ensuring scalable analytics solutions with compliance considerations and robust testing throughout the development lifecycle.

Qualifications

• Three-year IT degree or diploma required.
• At least five years' experience designing and developing data pipelines.
• Advanced SQL with hands-on Microsoft SQL Server experience.
• Advanced knowledge of SSMS, SSIS and SSAS.
• Experience with dimensional modelling, ETL/ELT and data warehousing.
• Hands-on dashboard design in Power BI, Tableau or Pyramid.
• Understanding of data governance, reporting tools and data types.
• Testing experience (unit/integration/regression).

Responsibilities

• Design, build and maintain robust ETL and ELT pipelines within our data platform.
• Develop scalable dimensional models and data-warehouse structures for analytics and reporting.
• Implement data-quality, validation and monitoring controls and resolve production-pipeline issues.
• Apply data-governance, security and compliance practices, including POPIA requirements.
• Translate business and analytics requirements into reliable data solutions.
• Conduct unit, integration and regression testing before release.
• Document pipelines, models, data definitions and operational processes.
• Design and build dashboards that communicate trusted insights to business stakeholders.

Skills

Data Engineer

BI Data Engineer

Microsoft BI Developer

Education

Three-year IT degree or diploma

Tools

SQL Server

SSMS

SSIS

SSAS

Power BI

Tableau

Pyramid

Job description

Datonomy Solutions is seeking a Data Engineer to design, build and maintain data pipelines, models and warehouse structures. The role focuses on trusted data delivery to analysts and stakeholders across the Group, with hands-on Microsoft BI engineering and dashboard development.

You will own data quality, governance and production support, ensuring scalable analytics solutions with compliance considerations and robust testing throughout the development lifecycle.