PermanentEngineering

Data / BI Engineer

Sabenza IT & Recruitment

Location
Cape Town, Western Cape
Contract
Permanent
Closing date

First listed . Last checked at source .

In brief

Overview This is a description for a Mid/Senior Data Engineer position at Sabenza IT & Recruitment. The role involves designing, building, and optimizing scalable data solutions to support business intelligence, analytics, and strategic decision-making. It is a hands-on position focused on developing modern data pipelines, data warehouses, and Power BI solutions, with an emphasis on data quality, performance, and reliability. The successful candidate will work closely with business and technical teams to translate requirements into robust data solutions and contribute to the ongoing evolution of the organization's data platform and architecture. What you will do * Translate business requirements into technical data solutions. * Participate in and contribute to architectural forums within the Business Intelligence (BI) team. * Design and implement ETL and data pipeline architectures using tools such as Azure Data Factory (ADF). * Automate processes and design system architectures. * Develop and manage Power BI semantic models, including DAX queries and cubes. * Translate metrics into visual Power BI reports and dashboards. * Integrate data between legacy and modern systems. * Create ad-hoc SQL scripts to support user queries. * Deploy and manage data solutions on cloud platforms such as Azure. * Apply data warehouse modelling techniques, including schemas, facts, dimensions and the building of data warehouses. * Write complex SQL queries, joins, views and stored procedures to extract and manipulate data. * Apply knowledge and practical experience across the data warehouse life cycle. * Perform data modelling, including dimensional, multi-dimensional and relational models. * Use T-SQL for database management and querying. * Support batch processing and scheduling tasks. * Create and maintain technical documentation, including 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. * Monitor data pipeline and infrastructure performance. * Identify bottlenecks and optimise for scalability, reliability and cost-efficiency. * Troubleshoot and resolve data-related issues. * 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 organisational strategies, including Azure cloud solutions and artificial intelligence initiatives. Requirements (from the original advert) * 5+ years experience. * Relevant tertiary qualification and certification. Who should apply This role is suitable for a Mid/Senior Data Engineer with a minimum of 5 years of experience and a relevant tertiary qualification and certification. The ideal candidate should be capable of designing, building, and optimizing scalable data solutions, including modern data pipelines, data warehouses, and Power BI solutions. They should be hands-on, proficient in ensuring data quality, performance, and reliability, and able to translate business requirements into technical solutions. A strong interest in contributing to architectural evolution and staying current with emerging technologies like Azure cloud solutions and artificial intelligence initiatives is also expected. Deadline Not specified Reference Original posting: https://www.jobmail.co.za/jobs/it-computer/other-it-computer/cape-town/data-bi-engineer-id-7603874 Source: jobmail

Summary drafted with AI assistance from the original advert. The advert itself is the authority — how we use AI.

At a glance

  • At least 5 years of experience.
  • SQL
  • Azure
  • Power BI

Extracted automatically from the advert; confirm requirements on the original listing.

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 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 and data pipeline architectures using tools such as Azure Data Factory (ADF). * Automate processes and design system architectures. * Develop and manage Power BI semantic models, including DAX queries and cubes. * Translate metrics into visual Power BI reports and dashboards. * Integrate data between legacy and modern systems. * Create ad-hoc SQL scripts to support user queries. * Deploy and manage data solutions on cloud platforms such as Azure. Data modelling and management * Apply data warehouse modelling techniques, including schemas, facts, dimensions and the building of data warehouses. * Write complex SQL queries, joins, views and stored procedures to extract and manipulate data. * Apply knowledge and practical experience across the data warehouse life cycle. * Perform data modelling, including dimensional, multi-dimensional and relational models. * Use T-SQL for database management and querying. * Support batch processing and scheduling tasks. Documentation and support * Create and maintain technical documentation, including 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 optimisation * Monitor data pipeline and infrastructure performance. * Identify bottlenecks and optimise 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 organisational strategies, including Azure cloud solutions and artificial intelligence initiatives. Key Requirements: * 5+ years experience. * Relevant tertiary qualification and certification. Sabenza IT & Recruitment Recruiter

Before you apply

  • Confirm the requirements and closing date on the original listing (jobmail). SPANi lists vacancies from other sites and may not reflect last-minute changes.
  • Legitimate employers do not charge application, registration or training fees.
  • Don't send your ID or bank details before you have confirmed the employer is real.

How to spot a job scam

Applying for permanent roles

  • Mirror the job title and top three requirements in your CV summary and most recent experience.
  • Quantify results where possible: sales targets, cases handled, tickets closed, or team size.
  • Proofread contact details and filenames before submitting — small errors cost interviews.
  • Verify the company and role on the source page before sharing ID copies or banking details.

Similar roles

PermanentEngineering

Site Engineer

Sabenza IT & RecruitmentBellville, Western Cape

We are looking for a Site Engineerto lead our facilities, maintenance, utilities and site services functions. In this role, you will ensure equipment reliability, operational uptime and a safe, compliant work environment, while driving maintenance systems and engineering improvement initiatives across the site.

Get new engineering jobs in western cape by email

Free. No account needed. Unsubscribe with one click.

We only use your email to send this alert. See our privacy policy.