Data Engineer at Datonomy Solutions

Datonomy Solutions; Parow; On-site; ZAR 700,000 - 950,000; Full time

Job summary

Datonomy Solutions in Parow, South Africa, is seeking a hands-on Data Engineer to develop and support data pipelines, warehouse structures, reports and dashboards for the Group.

The role is centered on SQL Server and the Microsoft BI stack, with emphasis on SSIS, SSAS, SSRS. Cloud experience is welcome, but strong practical experience with these technologies is essential.

Qualifications

• Three-year IT or related degree or diploma required.
• At least five years' hands-on experience building data pipelines and BI solutions.
• Advanced SQL and T‑SQL with extensive SQL Server experience.
• Strong practical experience with SSMS, SSIS and SSAS.
• Experience developing or supporting SSRS reports.
• Proven ETL, dimensional modelling and data warehousing experience.
• Experience maintaining scheduled data loads and resolving production issues.
• Hands-on dashboard development in Power BI, Tableau or Pyramid.
• Data quality controls, reconciliation and testing experience.
• Ability to translate reporting needs into maintainable technical solutions.

Responsibilities

• Design, develop and maintain data pipelines and ETL processes.
• Build and improve data warehouse structures and star schemas.
• Develop stored procedures, functions and SQL objects to support reporting.
• Maintain SSAS models, SSRS reports and business dashboards.
• Monitor scheduled data loads, investigate failures and resolve issues.
• Improve query performance, ETL and reporting performance.
• Implement data governance, security and PO PI A requirements where applicable.
• Document data flows, models and support procedures.
• Translate business requirements into reliable data and BI solutions.
• Conduct unit, integration and regression testing before releases.

Skills

Data pipeline design

ETL

Dimensional modeling

Data warehousing

Stakeholder collaboration

Education

Three-year IT or related degree/diploma

Tools

SSMS

SSIS

SSAS

SSRS

SQL Server

Power BI

Tableau

Pyramid

Job description

Role Overview

Our Insights Team turns enterprise data into reliable business decisions. We are looking for a hands-on Data Engineer to develop and support the data pipelines, warehouse structures, reports and dashboards used across the Group.

The role is centred on SQL Server and the established Microsoft BI stack. We are particularly interested in candidates who have built and maintained SSIS data integrations, SSAS models and SSRS reports in production environments. Cloud experience is welcome, but strong practical experience with these technologies is essential.

Key Responsibilities

• Design, develop and maintain data pipelines and ETL processes using SQL Server, T-SQL and SSIS.
• Build and improve data warehouse structures, dimensional models and star schemas.
• Develop stored procedures, functions and other SQL objects to support integration and reporting.
• Develop and maintain SSAS models, SSRS reports and business dashboards.
• Monitor scheduled data loads, investigate failures and resolve production issues.
• Improve query, ETL and reporting performance.
• Implement data validation, reconciliation, audit and exception-handling controls.
• Translate business requirements into reliable data and BI solutions.
• Conduct unit, integration and regression testing before release.
• Document data flows, models, technical solutions and support procedures.
• Apply data governance, security and relevant POPIA requirements.

Minimum Requirements

• A relevant three-year IT or related degree or diploma.
• At least five years' hands-on experience developing data pipelines and BI solutions.
• Advanced SQL and T-SQL skills, with substantial Microsoft SQL Server experience.
• Strong practical experience with SSMS, SSIS and SSAS.
• Experience developing or supporting SSRS reports.
• Proven experience with ETL, dimensional modelling and data warehousing.
• Experience maintaining scheduled data loads and resolving production data issues.
• Hands-on dashboard development experience in Power BI, Tableau or Pyramid.
• Practical experience with data quality controls, reconciliation and testing.
• Ability to work with stakeholders and turn reporting needs into maintainable technical solutions.

Advantageous Experience

• SQL Server Agent, JAMS or Control-M job scheduling.
• Git version control and Kafka streaming.
• Retail, merchandise, customer, finance or payments data.
• Azure or other cloud data tools in addition to strong SQL Server and Microsoft BI experience.

Desired Skills

• Data Engineer
• BI Data Engineer
• Microsoft BI Developer