Data Platform & BI Engineer: Azure, ETL, Power BI

ATS Client; Cape Town; On-site; ZAR 900,000 - 1,200,000; Full time

Job summary

ATS Client is seeking a Mid/Senior Data Engineer to design, build, and optimize scalable data solutions that support business intelligence, analytics, and strategic decision-making. This hands-on role focuses on developing modern data pipelines, data warehouses, and Power BI solutions while ensuring data quality and reliability.

Collaborate with business and technical teams to translate requirements into robust data platforms, evolving the organization's data architecture for cloud and

Qualifications

• Experience designing scalable data solutions for BI and analytics.
• Hands-on in building data pipelines, data warehouses, and semantic models.
• Strong SQL, data modeling, and data quality improvement skills.

Responsibilities

• Translate business requirements into robust data solutions.
• Design and implement ETL/data pipelines (ADF).
• Develop Power BI semantic models and dashboards.
• Create and maintain technical documentation for data architectures.
• Monitor pipeline performance and optimize for reliability and cost.
• Collaborate with BI team and stakeholders on architecture discussions.

Skills

Data modeling

ETL/ELT design

SQL & T-SQL

DAX

Power BI development

Azure cloud platform

Azure Data Factory

Data warehousing

BI architecture

Performance optimization

Automation

Tools

Power BI

Azure Data Factory

Azure

Azure SQL

T-SQL

Job description

ATS Client is seeking a Mid/Senior Data Engineer to design, build, and optimize scalable data solutions that support business intelligence, analytics, and strategic decision-making. This hands-on role focuses on developing modern data pipelines, data warehouses, and Power BI solutions while ensuring data quality and reliability.

Collaborate with business and technical teams to translate requirements into robust data platforms, evolving the organization's data architecture for cloud and