Health Care Data Analyst II
3 days ago
Denver
Job Description About Us The Center for Improving Value in Health Care (CIVHC) is an independent, mission-driven nonprofit that leverages data to drive price transparency, advance health equity, and improve health and health care for Coloradans. As the designated administrator of the Colorado All Payer Claims Database (CO APCD), we transform claims data into powerful insights that inform policy, foster accountability, and accelerate system-level improvement. We partner with communities, health systems, policymakers, and leaders across the state to advance affordability, equity, and outcomes – and we approach this work with analytical rigor, creativity, and a commitment to measurable impact. We envision a community where everyone has the opportunity to be healthy and can access affordable, high-quality care. Our core values – Service, Stewardship, Integrity, and Equity – guide every aspect of our work and reflect our dedication to empower people and organizations working to improve health and well-being across the state. Job Summary CIVHC is seeking a motivated and detail-oriented data analyst to join the Data Analytics & Insights team as a Health Care Data Analyst II. This role is ideal for an analyst with foundational experience in health care claims data who is ready to take on more complex work, exercise greater independence, and deepen their technical and industry expertise. Analysts at this level work closely with Senior Analysts and Team Leads to produce high-quality analyses and reporting, while developing and expanding their knowledge of the CO APCD and other health care data sources. Successful candidates are curious, collaborative, and passionate about turning data into actionable insights for a variety of stakeholders. Hybrid Work Model This position is based in Denver, Colorado. Because CIVHC operates under a hybrid work model with a requirement of at least one in-office day per week (unless otherwise approved), candidates must reside within a commutable distance to the Denver metro area. Limited relocation assistance may be available for out-of-state candidates who intend to relocate to the Denver area. Duties / Responsibilities / Essential Functions: Responsibilities for this position may include, but are not limited to: • Strong analytic skills; independently clean, validate, and profile large, complex health care claims data sets, derived from commercial, Medicare, and Medicaid data., • Write and optimize SQL queries to extract, transform, and analyze data; familiarity with at least one other language: SAS, R, Python, etc., • Develop and maintain intermediate-level reports, dashboards, and data tools that communicate findings clearly to diverse audiences, such as internal leadership, providers, policymakers, and the public., • Interpret data models, data dictionaries, and queries to ensure accurate understanding and use., • Apply and expand knowledge of health care industry standards and coding systems (revenue codes, ICD, CPT, HL7, PHI, HIPAA, HITECH)., • Assist Senior Analysts and Team Leads in quality-checking draft reports and identifying areas for improvement., • Clearly communicate analytic results orally and in writing to internal teams, external partners, and other data recipients., • Contribute to ongoing process improvements that enhance data quality, efficiency, and insight generation., • Maintain documentation of data processes, queries, and results for transparency and reproducibility. Required Skills / Abilities • Solid working knowledge of data analysis and demonstrated analytical thinking skills., • Proficiency in SQL for data extraction and manipulation; coding experience with at least one additional language such as SAS, R, Python, etc., • Exposure to and ability to use data visualization tools such as Tableau (other tools a plus); interest in deepening visualization expertise., • Strong understanding of data scrubbing, validation, and profiling techniques., • Ability to interpret complex data models and data dictionaries with minimal supervision., • Strong written and verbal communication skills; able to explain technical issues clearly to non-technical audiences., • Working knowledge of health care data standards, coding systems, and regulatory considerations, or willingness to learn rapidly., • Excellent time-management and organizational skills with attention to detail., • Curiosity, diligence, and a problem-solving mindset; eagerness to learn from feedback and mentoring., • Bachelor's degree in public health, computer science, biostatistics, or a related field required; Master’s degree preferred., • Five (5) years of progressively responsible experience in data analysis may be considered in lieu of a degree., • Two (2) to four (4) years of experience working with data analysis, health care data, or academic/research experience involving data (applicable internship experience may be accepted)., • At least one year of medical coding and billing experience in a provider setting., • Experience working with complex data sets containing dependent or interconnected variables, familiarity with health care claims data strongly preferred., • Experience interpreting data models, data dictionaries and queries., • SQL experience and technical skill writing queries. Primarily computer-based work with extended periods of sitting, typing, and concentration. May occasionally require light lifting of office materials. • Sitting for extended periods of time., • Using a computer and keyboard for typing and data entry., • Reaching and stretching to access files or equipment., • Lifting and carrying light objects such as papers or office supplies., • Walking short distances within the office environment., • Operating office equipment such as printers, copiers, and fax machines., • Occasionally bending or stooping to retrieve items from lower shelves or cabinets., • Maintaining good posture to prevent discomfort or strain., • Using a telephone or headset for communication. Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. Must be able to travel to and from local meetings and occasionally overnight national travel. How to Apply Interested candidates should apply through CIVHC’s careers page at Application Deadline This position will remain open until 2/20/26. The application deadline may be extended if needed, and the posting will be updated accordingly. Hiring Timeline Application review will begin immediately. Target hire date: March 2026 Compensation & Benefits The salary range for this position is $75,000 – $90,000, based on experience, education, and internal equity. In addition, this position may be eligible for an organization-wide bonus if certain metrics are met by CIVHC. CIVHC offers a comprehensive benefits package including: • 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 CIVHC does not provide visa sponsorship currently. Candidates must be legally authorized to work in the United States at the time of application and throughout employment. Background Check Employment is contingent upon successful completion of a background check, in accordance with CIVHC policy and applicable laws. Equal Opportunity Employer CIVHC is proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive, equitable, and welcoming workplace for all employees. We do not discriminate on any protected basis, including race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability, age, veteran status, or any other status protected by law. Research shows that women, people of color, individuals with disabilities, and members of other underrepresented groups often hesitate to apply for positions unless they meet every listed qualification. At CIVHC, we are committed to considering a broad range of experiences and backgrounds. If you are excited about this role and believe you would be a strong addition to our team, we encourage you to apply, even if your experience does not perfectly align with every requirement. We believe diverse perspectives strengthen our ability to advance health equity, improve health care value, and serve communities across Colorado.