Principal Data Architect

Serenity Mental Health Centers • Lehi, UT

2d • Onsite

About The Position

Own the architecture and strategy for a modern, enterprise-wide data ecosystem
Build scalable pipelines and data models that support clinical, operational, and business insights
Partner with leadership to turn data into a competitive advantage across the organization

Requirements

• 8+ years of experience in data architecture, data engineering, or similar roles
• Advanced expertise in SQL Server, including T-SQL and performance tuning
• Strong experience building ETL/ELT pipelines (SSIS, Azure Data Factory, dbt, or similar)
• Deep understanding of dimensional data modeling and data warehousing concepts
• Experience with Power BI (DAX, Power Query, data modeling, security)
• Strong understanding of data security and compliance standards (HIPAA)
• Proven ability to lead complex technical projects end-to-end

Nice To Haves

• Experience in healthcare or behavioral health environments
• Familiarity with EMR systems (eClinicalWorks or similar)
• Experience building “Customer/Patient 360” data models
• Exposure to modern data stack tools and cloud-based architectures

Responsibilities

• Design and maintain end-to-end data architecture to support scalability and performance
• Build and optimize ETL/ELT pipelines from multiple data sources into a centralized warehouse
• Develop dimensional data models (star/snowflake schemas) for analytics and reporting
• Create semantic layers and backend structures for Power BI dashboards and reporting
• Architect a unified data view across clinical, operational, and customer data sources

Benefits

• Competitive salary
• Excellent Benefits – 90% coverage for medical, dental, and vision
• 401(k) – Investing in your future with us
• Paid Time Off – 10 PTO days (15 after your first year) + 10 paid holidays to rest and recharge

What This Job Offers

• Job Type: Full-time
• Career Level: Principal
• Education Level: No Education Listed
• Number of Employees: 1-10 employees