Data & Analytics Engineer III
Analytics
Big Data
Bigdata
Business Intelligence
Cloud Data Engineering
Cloud Data Platform
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Architecture
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Lake
Data Lakehouse
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Database
Databases
Databricks
Databricks Dlt
Databricks Lakehouse
Databricks Lakehouse Platform
Digital Marketing
ETL
Informatica
Information Technology (IT)
Reporting and Analytics
Software Development
Spark
SQL
Visual Design
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