Analytics Engineer III

Sutter Health•Sacramento, CA

1d•$114,774 - $172,162•Hybrid

About The Position

The Analytics Engineer 3 is a specialized mid-level technical professional who exercises independent judgment to architect, engineer, and govern the enterprise "Semantic Layer." This role acts as a "Logic Architect," designing reusable data models, security frameworks, and metric definitions that serve as the Single Source of Truth for the organization. This position is a key independent contributor and member of the System Data & Analytics team in Digital. The Analytics Engineer 3 is responsible for the full lifecycle engineering of the department's semantic infrastructure. This role requires the exercise of discretion to determine the appropriate modeling strategy—choosing between Import, DirectQuery, or Direct Lake modes—to balance performance with data freshness. The ideal candidate moves fluidly between managing legacy SSAS partitions and architecting modern Microsoft Fabric semantic models using engineering tools like Tabular Editor and ALM Toolkit. This role operates with minimal oversight, defining the governance and security logic for their domain. Sutter Health is an equal opportunity employer EOE/M/F/Disability/Veterans. The compensation range may vary based on the geographic location where the position is filled. Total compensation considers multiple factors, including, but not limited to a candidate’s experience, education, skills, licensure, certifications, departmental equity, training, and organizational needs. Base pay is only one component of Sutter Health’s comprehensive total rewards program. Eligible positions also include a comprehensive benefits package. Working at Sutter Health Sutter Health values and supports the unique talents and strengths that each employee brings to our organization. As a result, you are empowered to apply your passion for healing in innovative ways to care for patients and their families.

Requirements

Bachelor's degree in Computer Science, Information Systems, Engineering, or a related technical field
Epic Cogito Certification within one year of start date.
Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) within one year of start date.
6 years of progressive experience in analytics engineering, business intelligence architecture, or semantic modeling.
Experience independently architecting enterprise-grade data models.
Experience managing the application lifecycle management of tabular models.
Strong proficiency in Advanced DAX and SQL.
Expert SQL; Advanced DAX.
Deep proficiency in Tabular Editor (2 or 3), DAX Studio, ALM Toolkit, and Power BI Service.
Expert knowledge of Dimensional Modeling (Star Schema) and Composite Models.
Experience with CI/CD pipelines for semantic models and Git integration.
Deep understanding of the VertiPaq engine (compression, encoding, materialization).

Responsibilities

Exercises independent judgment to architect comprehensive semantic models.
Decides where business logic should live to maximize reusability and performance.
Independently manages the hybrid semantic estate: optimizing legacy models while engineering the migration to direct lake datasets.
Designs and implements complex security frameworks to ensure HIPAA compliance without creating siloed reports.
Engineers high-performance models by managing the engine. Analyzes compression ratios, cardinality, and query plans in data analysis expressions (DAX) studio to reduce memory footprint and latency.
Implements software engineering best practices for models, managing metadata via code, version control, and pipelines.
Defines and implements "calculation groups" to standardize time-intelligence logic across hundreds of metrics, preventing logic drift.
Formally mentors junior and associate engineers on dimensional modeling standards and advanced DAX patterns.