Corporate - Healthcare Data Analyst II

Carepointhc; Colorado; Híbrido; USD 104.000 - 140.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health/Dental/Vision insurance

Employee Assistance Program

Paid time off

401(k) and life insurance

Descripción de la vacante

CarePoint in Greenwood Village, CO is seeking a Healthcare Data Analyst II to design, develop, and implement advanced analytical solutions across clinical service lines. The role acts as the Power BI architect and coordinates PostgreSQL data infrastructures to drive quality, patient experience, and revenue insights.

You will work with executive leadership on KPI definitions, build enterprise data models, and lead ETL processes using Python and AWS Lambda while ensuring HIPAA compliance and data

Formación

• Master’s degree or equivalent in Business Analytics, Data Science, or Database Technologies.
• 12 months of experience in data analytics/data science or business intelligence.
• Experience with ICD-10 and CPT codes for clinical and financial data modeling.
• Experience with PostgreSQL, SQL, and enterprise data modeling in Power BI.

Responsabilidades

• Design and implement advanced analyses and predictive models to improve operational efficiency.
• Develop enterprise-level data models and dashboards in Power BI for clinical and operational metrics.
• Lead ETL processes and data pipelines using Python and AWS Lambda.
• Ensure data accuracy, integrity, and HIPAA compliance across service lines.
• Collaborate with executive leadership to translate business needs into analytical roadmaps.

Conocimientos

Python

R

SQL

Power BI

Educación

Master’s degree in Business Analytics, Data Science, or Database Technologies

Herramientas

PostgreSQL

AWS Lambda

Power Query

DAX

Power BI

Descripción del empleo

CarePoint is seeking a full-time Healthcare Data Analyst II in Greenwood Village, CO. The Healthcare Data Analyst II contributes to the strategic design, development, and implementation of advanced analytical solutions and data systems across CarePoint’s clinical service lines. This role supports data initiatives in high-impact areas, including Emergency Medicine, Teleneurology, Hospitalist Medicine, and Inpatient Neurology. The Data Analyst II acts as an architect for the Power BI environment, manages complex PostgreSQL database infrastructures, and conducts high-level requirements gathering with executive leadership. They translate clinical and business needs into predictive data models encompassing clinical quality, operations, patient experience, and revenue performance.

About CarePoint

Our administrative and management staff provide a host of services, from operations support to legal services and everything in between, to support 600+ physicians and advanced practice providers in 11 different clinical settings. The nonclinical support our employees provide enable our clinical professionals, who work in dozens of emergency departments and hundreds of hospitals across the U.S., to remain laser-focused on what matters most — providing the highest level of care to patients each and every day.

This is a full‑time hybrid position located in Greenwood Village, CO, accompanied by a yearly salary ranging from $103,854 to $140,000, and a comprehensive benefits package designed to support your health, financial well‑being, and work‑life balance.

Key Responsibilities

Advanced Analytics & Predictive Modeling:

• Design and execute complex statistical analyses and predictive models using Python and R (regression, trend forecasting, and clinical variability modeling) to drive operational efficiency in high‑acuity environments.
• Develop enterprise‑level data models in Power BI using DAX, Power Query (M), and SQL to provide deep‑dive insights into clinical quality of care and patient experience metrics.
• Perform advanced statistical outlier detection and analysis to identify anomalies in clinical performance, patient throughput, and other relevant metrics, ensuring data integrity and driving targeted process improvements.
• Triangulate disparate data sets—synthesizing clinical quality, financial, and operational data—to identify systemic process improvements and cost‑saving opportunities.
• Apply expertise in healthcare coding taxonomies (ICD‑10 and CPT) to analyze clinical outcomes and service utilization across multi‑specialty portfolios.
• Ensure data accuracy, integrity, and compliance with healthcare regulations (HIPAA, PHI handling)

Strategic Requirements Gathering & Consultation:

• Participate in formal requirements gathering sessions with senior leadership to define Key Performance Indicators (KPIs) related to healthcare operations, clinical quality, provider productivity, and revenue cycle performance.
• Translate complex business objectives regarding emergency medicine, hospitalist, and neurology (both inpatient and teleneurology) service lines into structured technical specifications and analytical roadmaps.
• Present actionable findings and recommendations to administration, directly influencing operational and financial decision‑making.
• Assists in the architecture and maintenance of complex PostgreSQL database structures to support high‑volume healthcare data ingestion across multiple clinical service lines.
• Develop and maintain advanced ETL processes and data pipelines using AWS Lambda functions and Python to ensure seamless data flow from multiple sources.
• Optimize advanced SQL queries and stored procedures to ensure high performance of real‑time dashboards monitoring productivity and revenue.
• Help establish and enforce data governance standards, ensuring the accuracy and integrity of clinical and financial data dictionaries and documentation.
• Automation & Process Leadership
• Support the identification and implementation of enterprise‑level automation for data collection and cleaning processes using Python scripts, establishing scalable and repeatable system designs.
• Mentor junior staff on data visualization best practices, Power BI development, advanced SQL techniques, and Python‑based data manipulation.
• Follow quality control processes to ensure the continuity, accuracy, and quality of all data products delivered to internal and external stakeholders.

Qualifications

This position requires a Master’s degree or equivalent in Business Analytics, Data Science, or Database Technologies, and 12 months of experience in data analytics/data science or business intelligence. Must also have 12 months of experience with each of the following: 1) Working with ICD‑10 diagnostic and CPT procedure codes for clinical and financial data modeling. 2) Working with large relational databases and PostgreSQL (data manipulation and management: complex joins, CTEs, query optimization, window functions, nested subqueries). 3) Working with Power BI, including enterprise‑level dashboard development, data modeling, DAX, M, advanced data visualization, and app development. 4) Using R and Python (including ETL, data wrangling, automation, and statistical libraries). 5) Performing analyses of clinical healthcare data in Emergency Medicine, Hospitalist Medicine, Teleneurology, and Inpatient Neurology related to clinical quality, healthcare operations, patient experience (including Press Ganey data), productivity, and revenue. 6) Performing exploratory data analysis, descriptive and predictive analytics, forecasting, and regression modeling. 7) Performing high‑level requirements gathering and presenting technical data effectively to non‑technical executive stakeholders. Will accept experience gained before, during or after Master’s program. Employer will accept experience gained concurrently.

• Comprehensive health coverage, including medical, dental, and vision insurance, with access to a Health Savings Account (HSA).
• Wellbeing and support resources, including an Employee Assistance Program offering confidential counseling and support services.
• Time away from work benefits, featuring accrued paid time off that increases with tenure, along with paid parental leave.
• Financial security and protection, including a 401(k) retirement plan, life insurance, and identity theft protection.

More about CarePoint

Carepoint is a rapidly growing, mission‑driven organization dedicated to delivering exceptional, patient‑centered care. We operate at the intersection of technology and healthcare, focusing on innovative solutions to improve health outcomes and enhance the patient experience. We value collaboration, integrity, and continuous improvement, striving to create a dynamic and supportive environment for our employees to thrive.

Our Values

• Collaboration and Teamwork: We work in partnership with patients, fellow providers, and each other. It is through partnerships that we are able to achieve great work.
• Communication and Transparency: We pride ourselves on practicing open communication with all CarePoint members. As a physician‑owned and led management services organization and practice, we hold transparency as one of our top core values and seek to communicate often and well.
• Sustainability and Innovation: We seek to honor our history by working hard to preserve our culture and unique model. We simultaneously want to be a part of the evolving world of healthcare and invest in future models of care delivery.