Healthcare Data Analyst

Talentola; Edina (MN); Hybrid; USD 85,000 - 115,000; Full time

Job summary

Talentola is seeking a data analytics professional to develop and maintain a comprehensive Integrated Insights Data Warehouse for healthcare data, including QE datasets and complex ETL processes. You will lead data projects, design governance, and automate workflows using Power Automate.

The role emphasizes cross-state analysis, dashboard development for KPI tracking, and collaboration with development teams to ensure data quality and regulatory compliance.

Qualifications

• Master's degree or equivalent in Statistics, Health Informatics and Analytics, or a related field.
• 3 years of experience in a data analyst or related occupation.
• 36 months of experience with CMS QE data, ICD-9-CM/10-CM/PCS, CPT/HCPCS codes, and healthcare claims data.
• Experience in constructing and maintaining healthcare data warehouses and master datasets with SQL Server and ETL/ELT workflows.
• Experience leading data extraction and analytics projects using SQL, Alteryx, and automation.

Responsibilities

• Develop and maintain Integrated Insights Data Warehouse using statistical methods and workflows for healthcare data ingestion, transformation, validation, and QA.
• Collect, organize, interpret, and summarize numerical data to provide usable information.
• Oversee data workflows including QE state-level ETL processes and SQL-based transformations across large healthcare datasets.
• Architect and maintain healthcare data warehouses enabling longitudinal, cross-state analysis for provider performance and regulatory compliance.
• Lead QE data projects with ingestion, standardization, validation, and de-identification in compliance with privacy rules.
• Perform gap analyses to map business requirements to technical designs and ensure standards.
• Develop automated workflows with Power Automate for use case submissions, approvals, and analytics requests.
• Design and develop dashboards tracking quarterly and YoY KPI metrics and vendor contract management.

Skills

Statistical analysis

SQL

Alteryx

ETL/ELT

Dashboarding

Power Automate

Education

Master's degree in Statistics, Health Informatics and Analytics, or related field

Tools

SQL Server

Alteryx

Power Automate

Job description

Key Responsibilities

Develop and maintain Integrated Insights Data Warehouse by using statistical methods to design, implement, and manage software and data workflows used for ingesting, transforming, validating, and performing quality assurance of third-party healthcare data.

Collect, organize, interpret, and summarize numerical data to provide usable information.

Manage the implementation, enhancement, and ongoing maintenance of new and existing data workflows, including state-level ETL processes and SQL-based transformations, and identify opportunities to improve data acquisition, standardization, quality assurance, and delivery across large-scale healthcare datasets.

Architect and maintain healthcare data warehouses and master datasets using SQL Server, Alteryx, and orchestration frameworks, enabling longitudinal, cross-state analysis critical to provider performance measurement and regulatory compliance.

Lead healthcare data projects involving CMS Qualified Entity (QE) datasets, including data ingestion, standardization, validation, and de-identification of healthcare records in compliance with regulatory and privacy requirements.

Conduct gap analysis to identify solutions that meet documented business requirements and collaborate with development teams to ensure technical designs meet established standards.

Develop automated business and operational workflows using Power Automate to support processes such as use case submissions, approval management, operational tracking, and analytics request fulfillment.

Design and develop analytical dashboards to track quarterly and year-over-year key performance indicator (KPI) metrics and to support monitoring and management of vendor contracts, including renewal timelines and notifications.

Uses the following tools and technologies:

SQL Server (SSMS), Relational Database Management Systems, Advanced SQL, Alteryx, ETL/ELT Data Processing Frameworks, Data Warehousing Architectures, Healthcare Claims and Discharge Data, CMS Qualified Entity (QE) Data, ICD-9-CM, ICD-10-CM, ICD-10-PCS, CPT/HCPCS Diagnosis and Procedure Coding

Systems Qualifications:

Minimum Requirements: This position requires a Master's degree or equivalent in Statistics, Health Informatics and Analytics, or a related field and 3 years of experience in a data analyst or related occupation.

Must also have 36 months of experience with each of the following:

1. Working with large-scale healthcare data systems, including CMS Qualified Entity (QE) claims data, ICD-9-CM, ICD-10-CM, ICD-10-PCS, CPT/HCPCS diagnosis and procedure codes, healthcare claims data, insurance adjudication processes, and clinical data management.
2. Developing and maintaining healthcare data warehouses and master datasets using the following: SQL Server, relational database structures, stored procedures, and ETL/ELT workflows.
3. Designing and implementing data governance and quality assurance frameworks using validation rules, reconciliation processes, longitudinal data consistency checks, and audit documentation for regulated healthcare data.
4. Leading healthcare data extraction and analytics projects using SQL-based querying, Alteryx workflows, and automation.

Work Location:

Edina, MN (Hybrid-3 days/week in office)

Duration:

12 + months