Data / BI Engineer

Sabenza IT & Recruitment; Eersterivier; On-site; ZAR 900,000 - 1,300,000; Full time

Job summary

Sabenza IT & Recruitment is seeking a Mid/Senior Data Engineer to design, build, and optimize scalable data solutions supporting BI and analytics. The role focuses on modern data pipelines, data warehouses, and Power BI, ensuring data quality, performance, and reliability.

You will translate business requirements into robust data solutions, contribute to the evolution of the organization's data platform, and collaborate with business and technical teams to drive strategic decision-making.

Qualifications

• Translate business requirements into technical data solutions.
• Design and implement ETL/data pipeline architectures using tools like ADF (Azure data factory).
• Develop and manage Power BI semantic models, including understanding DAX queries and cubes.
• Deploy and manage data solutions on cloud platforms like Azure.

Responsibilities

• Translate business requirements into technical data solutions.
• Design and implement ETL/data pipeline architectures using ADF.
• Develop and manage Power BI semantic models and dashboards.
• Deploy and manage data solutions on Azure.
• Monitor data pipeline performance and optimize for scalability and cost-efficiency.
• Create and maintain technical documentation.

Skills

Power BI

DAX

Azure Data Factory

SQL

T-SQL

Data Modeling

Data Warehousing

ETL

Azure

Cube/OLAP

Tools

Power BI

Azure

Azure Data Factory

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 ManagementUnderstanding of Data Warehouse modeling and Techniques: Data schemas, Facts, dimensions and building data warehouses.
• 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 SupportCreate 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.