Senior Analytical Engineer - Data Vault, SQL & BI (12-Month)

DeARX; Sandton; On-site; ZAR 600,000 - 900,000; Full time

Job summary

DeARX is seeking an Analytical Engineer for a 12-month contract to transform complex data into actionable business insights. The role involves building analytics-ready datasets, robust data models (Data Vault 2.0 and dimensional modelling), and advanced SQL for data transformation and reporting.

You will collaborate with business stakeholders, data engineers, and solution architects to ensure data quality, governance, and trusted data products across reporting and analytics initiatives.

Qualifications

• 5+ years in Data Analysis within enterprise environments.
• 5+ years in Data Modelling, including Data Vault 2.0 and dimensional modelling.
• 5+ years in Data Governance principles.

Responsibilities

• Translate business requirements into analytics-ready datasets.
• Analyze, profile, validate, and transform large volumes of enterprise data.
• Design and maintain robust data models using Data Vault 2.0 and dimensional modelling.
• Develop advanced SQL queries for data transformation, validation, and reporting.
• Ensure data quality, governance, and consistency across analytical solutions.
• Collaborate with business stakeholders, data engineers, and solution architects to deliver trusted data products.
• Support reporting, business intelligence, and advanced analytics initiatives.
• Identify opportunities to improve data processes, standards, and governance.

Skills

Data Analysis

Data Modelling

Data Governance

SQL

Stakeholder Engagement

Translate Business Requirements

Tools

Azure Data Platform

Databricks

Job description

DeARX is seeking an Analytical Engineer for a 12-month contract to transform complex data into actionable business insights. The role involves building analytics-ready datasets, robust data models (Data Vault 2.0 and dimensional modelling), and advanced SQL for data transformation and reporting.

You will collaborate with business stakeholders, data engineers, and solution architects to ensure data quality, governance, and trusted data products across reporting and analytics initiatives.