Data Analyst Job at WellSky, Overland Park, KS

ajV6Q3FzRFZvYkVJS0pseHRTakpIUTMyRVE9PQ==
  • WellSky
  • Overland Park, KS

Job Description

The Data Analyst for Value-Based Insights (VBI) is responsible for transforming Medicare (CMS) claims data into metrics, benchmarks, and measures that power WellSky's VBI product for Home Health and Hospice providers and payers. This role builds and maintains claims-based data extracts and performance measures, translates CMS methodologies and regulatory rules into production analytics, and partners with product and engineering to deliver trusted, data-driven insights. The work is retrospective, methodology-driven, and directly tied to how agencies measure and improve value-based performance.

Key Responsibilities

  • Build and maintain claims-based data extracts and measures from CMS data sources, including the Chronic Conditions Warehouse (CCW) and Limited Data Set (LDS), to support VBI Home Health and Hospice solutions.
  • Develop and maintain performance measures such as HHVBP claims-based measures, MSPB-PAC, Functional Items, hospitalization/ER/PPH/DTC rates, utilization and efficiency metrics, length of stay, and composite/percentile scores.
  • Interpret CMS regulations and annual Final Rules (e.g., HHVBP methodology, eTPS calculations) and translate measure specifications into accurate, reproducible SQL logic.
  • Write and optimize SQL against large claims datasets in BigQuery; contribute to data pipelines, quarterly lookup-table refreshes, and extract automation.
  • Produce referral pattern, competitive analysis, market/benchmark extracts, and validate outputs against CMS public benchmarks (e.g., Home Health Compare) and client expectations.
  • Investigate data quality issues and metric discrepancies, and document methodology, data sources, and assumptions so results are auditable and repeatable.
  • Prepare data for downstream BI/visualization layers (e.g., Sisense) and collaborate with product managers and engineers to define technical requirements and analytical interpretations.
  • Perform other job duties as assigned.

Required Qualifications

  • Bachelor's degree in quantitative, health-informatics, or related field, or equivalent work experience.
  • 2–4 years of experience in data analysis, with demonstrated proficiency in SQL against large, complex datasets.
  • Direct experience working with Medicare/CMS claims data (e.g., CCW, LDS, LDS/RIF files, or comparable claims sources).
  • Comfort with healthcare claims coding structures (e.g., ICD, HCPCS/CPT, revenue codes, DRGs).
  • Ability to translate written specifications or methodologies into analytical logic and validate results for accuracy.

Preferred Qualifications

  • Knowledge of Home Health and/or Hospice operations, post-acute care, or value-based care programs (e.g., HHVBP, HHVBP eTPS, hospice HIS/HOPE).
  • Experience with CMS quality/value-based program methodologies and familiarity with reading CMS regulations/Final Rules.
  • Hands-on experience with BigQuery (or a comparable cloud data warehouse such as Snowflake) and a BI tool such as Sisense, Tableau, or Power BI.
  • Familiarity with risk adjustment or benchmarking concepts.
  • Scripting experience (e.g., Python) for data transformation and automation.

Job Expectations

  • Willing to work additional or irregular hours as needed, particularly around quarterly CMS data refreshes and annual Final Rule cycles.
  • Must work in accordance with applicable security and HIPAA policies to safeguard company and client protected health information.
  • Must be able to sit and view a computer screen for extended periods of time.

WellSky is where independent thinking and collaboration come together to create an authentic culture. We thrive on innovation, inclusiveness, and cohesive perspectives. At WellSky you can make a difference.

WellSky provides equal employment opportunities to all people without regard to race, color, national origin, ancestry, citizenship, age, religion, gender, sex, sexual orientation, gender identity, gender expression, marital status, pregnancy, physical or mental disability, protected medical condition, genetic information, military service, veteran status, or any other status or characteristic protected by law. WellSky is proud to be a drug-free workplace.

Applicants for U.S.-based positions with WellSky must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire. Certain client-facing positions may be required to comply with applicable requirements, such as immunizations and occupational health mandates.

Here are some of the exciting benefits full-time teammates are eligible to receive at WellSky:

  • Excellent medical with Rx, dental, and vision benefits
  • Mental Health support through EAP
  • Generous paid time off, plus 13 paid holidays
  • 100% vested 401(K) retirement plans
  • Educational assistance up to $2500 per year

Job Tags

Full time, Work experience placement

Similar Jobs

Waynesburg University

Graduate Assistantship - Sports Information Job at Waynesburg University

 ...Position entails working 19 hours a week in the Sports Information Office. The sports...  ...Crew or NCAA statistical software systemPublic address announcingAssisting with home event...  ..., English, communication or a sport-related field is required. Applicants should have... 

NYC Health + Hospitals/Harlem

Non-Invasive Cardiologist Job at NYC Health + Hospitals/Harlem

 ...Description Physician Affiliate Group of New York (PAGNY) is adding a Non-InvasiveCardiologist to the group at NYC Health + Hospitals/Harlem . Harlem Hospital is the largest hospital in Central Harlem and the only Safety Net Hospital in Northern Manhattan. Harlem... 

Atlean World

Remote International Recruitment Consultant Job at Atlean World

 ...multilingual markets making the candidates recruitment journey smoother and more enjoyable....  ...Without Boundaries! We are offering a great work experience as an International...  ...-Center, Sales & Marketing) to work from home. Your Role As an International Recruiter... 

Amneal Pharmaceuticals

Sales Representative (Milwaukee, WI - PD) Job at Amneal Pharmaceuticals

Description: The Sales Representative implements tactics as defined by the Marketing and Sales plans for the Neurology Team. They deliver balanced sales presentations to a defined list of current and prospective customers with a defined frequency. In the assigned territory... 

Everglades Equipment Group

Small Engine Mechanic Job at Everglades Equipment Group

 ...equipment with a focus on 2-stroke and Stihl equipment. Candidate will be required to demonstrate a variety of skills from basic mechanical to complex technical diagnostics of modern computerized systems. Must be able to provide own basic tool kit. Must be able to navigate...