Intermediate Analytics Engineer

X, bigly labs; Johannesburg; On-site; ZAR 600,000 - 900,000; Full time

Job summary

X, bigly labs in Johannesburg seeks an Intermediate Analytics Engineer to build silver and gold data models in Databricks with Lakeflow Declarative Pipelines and dimensional modelling. You will define certified metrics, ensure data quality, and manage end-to-end model delivery with Git-based workflows.

Applicants need 3–5 years in analytics engineering, expert SQL and SAP BW knowledge. Experience with Lakeflow/dbt and BI tools like Power BI or Qlik is valued.

Qualifications

• Bachelor's degree in a data-related field or equivalent practical experience.
• 3–5 years in analytics engineering, data engineering, or advanced analytics.
• Expert SQL: window functions, CTEs, complex joins, large analytical models.
• Strong data modelling: star schemas, dimensional modelling, fact and dimension design.
• Experience with Lakeflow Declarative Pipelines or dbt.
• Git and CI/CD in data work: pull requests, review, automated deployment.

Responsibilities

• Build silver and gold models in Databricks using Lakeflow Declarative Pipelines and dimensional modelling.
• Define certified metrics in gold tables and Unity Catalog metric views with owners and grain.
• Maintain one authoritative metric definition with lineage and metadata for auditors and BI/AI consumers.
• Add data quality checks and rules to pipelines to catch failures before consumers see results.
• Ship changes via Git pull requests, GitHub Actions, and Databricks Asset Bundles with review and testing.

Skills

SQL

Data modelling

Lakeflow

dbt

Git & CI/CD

SAP BW

S/4HANA

Education

Bachelor's degree in Data Science, Statistics, Computer Science, Information Systems, Engineering or related field

Tools

Databricks

Lakeflow Declarative Pipelines

dbt

Power BI

Qlik

Git

Job description

We are X, bigly labs, Dis-Chem’s high-performance innovation hub; a place where bold ideas meet data, design, and radical customer focus to reimagine what healthcare can be.

Our mission is to power the future of healthcare by lowering costs, unlocking new possibilities, and improving access to healthcare for all South Africans. We do this through cutting-edge digital solutions that deliver smarter, more human, and truly patient-focused experiences. Here, your work is not limited to a whiteboard; it becomes real. It drives decisions, shapes experiences, and moves healthcare forward. We are driven by one big question: How do we use data and today’s technology to build breakthroughs to better health?

There’s only one question left: are you ready to make healthcare smarter, and actually mean it?

The Intermediate Analytics Engineer builds the silver and gold layers the business runs on: canonical models and certified metrics in SQL on Databricks, with the tests and documentation that keep them trustworthy. Gold is the product. Dashboards, analysts, applications and AI agents all consume the same certified tables and metric views, so every measure is defined once and used everywhere.

WHAT WE'RE LOOKING FOR?

Minimum

• Bachelor's degree in Data Science, Statistics, Computer Science, Information Systems, Engineering or a related field, or equivalent practical experience.
• 3 to 5 years in analytics engineering, data engineering or advanced analytics.
• Expert SQL: window functions, CTEs, complex joins and large analytical models.
• Strong data modelling: star schemas, dimensional modelling, fact and dimension design.
• Experience with a declarative transformation framework: Databricks Lakeflow Declarative Pipelines, or dbt, which transfers directly.
• Git and CI/CD in data work: pull requests, review and automated deployment. The Databricks Git UI counts.
• Working SAP knowledge: BW objects such as InfoProviders, extractors and routines, plus S/4HANA or Business Data Cloud. This role reads SAP semantics daily during the BW-to-Databricks migration.

Advantageous

• Retail data, ideally pharmacy retail. Healthcare or financial services also count.
• Working Python for pipeline unit tests and transformations SQL cannot express.
• Coding agents such as Claude Code or Codex: turns repetitive migration work into automated, repeatable steps, each ported model reconciled against its SAP source.
• Exposure to Power BI or Qlik and how BI tools consume analytical models.

WHAT YOU WILL BE DOING?

• Build silver and gold models in Databricks using Lakeflow Declarative Pipelines and dimensional modelling so that the business queries one consistent, fast layer.
• Define certified metrics in gold tables and Unity Catalog metric views by agreeing definitions with metric owners so that every consumer, human or AI agent, reports the same number.
• Maintain one authoritative definition per metric, with owner, grain, lineage and agent metadata such as display names and synonyms, so that certification is auditable and BI tools and AI agents read measures correctly.
• Add expectations and data quality checks to every model by codifying rules in the pipeline so that failures are caught before consumers see them.
• Ship changes through Git pull requests, GitHub Actions and Databricks Asset Bundles so that every change is reviewed, tested and reversible.

WHO YOU ARE?

• Have a knowledge of how retail business processes turn into facts, dimensions and metrics, and how the SAP estate maps onto the medallion layers.
• Be able to find the root cause of data problems and fixes them once, in the model.
• Be able to explain trade-offs to technical and business audiences.
• Owns delivery of own models end to end and manages competing priorities.
• Manages own backlog and commitments; no people management.

Our values show up in how we think, build, and make choices that make an impact. We are building a culture that drives progress; one that fixes friction, chases what changes, and owns the outcome. We design with tomorrow in mind, ask sharper questions, and answer them with care, urgency, and systems that scale.

Think you’ve got energy, curiosity, and guts? Come hold the space, make it matter, and own a breakthrough.