About the role
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.
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. 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.