Senior Data Vault & Analytics Engineer (SQL | Azure)

Losika Consulting; Sandton; On-site; ZAR 550,000 - 750,000; Full time

Job summary

Losika Consulting is seeking an experienced Analytical Engineer to join one of South Africa's leading banking institutions. In this role, you will design analytical data models and ensure data quality.

The ideal candidate should have deep expertise in Data Modelling, SQL, and Data Vault 2.0, and be comfortable engaging with both technical and business teams to deliver high-quality datasets for analysis.

Qualifications

• 5+ years of commercial experience in Data Modelling.
• Proven expertise in Data Vault 2.0 and Dimensional Modelling.
• Experience with Advanced SQL and ETL/ELT design.

Responsibilities

• Design enterprise analytical data models using Data Vault 2.0.
• Translate business requirements into scalable analytical data structures.
• Develop complex SQL transformations across large data environments.

Skills

Data Modelling

Data Vault 2.0

Advanced SQL

Data Profiling

Data Analysis

ETL / ELT design

Azure Databricks

Enterprise Data Warehousing

Data Quality & Data Validation

Business Requirements Analysis

Stakeholder Engagement

Tools

Azure Data Factory

Microsoft Fabric

Azure Synapse Analytics

Python

Delta Lake

Spark

Git

Data Lineage

Metadata Management

Data Governance Frameworks

Job description

Losika Consulting is seeking an experienced Analytical Engineer to join one of South Africa's leading banking institutions. In this role, you will design analytical data models and ensure data quality.

The ideal candidate should have deep expertise in Data Modelling, SQL, and Data Vault 2.0, and be comfortable engaging with both technical and business teams to deliver high-quality datasets for analysis.