Data / BI Engineer

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

Job Description

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

Working closely with business and technical teams, you will translate business requirements into robust data solutions and contribute to the ongoing evolution of the organization's data platform and architecture.

Requirements

Key Responsibilities and Skills

Technical Solution Development

• Translate business requirements into technical data solutions.
• Participate in and contribute to architectural forums within the Business Intelligence (BI) team.
• Design and implement ETL/data pipeline architectures using tools like ADF (Azure data factory).
• Automate processes and design system architectures.
• Develop and manage Power BI semantic models, including understanding DAX queries and cubes.
• Visualisation and Dashboarding: translate metrics into visual Power BI reports.
• Integrate data between legacy and modern systems.
• Create ad‑hoc SQL scripts to support user queries.
• Deploy and manage data solutions on cloud platforms like Azure.

Data Modeling and Management

• Understanding of Data Warehousemodeling and Techniques: Data schemas, Facts, dimensions and building datawarehouses.
• Writing complex SQL queries, joins, views and stored procedures to extract and manipulate data.
• Apply knowledge and practical experience in the Data Warehouse Life Cycle.
• Perform data modeling including dimensional, multi‑dimensional, and relational models.
• Utilize TSQL for database management and querying.
• Support batch processing and scheduling tasks.

Documentation and Support

• Create and maintain technical documentation such as data architecture diagrams, ETL workflows, and system documentation to ensure maintainability.
• Participate in design, peer, and code reviews.
• Provide daily technical, functional, and operational support for existing BI solutions.

Monitoring and Optimization

• Monitor data pipeline and infrastructure performance.
• Identify bottlenecks and optimize for scalability, reliability, and cost‑efficiency.
• Troubleshoot and resolve data‑related issues.

Strategic and Emerging Technology Contributions

• Contribute to evolving the architecture towards modern platforms, whether on‑premise or cloud‑based.
• Maintain working knowledge of Power BI reporting.
• Ensure technical skills stay relevant to emerging industry trends and organizational strategies, including Azure Cloud Solutions and Artificial Intelligence initiatives.