Analytics Engineer III

Job Description

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.

Job Accountabilities

• Logic Architecture: Exercises independent judgment to architect comprehensive semantic models. Decides where business logic should live to maximize reusability and performance.
• Hybrid Modeling: Independently manages the hybrid semantic estate: optimizing legacy models while engineering the migration to direct lake datasets.
• Security Engineering: Designs and implements complex security frameworks to ensure HIPAA compliance without creating siloed reports.
• Performance Optimization: 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.
• Analytics-as-Code: Implements software engineering best practices for models, managing metadata via code, version control, and pipelines.
• Metric Governance: Defines and implements "calculation groups" to standardize time-intelligence logic across hundreds of metrics, preventing logic drift.
• Mentorship: Formally mentors junior and associate engineers on dimensional modeling standards and advanced DAX patterns.

Education & Certification

• Equivalent experience will be accepted in lieu of the required degree or diploma.
• 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.

Typical Experience

• 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.

Skills & Knowledge

• Strong proficiency in Advanced DAX and SQL.
• Languages: Expert SQL; Advanced DAX.
• Tools: Deep proficiency in Tabular Editor (2 or 3), DAX Studio, ALM Toolkit, and Power BI Service.
• Architecture: Expert knowledge of Dimensional Modeling (Star Schema) and Composite Models.
• Engineering: Experience with CI/CD pipelines for semantic models and Git integration.
• Concepts: Deep understanding of the VertiPaq engine (compression, encoding, materialization).

Requirements

• As Needed

Benefits

• Yes

Position Status

• Exempt

Weekly Hours

• 40

Employee Status

• Regular

Pay Range

• $114,774.40 to $172,161.60 / annual salary

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.