Health Care Data Analyst I

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