Data Analyst

Health Care Cost Institute Inc.; Washington (District of Columbia); Remote; USD 75,000 - 95,000; Full time

Benefits offered by this job

403B retirement plan

Health insurance

Job summary

Health Care Cost Institute Inc. is seeking a Data Analyst to join our Washington, D.C.–based team, focusing on health care claims data analysis and reporting.

The role involves writing SQL queries, sourcing data, and supporting data infrastructure, dashboards, and stakeholder requests. The ideal candidate has 4+ years’ experience with Medicare/Medicaid/commercial claims data, strong SQL/SAS skills, and a quantitative background.

Qualifications

• 4+ years of experience assembling, understanding, and analyzing health care claims data.
• Experience developing and maintaining reports on spending, price, and utilization from claims data.
• Excellent analytical and quantitative skills with programming experience to manage and analyze big data.

Responsibilities

• Write and optimize complex SQL queries against large relational claims databases to develop and maintain reports on prices, utilization, spending, and quality.
• Navigate database schemas to source data for new and existing analyses.
• Collaborate with data visualization specialists to populate dashboards with accurate data.
• Apply knowledge of health care reimbursement and claims structures to ensure analyses are sound.
• Support ad hoc data requests and special projects as needed.
• Assist with data infrastructure tasks including data ingestion, quality control, and documentation.

Skills

SQL

SAS

Health care claims data

Analytical skills

Quantitative programming

Education

Bachelor’s degree in economics, mathematics, social science, informatics, or other quantitative field

Tools

SQL

SAS

Job description

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 Data Analyst 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 Data Analyst will support HCCI’s efforts to provide employers and other stakeholders information to help them make informed decisions to improve the value of health care.

The Data Analyst will:

• Write and optimize complex SQL queries against large relational claims databases to develop and maintain reports on health care prices, utilization, spending, and quality.
• Proactively and independently navigate database schemas to source data for new and existing analyses.
• Partner with data visualization specialists to populate dashboards and reports with accurate, correctly structured data.
• Apply working knowledge of health care reimbursement and claims structures to ensure analyses are methodologically sound.
• Respond to internal and external stakeholder requests and support ad hoc data requests and special projects as needed.
• Support data infrastructure efforts surrounding data assets, including data ingestion, quality control, technical documentation, and interfacing with data vendor to resolve issues 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. Experience working with self‑insured employer’s claims data a plus.
• 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.
• Experience developing and maintaining reports on spending, price, and utilization 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.