Analytical Engineer

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

Are you passionate about transforming complex data into meaningful business insights? We're looking for an experienced Analytical Engineer to join a leading financial services organisation on a 12-month contract. This is an exciting opportunity to work in a modern data environment, partnering with business and technology teams to deliver trusted, high-quality data that drives strategic decision-making.

Job 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 techniques.
• 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.

Role Requirements

• 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 strong experience in data transformation, profiling, and validation.
• Experience translating business requirements into technical data solutions.
• Strong analytical thinking and problem-solving abilities.
• Excellent stakeholder engagement and communication skills.
• Ability to bridge business and technical teams to deliver high-quality data solutions.

Nice to Have

• Experience with Azure Data Platform and Databricks.
• Exposure to enterprise data warehouses and modern cloud data platforms.
• Knowledge of Governance, Risk and Controls.
• Understanding of project management principles.
• Business writing and documentation skills.
• Previous experience within the banking or financial services sector will be advantageous.

If you're passionate about data, enjoy solving complex business problems, and thrive in collaborative environments, we'd love to hear from you.