Azure Data Engineer - Enterprise Analytics & Pipelines

Ariston; Randburg; On-site; ZAR 700,000 - 1,000,000; Full time

Job summary

Ariston is seeking an experienced Azure Data Engineer to design, build, and maintain data pipelines and warehouse structures that underpin an enterprise analytics platform operating in a regulated, high‑volume environment.

This hands‑on role requires delivering scalable pipelines, complex pricing logic, and a robust Power BI model, with collaboration across data architects, analysts, and business stakeholders to translate requirements into reliable data solutions.

Qualifications

• Bachelor's degree or equivalent demonstrable work experience.
• Five+ years commercial data engineering, with at least three on the Microsoft data platform.
• Experience designing and implementing production data pipelines using Azure Data Factory.
• Advanced SQL and experience with SQL Server/Azure SQL Database.
• Strong data modelling, warehousing principles, and dimensional modelling.

Responsibilities

• Design, develop, and maintain scalable data pipelines using Azure Data Factory to extract, transform, and load data into the data warehouse.
• Implement and maintain complex business calculation logic within the data layer, ensuring it is traceable to documented business requirements and auditable.
• Model and maintain warehouse structures that support effective-dated pricing and rate tables, versioned business rules, and multi-level classification hierarchies.
• Collaborate with data architects, analysts, data scientists, and stakeholders to translate requirements into technical solutions.
• Build and maintain data structures that feed the Power BI semantic layer and support reporting grains.
• Implement data transformation and cleansing logic to ensure data quality, accuracy, and consistency across the pipeline.
• Write and execute unit tests for all components and document results.
• Participate in peer code reviews before code promotion.
• Support System Integration Testing and defect triage with timely remediation.
• Optimize pipelines for performance, scalability, and cost efficiency.
• Monitor pipeline health and troubleshoot failures with corrective actions.
• Develop technical documentation, including design specs and mappings.
• Provide guidance to junior team members and transfer knowledge across the team.
• Adhere to security and compliance standards to protect data privacy.
• Stay current with the Microsoft data platform roadmap and assess new capabilities.

Skills

Analytical thinking

Problem solving

Communication

Team collaboration

Attention to detail

Education

Bachelor's degree in Computer Science / Information Systems / Engineering

Tools

Azure Data Factory

Azure Data Lake Storage

Azure Synapse Analytics

Power BI

SQL Server / Azure SQL Database

Python

C#

Job description

Ariston is seeking an experienced Azure Data Engineer to design, build, and maintain data pipelines and warehouse structures that underpin an enterprise analytics platform operating in a regulated, high‑volume environment.

This hands‑on role requires delivering scalable pipelines, complex pricing logic, and a robust Power BI model, with collaboration across data architects, analysts, and business stakeholders to translate requirements into reliable data solutions.