Senior Analytics Engineer
Posted Updated
Description
About the Role
The Senior Analytics Engineer owns the silver and gold layers and sets the modelling, testing and deployment standards the rest of the chapter follows. This role certifies the metrics the business and AI agents rely on, and anchors the analytics side of the SAP BW to Databricks migration. If the gold layer is trusted, it’s because this person made it so.
What You’ll Do
Architecture and Modelling Leadership
- Design the silver and gold layer structure using Lakeflow Declarative Pipelines and dimensional modelling so the estate stays consistent as it grows.
- Build the hardest models yourself so complex business rules land correctly the first time.
Metric Certification
- Own the metric certification approach across gold tables, Unity Catalog metric views and their agent metadata so people and AI agents consume one certified definition per measure.
- Provide BI-ready views over metric views so Power BI consumes certified measures without duplicating logic that already exists in gold.
Quality and Migration Assurance
- Own the reconciliation approach between Databricks and SAP BW during the migration so sign-off is evidence-based.
- Set the testing standard (expectations and unit tests) and hold the chapter to it.
Standards, Coaching and Delivery Governance
- Set and maintain modelling, review and deployment standards so quality does not depend on individuals.
- Coach junior and intermediate engineers through reviews and pairing so the chapter’s capability grows.
Requirements
What You Need
- Matric and a Bachelor’s degree in Data Science, Statistics, Computer Science, Information Systems, Engineering or a related field, or equivalent practical experience.
- 6+ years in analytics engineering, data engineering or advanced analytics, with production ownership of models other teams depend on, and experience setting standards or reviewing other engineers’ work.
- Expert SQL and dimensional modelling at scale.
- Production experience with a declarative transformation framework, including CDC and slowly changing dimensions (Lakeflow Declarative Pipelines or dbt).
- Production experience on Databricks, or a current Databricks Certified Data Engineer Professional certification.
- Strong Git, CI/CD and deployment automation (pull requests, GitHub Actions, Databricks Asset Bundles or equivalent).
- Deep SAP knowledge (BW objects, and S/4HANA or Business Data Cloud) strong enough to lead source interpretation during the migration.
- Working Python — the unit-testing APIs and the chapter’s pipeline framework are Python, and this role sets the testing standard.
Advantageous
- Hands-on Unity Catalog (governance grants, masking, row filters, lineage) and semantic-layer curation through metric views.
- Experience using coding agents (e.g. Claude Code or Codex) in parallel, verified by tests and reconciliation.
- Retail data (ideally pharmacy retail); healthcare or financial services also count.
- A completed migration off a legacy warehouse.
Skills
Sign in to read and join the discussion.