Staff Analytics Engineer, Databricks (R5493)

Remote; San Francisco (CA); On-site; USD 150,000 - 210,000; Full time

Job summary

Remote is seeking an Staff Analytics Engineer to own the Gold layer and enterprise semantic layer within the Databricks lakehouse. You will translate approved KPI definitions into auditable transformation logic and durable analytics models used across multiple domains.

You will collaborate with business stakeholders to clarify metrics, enforce governance, and enable domain teams with modeling standards and reusable patterns, not as the sole owner of every downstream use case.

Qualifications

• 8+ years in analytics, BI or data engineering with strong dimensional modeling.
• Hands-on Databricks experience including Delta Lake and Spark SQL or PySpark.
• Ability to translate KPI requests into precise, auditable logic.
• Strong SQL and dimensional modeling fundamentals (star schemas, SCD).
• Proven ability to work with business stakeholders on metric definitions.
• Understanding of underlying business processes behind metrics.
• Experience evaluating data exposure with governance constraints.
• Familiarity with BI tools and governed self-service analytics.

Responsibilities

• Own Gold-layer design and delivery, including facts, dimensions, and data marts.
• Build and maintain enterprise semantic layer with governed models and metrics.
• Translate KPI definitions into precise, auditable transformations.
• Define promotion path from domain Gold to enterprise Gold with governance sign-off.
• Collaborate with stakeholders to clarify KPI definitions and resolve ambiguity.
• Create reusable patterns, standards, and coaching for domain teams.
• Review Gold-layer models for correctness and conformance.
• Optimize structures for BI and self-service analytics while preserving traceability.

Skills

Dimensional modeling

Analytics engineering

BI engineering

Data engineering

Databricks

Delta Lake

Spark SQL / PySpark

Semantic layer

KPI translation

SQL

Stakeholder engagement

Business domain knowledge

Data governance

BI tools

Governed analytics

Peer review

Tools

dbt

Databricks certification

KPI registry tooling

Job description

Job Description:

The Staff Analytics Engineer owns the Gold layer and enterprise semantic layer of the Databricks lakehouse, where clean and governed Silver-layer data becomes trusted, business-ready models, KPIs, and semantic assets. This role translates approved business definitions into auditable transformation logic and durable analytics models that can be used consistently across multiple domains.

This role is expected to go beyond technical model building. The Analytics Engineer must understand the business meaning of the data being modeled, the operational context behind key metrics, and the classification or usage constraints that affect how data can be exposed, joined, governed, and consumed in a regulated environment.

What you'll do:

• Own Gold-layer design and delivery, including facts, dimensions, domain data marts, and governed KPI implementations on Databricks.

• Build and maintain the enterprise semantic layer through curated views, governed semantic models, metric definitions, and reusable patterns for trusted business consumption.

• Translate approved KPI and metric definitions into precise, testable, auditable transformation logic that matches agreed business meaning.

• Define and enforce the promotion path from domain Gold to enterprise Gold, ensuring shared metrics are not published without required business and governance sign-off.

• Partner directly with business stakeholders across domains to clarify KPI definitions, challenge ambiguity, and resolve competing definitions before implementation.

• Enable domain teams by creating modeling standards, reusable design patterns, review processes, and coaching mechanisms rather than acting as the long-term owner of every downstream use case.

• Review Gold-layer models created by other teams or partners for correctness, definition integrity, usability, and conformance to enterprise standards.

• Optimize Gold-layer structures for BI and self-service analytics consumption while preserving traceability, governance, and metric consistency.

• Ensure semantic models, tables, columns, ownership, and business definitions are documented and discoverable.

• Apply awareness of data sensitivity, classification, and approved use when designing joins, dimensions, semantic views, and access patterns so the semantic layer reflects both business meaning and compliance requirements.

Required qualifications:

• 8+ years of experience in analytics engineering, BI engineering, or data engineering with strong dimensional modeling expertise.

• Hands-on Databricks experience, including Delta Lake and Spark SQL and/or PySpark, with strong familiarity with semantic-layer concepts.

• Demonstrated experience translating ambiguous business KPI requests into precise and auditable transformation logic.

• Strong SQL and data modeling fundamentals, including star schemas, fact and dimension design, and slowly changing dimensions.

• Ability to work directly with business stakeholders and serve as a strong technical counterpart on metric definitions and model quality.

• Demonstrated ability to understand the underlying business processes and data domains behind the metrics being modeled, not just implement requested transformations.

• Ability to evaluate whether data can and should be exposed in a semantic layer based on sensitivity, ownership, classification, and policy constraints.

• Experience with BI tools and an understanding of how semantic models support governed self-service analytics.

• Track record of reviewing another team's models for correctness, quality, and alignment with shared definitions.

Preferred qualifications:

• Experience with dbt or comparable transformation frameworks on Databricks.

• Experience building or maintaining a KPI registry, metrics layer, semantic layer, or comparable governance artifact.

• Experience in a multi-domain enterprise environment where metrics and definitions overlap across business areas.

• Databricks certification or comparable evidence of advanced platform expertise.

• Experience in defense, aerospace, financial services, healthcare, or another highly regulated environment.