Medicare Value-Based Data Analyst — SQL/BigQuery

WellSky; Overland Park (KS); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

Excellent medical, dental, and vision

Mental Health support via EAP

Paid time off + 13 paid holidays

100% vested 401(K) retirement plans

Educational assistance up to $2500 per

Job summary

WellSky is seeking a Data Analyst for Value-Based Insights to transform CMS Medicare claims data into metrics and benchmarks powering VBI for Home Health and Hospice. You will build data extracts, translate CMS methodologies into production SQL, and collaborate with product and engineering to deliver trusted insights.

This role emphasizes retrospective analysis, data quality, and auditable results, with downstream BI visualization support and stakeholder collaboration.

Qualifications

• Bachelor's degree in quantitative, health-informatics, or related field.
• 2-4 years of experience in data analysis with SQL against large datasets.
• Direct experience working with Medicare CMS claims data (CCW, LDS, LDS/RIF files).
• Comfort with healthcare claims coding structures (ICD, HCPCS/CPT, DRGs).
• Ability to translate specifications into analytical logic and validate results.

Responsibilities

• Build and maintain claims-based data extracts and measures from CMS data sources, including CCW and LDS, to support VBI Home Health and Hospice solutions.
• Develop and maintain performance measures such as HHVBP claims-based measures and utilization metrics.
• Translate CMS methodologies into production SQL logic and optimize queries.
• Write and optimize SQL against large datasets in BigQuery; contribute to data pipelines and automated extracts.
• Produce market extracts and validate outputs against CMS benchmarks and client expectations.
• Investigate data quality issues and document methodology for auditable results.
• Prepare data for downstream BI/visualization layers (e.g., Sisense) and collaborate on requirements.

Skills

Analytical thinking

Attention to detail

Translate specifications into analysis

Education

Bachelor's degree in quantitative health-informatics or related field

Tools

BigQuery

SQL

Snowflake

Sisense

Tableau

Power BI

Python

Job description

WellSky is seeking a Data Analyst for Value-Based Insights to transform CMS Medicare claims data into metrics and benchmarks powering VBI for Home Health and Hospice. You will build data extracts, translate CMS methodologies into production SQL, and collaborate with product and engineering to deliver trusted insights.

This role emphasizes retrospective analysis, data quality, and auditable results, with downstream BI visualization support and stakeholder collaboration.