The Center for Improving Value in Health Care (CIVHC) is an independent nonprofit dedicated to leveraging data for health equity and price transparency. The Health Care Data Analyst will support the Data Analytics & Insights team by cleaning and analyzing healthcare claims data to drive actionable insights.
Responsibilities
- Clean, validate, and profile large, complex health claims data sets, derived from commercial, Medicare, and Medicaid data
- Extract, transform, and load data in a big data environment (ETL)
- Write and run SQL queries to extract and manipulate data; exposure to additional programming languages (e.g., SAS, R, Python) as a plus
- Assist in the development and review of reports, data extracts, and data tools
- Analyze data models, data dictionaries, and queries to ensure accurate interpretation and use
- Apply working knowledge of healthcare industry standards and coding systems (e.g., revenue codes, ICD, CPT, HL7, PHI, HIPAA, HITECH)
- Clearly communicate analytic results orally and in writing, including presentations to internal teams and external partners/data recipients
- Support process improvements to enhance data quality, efficiency, and insight generation
- Collaborate with peers and the Team Lead to meet project timelines and quality expectations
- Maintain documentation of data processes, queries, and results for transparency and reproducibility
- Proactively seek opportunities to learn new tools, methods, and industry knowledge to expand skillset
Skills
- Bachelor's degree in public health, computer science, biostatistics, or a related field required
- Five (5) years of progressively responsible experience in data analysis may be considered in lieu of a degree
- One (1) to three (3) years of experience working with data analysis, health care data, or academic/research experience involving data (internship experience accepted)
- Foundational knowledge of data analysis and strong analytical thinking skills
- Proficiency in SQL for data extraction and manipulation; familiarity with another language such as SAS, R, or Python a plus
- Exposure to data visualization tools such as Tableau (other tools a plus); enthusiasm for developing deeper visualization expertise
- Understanding of data scrubbing, validation, and profiling techniques
- Ability to interpret complex data models and data dictionaries
- Strong written and verbal communication skills; able to explain technical issues clearly to non-technical audiences
- Working knowledge or interest in learning healthcare data standards, coding systems, and regulatory considerations (e.g., HIPAA, PHI)
- Excellent time management and organizational skills with attention to detail
- Curiosity, diligence, and a problem-solving mindset; eagerness to learn from feedback and mentoring is essential
- Commitment to fostering a positive, inclusive, and collaborative team environment
- Master's degree preferred
- Experience working with complex data sets containing dependent or interconnected variables, familiarity with health care claims data preferred
Benefits
- 403b Retirement Plan
- Medical, Dental, and Vision plans
- Healthcare and Dependent Care Flexible Spending Account options
- Paid life insurance
- Short- and long-term disability coverage
- 9 paid holidays per year plus generous personal time off
- Company-paid parking
- On-site workout facility
- Excellent work-life programs, such as flexible schedules, and work-from-home options
- Employee wellness program
- Internal professional development opportunities
- Position may qualify for Public Service Loan Forgiveness Program.
Company Overview
CIVHC equips partners and communities in Colorado and across the nation with the resources, services and unbiased data needed to improve health and health care. It was founded in 2008, and is headquartered in Denver, Colorado, USA, with a workforce of 11-50 employees. Its website is https://www.civhc.org.
Apply Now