Analytics Engineer: Data Vault & BI-Ready Data

Sabenza IT & Recruitment; Johannesburg; On-site; ZAR 650,000 - 900,000; Full time

Job summary

Sabenza IT & Recruitment is seeking an Analytical Engineer to bridge business needs and data technology. You will transform requirements into reliable, analytics-ready datasets using Data Vault 2.0 and dimensional modelling.

You will collaborate with stakeholders to translate requirements into scalable data solutions, profile and validate complex enterprise data, and support reporting and self-service analytics initiatives.

Qualifications

• Proven experience as an Analytical Engineer, Data Analyst, or similar analytical data role.
• Strong expertise in Data Modelling, including Data Vault 2.0 and Dimensional Modelling.

Responsibilities

• Translate complex business requirements into scalable analytical data models.
• Design and develop analytics-ready datasets using Data Vault 2.0 and Dimensional Modelling methodologies.
• Perform comprehensive data profiling, quality assessments, and validation activities.
• Develop advanced SQL queries for data transformation, cleansing, and analysis.
• Collaborate with business stakeholders to understand reporting and analytical requirements.
• Ensure consistency, integrity, and governance of enterprise data assets.
• Work closely with engineering teams to optimise data pipelines and data structures.
• Support reporting, dashboarding, and self-service analytics initiatives.
• Identify opportunities to improve data quality, performance, and modelling standards.
• Document business rules, data definitions, and technical specifications.

Skills

Data Modelling

SQL

Data Profiling

Data Validation

Data Analysis

Data Transformation

Enterprise Data Warehousing

ETL/ELT concepts

Documentation

Stakeholder engagement

Tools

Data Vault 2.0

Dimensional Modelling

Job description

Sabenza IT & Recruitment is seeking an Analytical Engineer to bridge business needs and data technology. You will transform requirements into reliable, analytics-ready datasets using Data Vault 2.0 and dimensional modelling.

You will collaborate with stakeholders to translate requirements into scalable data solutions, profile and validate complex enterprise data, and support reporting and self-service analytics initiatives.