Data Insight Engineer - Vault 2.0 and SQL

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

Job summary

DeARX is seeking an Analytical Engineer on a 12-month contract to transform complex data into trusted business insights. The role focuses on analytics-ready datasets, data modelling with Data Vault 2.0, and governance in a modern data environment.

You will collaborate with business and technology teams to deliver high-quality data products, develop SQL for transformation, and support BI and analytics initiatives across the organisation.

Qualifications

• 5+ years' experience in Data Analysis within enterprise environments.
• 5+ years' experience in Data Modelling, including Data Vault 2.0 and dimensional modelling.
• 5+ years' experience working with Data Governance principles.
• Advanced SQL skills with data transformation, profiling, and validation.
• Experience translating business requirements into technical data solutions.

Responsibilities

• Translate business requirements into structured, analytics-ready datasets.
• Analyse, 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

Communication

Tools

Azure Data Platform

Databricks

Job description

DeARX is seeking an Analytical Engineer on a 12-month contract to transform complex data into trusted business insights. The role focuses on analytics-ready datasets, data modelling with Data Vault 2.0, and governance in a modern data environment.

You will collaborate with business and technology teams to deliver high-quality data products, develop SQL for transformation, and support BI and analytics initiatives across the organisation.