Data / BI Engineer

Cape Town, South Africa | Posted on 29/06/2026

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

TechnicalSolution Development

• Translatebusiness requirements into technical data solutions.
  
• Participatein and contribute to architectural forums within the Business Intelligence (BI)team.
  
• Designand implement ETL/data pipeline architectures using tools like ADF (Azure datafactory).
  
• Automateprocesses and design system architectures.
  
• Developand manage Power BI semantic models, including understanding DAX queries andcubes.
  
• Visualisationand Dashboarding: translate metrics into visual Power BI reports
  
• Integratedata between legacy and modern systems.
  
• Createad-hoc SQL scripts to support user queries.
  
• Deployand 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 practicalexperience in the Data Warehouse Life Cycle.
• Perform data modeling includingdimensional, multi-dimensional, and relational models.
• Utilize TSQL for databasemanagement and querying.
• Support batch processing andscheduling tasks.

Documentationand Support

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

Monitoringand Optimization

• Monitor data pipeline andinfrastructure performance.
• Identify bottlenecks andoptimize for scalability, reliability, and cost-efficiency.
• Troubleshoot and resolvedata-related issues.

Strategicand Emerging Technology Contributions

• Contribute to evolving thearchitecture towards modern platforms, whether on-premise or cloud-based.
• Maintain working knowledge ofPower BI reporting.
• Ensure technical skills stayrelevant to emerging industry trends and organizational strategies,including Azure Cloud Solutions and Artificial Intelligence initiatives.