EngineerJobs.io
← Back to all jobs

Job Description

As a technical authority for enterprise analytics, this role designs and governs Gold data products and a centralized Semantic Layer strategy. You will align dimensional models, KPI logic, and governance practices to support trusted, self-service reporting across multiple business domains.

Key Responsibilities

  • Architect, own, and govern end-to-end Gold and Semantic Layer data products across business domains to ensure enterprise-wide consistency and a trusted single source of truth.
  • Lead the design of scalable dimensional models, metrics layers, and self-service analytics frameworks aligned to organizational KPIs and business strategy.
  • Drive cross-functional work to harmonize data definitions, business logic, and data quality SLAs across teams and domains.
  • Establish and continuously improve standards for data quality, observability, lineage, and testing, embedding governance throughout the analytics engineering lifecycle.
  • Act as the primary bridge between data engineering pipelines and BI consumption layers, while mentoring less experienced engineers and raising engineering standards.
  • Architect and lead scalable, production-ready Databricks Gold table design, enforcing star schema, dimensional modeling, and data vault techniques across teams.
  • Use YAML to define and version control table schema configurations, column metadata, and model properties within dbt or similar frameworks.
  • Own centralized Semantic Layer strategy to maintain scalability and consistency across all business domains.
  • Support updates to YAML metric and dimension definition files for the semantic layer tool (for example, dbt Semantic Layer or Cube.dev).
  • Design and implement reusable SQL and Python frameworks to transform silver data into optimized gold assets at scale.
  • Define pipeline configuration parameters and environment variables through YAML config files.
  • Review and approve peer code via Git pull requests, incorporating feedback and maintaining standards.
  • Lead design of enterprise-grade dashboards in Power BI, Databricks, or Tableau, including visualization and performance standards for self-service analytics.
  • Independently build AI automation workflows and LLM-powered tools, including prompt engineering, output validation, and integration of AI-generated insights into Gold and Semantic Layer data products.
  • Evaluate and adopt emerging LLM frameworks and AI tooling to advance analytics automation maturity across the enterprise.
  • Set governance frameworks with automated testing, data quality SLAs, lineage tracking, and Git-based CI/CD pipelines.
  • Use YAML to maintain dbt test configurations (for example, not_null, unique, accepted_values) for Gold layer models.
  • Commit code and configuration changes to Git in alignment with branching and versioning standards.
  • Define documentation standards and oversee creation of data lineage maps, business glossaries, and data dictionary governance.
  • Maintain YAML-based metadata for column descriptions, data types, owners, and business definitions.
  • Identify and resolve Databricks cluster and query performance bottlenecks, implementing long-term optimization strategies.
  • Lead technical discovery sessions with data engineers, data scientists, and business stakeholders, translating requirements into scalable architectures.
  • Mentor less experienced analytics engineers and lead cross-functional data initiatives.

Requirements

  • Bachelor’s degree in Data Science, Computer Science, Information Technology, or a related field, as a typical pathway for understanding analytics engineering and data modeling.
  • 4 years of experience in analytics engineering, data modeling, business intelligence, or data platform development.
  • Hands-on experience designing and owning enterprise-scale Gold and Semantic Layer data products across multiple business domains.
  • Strong SQL knowledge and proficiency in Python (or equivalent scripting languages).
  • Strong understanding of dimensional modeling, metrics layer design, data lineage, and self-service analytics frameworks.
  • Experience implementing data quality, observability, and testing standards in production environments.
  • Strong hands-on experience with Databricks, including Databricks SQL warehouse configuration and optimization, Unity Catalog governance and data access management, and Delta Lake table design and performance tuning.
  • Familiarity with orchestration, DevOps, and CI/CD practices for analytics workflows.
  • Databricks workflows and job orchestration experience, including integration of Databricks with dbt and front-end BI platforms for end-to-end analytics delivery.
  • Advanced proficiency with front-end BI tools such as Power BI, Tableau, or equivalent, including enterprise-scale report and dashboard architecture, semantic model governance, row-level security, and performance optimization.
  • Demonstrated ability to mentor less experienced analytics engineers and lead cross-functional data initiatives.
  • Strong communication skills with technical and non-technical stakeholders, plus the ability to balance priorities in a fast-paced environment while maintaining high engineering standards.

Technologies

SQL, Python, Databricks, Databricks SQL, Unity Catalog, Delta Lake, dbt, Cube.dev, Power BI, Tableau, YAML, Git, CI/CD, LLM-powered tools, AI automation workflows

Benefits

  • Health and financial security options
  • Total Rewards

Preferred Qualifications

  • Databricks accreditations and certifications.
  • Experience in healthcare, payer-provider, clinical, or regulated data environments.
  • Experience mentoring engineers and influencing cross-functional technical direction.
  • Knowledge and experience working with large datasets (300 TB and greater).
  • Strong experience with analytics engineering frameworks such as dbt, semantic layer tools, and cloud-based data platforms on AWS, Azure, or GCP.
  • Experience with governance and secure access models using tools such as Unity Catalog, Lake Formation, or equivalent.
  • Experience supporting AI/ML, feature engineering, vector or unstructured data pipelines, or data products for GenAI use cases.
  • Exposure to infrastructure-as-code, automated testing, and platform engineering practices.
  • Additional related education and/or experience preferred.

Compensation and Location

Location: Phoenix, AZ (remote)

Estimated Pay Range: $47.78 - $79.63 / hour

Salary (listed hourly range): USD 47 - 79 per hourly

Similar Jobs