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