Data Engineer at Datonomy Solutions

Our Insights Team turns enterprise data into reliable business decisions. The Data Engineer will design, build and maintain pipelines, data models and warehouse structures that make trusted data available to analysts and stakeholders across the Group. The role requires hands‑on Microsoft BI engineering, dashboard development and strong ownership of data quality, governance and production support.

Key Responsibilities

• Design, build and maintain robust ETL and ELT pipelines within our data platform.
• Develop and continuously improve 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 relevant POPIA requirements.
• Translate business and analytics requirements into reliable, maintainable data solutions.
• Conduct unit, integration and regression testing before release.
• Document pipelines, models, data definitions and operational processes to ensure supportability and reuse.
• Design and build dashboards that communicate trusted insights to business stakeholders.

Minimum Requirements

• Relevant three-year IT or related degree or diploma.
• At least five years' experience designing and developing data pipelines.
• Advanced SQL and strong hands‑on Microsoft SQL Server experience.
• Advanced working knowledge of SSMS, SSIS and SSAS.
• Practical dimensional-modelling, ETL/ELT and data-warehousing experience.
• Hands‑on dashboard design and development in Power BI, Tableau or Pyramid.
• Understanding of data governance, reporting tools and structured and unstructured data.
• Practical unit, integration and regression-testing experience.

Advantageous

• JAMS job scheduling, Kafka streaming and Git version control.
• Retail, finance, customer or merchandise data domains.

Desired Skills

• Data Engineer
• BI Data Engineer
• Microsoft BI Developer