Healthcare Data Analyst

Transcend IT Solutions; Minneapolis (MN); Hybrid; USD 55,000 - 96,000; Part time

Job summary

Transcend IT Solutions is seeking a Healthcare Data Analyst for a contract role in Edina, MN (Hybrid - 3 days/week). The candidate will lead analytics on large-scale healthcare datasets, including CMS QE claims data and ICD/CPT coding, and will design governance and QA frameworks.

The role requires 3+ years of experience with healthcare data systems, advanced SQL skills, and experience with Alteryx workflows, ETL/ELT processes, and data warehouses.

Qualifications

• 3+ years of experience working with large-scale healthcare data systems and datasets.
• Experience with CMS QE claims data, ICD-9-CM/ICD-10-CM/ICD-10-PCS, CPT/HCPCS coding.
• Experience designing and maintaining healthcare data warehouses and master datasets using SQL Server and ETL/ELT workflows.
• Ability to implement data governance, quality assurance, validation rules, and reconciliation processes.

Responsibilities

• Lead healthcare data extraction and analytics initiatives using advanced SQL.
• Develop and maintain Alteryx workflows for data processing.
• Support data governance activities including validation and audit documentation.
• Collaborate on longitudinal data consistency checks and data quality assessments.

Skills

Healthcare data analytics

Data governance

Quality assurance

Regulatory compliance

Analytical thinking

Stakeholder communication

Tools

SQL Server

Stored procedures

ETL/ELT workflows

Alteryx

Data warehouses

Job description

Position Title : Healthcare Data Analyst

Location: Edina, MN (Hybrid - 3 days/week)

Employment Type: Contract

Mandatory Requirements (3+ years of experience in each):

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, and clinical data management
• Developing and maintaining healthcare data warehouses and master datasets using:
• SQL Server
• Relational databases
• Stored procedures
• ETL/ELT workflows

Designing and implementing data governance and quality assurance frameworks, including:

• Validation rules
• Reconciliation processes
• Longitudinal data consistency checks
• Audit documentation for regulated healthcare data
• Leading healthcare data extraction and analytics initiatives using:
• Advanced SQL querying
• Alteryx workflows