Intermediate Analytics Engineer

Sabenza IT & Recruitment

Location
Johannesburg, Gauteng
Contract
Permanent
Minimum qualification
Bachelor's degree
Closing date

First listed . Last checked at source .

In brief

**Overview** This role, for an Intermediate Analytics Engineer at Sabenza IT & Recruitment, focuses on building and maintaining the foundational "silver and gold layers" of business data. This involves creating canonical data models and certified metrics using SQL on Databricks, ensuring they are trustworthy through rigorous testing and comprehensive documentation. The core objective is to define every measure once so that dashboards, analysts, applications, and AI agents consistently consume the same certified tables and metric views. **What you will do** * Build silver and gold models in Databricks using Lakeflow Declarative Pipelines and dimensional modelling to provide a consistent and fast data layer for business queries. * Embed all business rules, joins, and aggregations within the models to ensure each rule is defined once and used everywhere, preventing consuming tools from implementing their own. * Define certified metrics in gold tables and Unity Catalog metric views by collaborating with metric owners to ensure all consumers, human or AI, report the same numbers. * Maintain a single authoritative definition for each metric, including owner, grain, lineage, and agent metadata, to enable auditable certification and correct interpretation by BI tools and AI agents. * Implement expectations and data quality checks in every model by codifying rules within the pipeline to proactively catch failures before data reaches consumers. * Reconcile Databricks outputs against SAP BW extracts during the migration process to ensure the trustworthiness of migrated reports. * Manage changes through Git pull requests, GitHub Actions, and Databricks Asset Bundles to ensure every modification is reviewed, tested, and reversible. * Apply access control, masking, and row filters in alignment with data sensitivity requirements to maintain security for governed self-service operations. **Requirements (from the original advert)** * **Qualifications and Experience:** * Matric and a Bachelor's degree in Data Science, Statistics, Computer Science, Information Systems, Engineering or a related field, or equivalent practical experience. * 3 or more years in analytics engineering, data engineering or advanced analytics. * Expert SQL: window functions, CTEs, complex joins and large analytical models, with the judgment to tell a query that returns the right answer from one that will still return it on full SAP history. * 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. The Databricks Certified Data Engineer Associate or the dbt Analytics Engineering certification also counts. * 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 Experience:** * 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, with each ported model reconciled against its SAP source. * Exposure to Power BI or Qlik and how BI tools consume analytical models. **Who should apply** This role is suitable for an Intermediate Analytics Engineer with a strong academic background in data science, statistics, computer science, information systems, or engineering, or equivalent practical experience. Candidates must possess at least three years of experience in analytics engineering, data engineering, or advanced analytics. Essential skills include expert SQL, strong data modelling (star schemas, dimensional modelling), and hands-on experience with declarative transformation frameworks like Databricks Lakeflow or dbt. Proficiency with Git and CI/CD practices in data environments, coupled with working knowledge of SAP (BW objects, S/4HANA, or Business Data Cloud), is crucial, especially given the ongoing SAP BW-to-Databricks migration. Ideal candidates are detail-oriented, focused on data quality and governance, and adept at ensuring consistent metric definitions across diverse consumption points. Experience in retail (especially pharmacy), healthcare, or financial services data, Python for pipeline testing, AI agent coding, and familiarity with BI tools like Power BI or Qlik are considered advantageous. **Deadline** Not specified **Reference** Original posting: https://www.jobmail.co.za/jobs/it-computer/other-it-computer/johannesburg/intermediate-analytics-engineer-id-7611152 Source: jobmail

Summary drafted with AI assistance from the original advert. The advert itself is the authority — how we use AI.

At a glance

    • Python
    • SQL
    • Git
    • Power BI
    • SAP

    Extracted automatically from the advert; confirm requirements on the original listing.

    Job description

    Summary of Role The 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. Dashboards, analysts, applications and AI agents all consume the same certified tables and metric views, so every measure is defined once and used everywhere. Responsibilities: Silver and Gold Modelling * Build silver and gold models in Databricks using Lakeflow Declarative Pipelines and dimensional modelling so that the business queries one consistent, fast layer. Keep every business rule, join and aggregation inside the models, leaving consuming tools with none of their own, so that each rule is defined once and used everywhere. Metrics and Semantics * 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, so that certification is auditable and BI tools and AI agents read measures correctly. Quality, Testing and Migration Assurance * Add expectations and data quality checks to every model by codifying rules in the pipeline so that failures are caught before consumers see them. * Reconcile Databricks outputs against SAP BW extracts during the migration so that migrated reports are trusted. Delivery and Governance * Ship changes through Git pull requests, GitHub Actions and Databricks Asset Bundles so that every change is reviewed, tested and reversible. * Apply access control, masking and row filters aligned to data sensitivity so that governed self-service stays safe. Requirements Qualifications and Experience * Matric and a Bachelor's degree in Data Science, Statistics, Computer Science, Information Systems, Engineering or a related field, or equivalent practical experience. * 3 or more years in analytics engineering, data engineering or advanced analytics. * Expert SQL: window functions, CTEs, complex joins and large analytical models, with the judgment to tell a query that returns the right answer from one that will still return it on full SAP history. * 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. The Databricks Certified Data Engineer Associate or the dbt Analytics Engineering certification also counts. * 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 Experience * 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, with each ported model reconciled against its SAP source. * Exposure to Power BI or Qlik and how BI tools consume analytical models. Sabenza IT & Recruitment Recruiter

    Before you apply

    • Confirm the requirements and closing date on the original listing (jobmail). SPANi lists vacancies from other sites and may not reflect last-minute changes.
    • Legitimate employers do not charge application, registration or training fees.
    • Don't send your ID or bank details before you have confirmed the employer is real.

    How to spot a job scam

    Applying for permanent roles

    • Mirror the job title and top three requirements in your CV summary and most recent experience.
    • Quantify results where possible: sales targets, cases handled, tickets closed, or team size.
    • Proofread contact details and filenames before submitting — small errors cost interviews.
    • Verify the company and role on the source page before sharing ID copies or banking details.

    Similar roles

    Data & Analytics

    Data Engineer (WI_Data Engineer)

    andBeyondJohannesburg, Gauteng

    Data platform, pipelines and operational data ownership (approx. 35%) Operational and M&E data modelling and quality (approx. 20%) Data governance, security and POPIA compliance (approx. 15%) Collaboration, capacity building and team support (approx. 15%)

    Get new data & analytics jobs in gauteng by email

    Free. No account needed. Unsubscribe with one click.

    We only use your email to send this alert. See our privacy policy.