Health Care Claims Data Programmer

About HCCI

The Health Care Cost Institute (HCCI) is an independent, non-profit research institute located in Washington, D.C. with a mission to use data and analytics to improve the US health care system. Employers, policymakers, and researchers rely on HCCI’s claims data to better understand the health care system, evaluate existing and emerging coverage and payment policies, and assess health care quality. Our multi-disciplinary team produces timely, policy-relevant reports and analyses in an academic but fast-paced environment.

Join the Team that Informs the Health Care Decision Making

We are looking for a Health Care Claims Data Programmer to join our dynamic team working to advance HCCI’s mission. This position is ideal for candidates with extensive experience working with health care claims data and who are seeking opportunities to conduct high-profile analytics. The Health Care Claims Data Programmer will support HCCI’s efforts to provide stakeholders with information to help them make informed decisions to improve the value of health care.

The Health Care Claims Data Programmer will:

• Apply working knowledge of health care claims structures to execute methodologically sound analyses.
• Write and optimize complex SQL queries against large relational claims databases for analyses on health care spending, price, use, and quality.
• Independently navigate database schemas to replicate documented existing analyses and develop code and documentation for new analyses, keep document specifications up to date.
• Proactively benchmark findings to publicly available studies and internal research findings, enhancing reliability of analyses, initiating data quality and code audits as part of the results review process.
• Partner with project leads to design and populate analyses with accurate, correctly structured data.
• Work with senior staff to develop and implement statistical analyses for cohort studies using SAS, R, Python, or Stata.
• Develop, maintain, and update all documentation, including technical specifications and methodologies, and effectively communicate changes to project stakeholders.
• Respond to internal and external stakeholder requests and support ad hoc data requests and special projects as needed.
• Promote and present findings and tailored data products to various audiences of all data literacy levels in a timely, professional, customer-service-oriented manner.
• Support HCCI’s organizational operational activities as needed (e.g. help write proposals, liaise with external stakeholders, etc.)

In our candidates, we look for:

• Demonstrated experience and skillset assembling, understanding, and analyzing health care claims data. A combined 4+ years of experience working in Medicare, Medicaid, and/or commercial claims database required.
• The candidate must have at least 1 year of professional experience programming analyses in the CMS Virtual Research Data Center (VRDC).
• Excellent analytical skills and strong quantitative and programming skills, including extensive demonstrated experience using SQL, SAS, or other programming languages to manage and analyze big data.
• Bachelor’s degree in economics, mathematics, social science, informatics, or other quantitative field preferred.
• Experience developing analyses from claims data.
• Ability to communicate clearly, verbally and in writing, especially about quantitative findings for non-quantitative audiences.
• Detail oriented problem solvers with a sense of resourcefulness.
• Excellent organizational and time management skills with the ability to organize, prioritize, and manage multiple projects at once.
• Ability to work in a collegial and learning work environment and serve as resource for other team members.
• An entrepreneurial spirit and a desire to work in a high-impact, mission-driven environment.

This is a full-time, exempt, position with an annual salary range from $75,000 to $95,000, depending on experience. HCCI also provides competitive benefits to full-time employees, including 403B retirement with employer contribution and health insurance.

This position is remote eligible, with occasional travel to the Washington, DC office. Preference will be given to applicants located in states where HCCI is currently registered as an employer – Washington, DC, Maryland, Virginia, Pennsylvania, New York, Massachusetts and Minnesota. Regardless of work location, this position requires East Coast hours.

HCCI is an Equal Opportunity Employer. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, marital or family status, or any other status protected under applicable law. All qualified applicants will receive equal consideration for employment regardless of the state in which they reside.

HCCI participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9.