Data Analyst – Technical – Senior

Intermountain Health•Murray, UT

8d•Hybrid

About The Position

Serve as the primary data analyst supporting management-level leadership of a system business or clinical domain. Leverage deep clinical and technical expertise and healthcare data to provide insights and solutions to customers and the organization. Use advanced SQL to develop technical products and support strategic initiatives and operational targets while ensuring customer data integrity and accuracy. Create visually appealing, content-rich, consumer-centric reports and dashboards using Cognos and Tableau. Drive insights through data exploration, interpretation, report development, and visual storytelling. Provide ongoing training, maintenance, monitoring, and promotion of data applications and reports so insights are widely known, accessible, and useful across the organization. Meet regularly with customer stakeholders to provide work updates, set project priorities, establish deliverable timelines, and ensure priorities are understood and resourced. Proactively analyze business performance, investigate opportunities to improve efficiency and productivity, and seek collaboration between teams to enhance analytic services. The position is based at Intermountain Medical Center in Murray, Utah, and may telecommute two days per week from home within a reasonable commuting distance of Murray. The position is permanent direct hire; contract labor applications will not be considered. Applicants are subject to drug testing or screening and background checks upon hire.

Requirements

Master’s degree or equivalent foreign education in Statistics, Mathematics, Information Systems and Assurance, or Computer Science; alternatively, a bachelor’s degree or equivalent foreign education in one of these disciplines and two years of experience.
Knowledge of advanced SQL and database design, including window functions, CTEs, query optimization, performance tuning, and dimensional modeling.
Knowledge of advanced Excel, including Power Query, nested logic, and dynamic arrays.
Knowledge of Tableau, including LOD expressions, data blending, dashboard actions, and executive-ready storytelling.
Knowledge of R and Python for data wrangling, pipeline automation, and statistical or predictive modeling.
Knowledge of user experience design for analytics products.
Knowledge of Jira and Scaled Agile Framework (SAFe) practices and cross-functional collaboration.
Knowledge of hospital operating room workflow, through experience as a clinician working in an operating room or as a data analyst working with operating room data and problems.
Knowledge of validation and QA methods for self-generated and peer content, including reconciliation, anomaly detection, and unit checks.
Knowledge of healthcare billing and clinical coding, including ICD-9/ICD-10, CPT, HCPCS, and MS-DRG assignment logic.
Knowledge of claims data analysis and surgical cohort definition, integrating financial data with case data.
Knowledge of National Surgical Databases and Registries (Seer Medicare, NTDB, HCUP, TQIP), including extracting, transforming, and statistically benchmarking against internal clinical outcomes.
Knowledge of report automation, KPI design, and stakeholder enablement.
Knowledge of GIS-based socioeconomic scoring methods (ADI, SVI) leveraging US Census data.
Applicants must provide a resume and responses to pre-screening questions to be considered.

Responsibilities

Serve as the primary data analyst supporting management-level leadership of a system business or clinical domain.
Use healthcare data and clinical and technical expertise to provide data insights and solutions.
Use advanced SQL to develop technical products and enable strategic initiatives and operational targets.
Ensure the integrity and accuracy of customer data.
Create reports and dashboards using Cognos and Tableau.
Drive insights through data exploration, interpretation, report development, and visual storytelling.
Provide ongoing training, maintenance, monitoring, and promotion of data applications and reports.
Facilitate regular stakeholder meetings to provide updates, set priorities, establish timelines, and ensure customer priorities are understood and resourced.
Analyze business performance and communicate areas for improvement in efficiency and productivity.
Seek opportunities for collaboration between teams to enhance analytic services.