Data Support Analyst II

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 Training and Data Enhancement team as Client Relations Direct Support for 411, CIVHC’s customer support and data investigation system. This role is ideal for an analyst with experience working with health care claims data who is ready to take on increasingly complex technical support and analytic responsibilities, exercise greater independence, and deepen their expertise in the Colorado All Payer Claims Database (CO APCD) and related health care data. Analysts at this level work collaboratively with CIVHC’s operational teams - Data Analytics & Insights, Evaluation, Innovation & Research, Data Access, Compliance, and Technology - to investigate complex client questions, develop accurate and consistent technical responses, and support the delivery of high-quality data products and services. Successful candidates are curious, collaborative, client-focused, and passionate about translating complex health care data into actionable information 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:

• Serve as the primary analyst supporting the 411 client inquiry process by independently researching, investigating, and responding to technical questions related to the CO APCD, data products, methodologies, and reporting. 
• Analyze complex health care claims data to validate findings, troubleshoot client issues, and support accurate interpretation of data requests. 
• Write and optimize SQL queries to extract, transform, and analyze data; proficiency in at least one additional programming language (R, Python, or similar) is preferred. 
• Collaborate with CIVHC’s operational teams - Data Analytics & Insights, Evaluation, Innovation & Research, Data Access & Impact, and Legal & Compliance - to resolve client inquiries requiring cross-functional expertise. 
• Interpret data models, business rules, data dictionaries, data submission guides, and technical documentation to ensure consistent application of CO APCD data standards. 
• Develop clear, concise written responses and supporting documentation for technical and non-technical audiences. 
• Identify trends in client inquiries and recommend improvements to documentation, training materials, business processes, and knowledge management resources. 
• Perform quality assurance reviews of technical responses, data extracts, and supporting documentation to ensure accuracy and consistency. 
• Maintain documentation of client inquiries, technical investigations, resolutions, and standard operating procedures. 
• Stay current on health care industry standards, APCD best practices, coding systems, privacy requirements, and emerging analytic methods. 
• Contribute to continuous process improvement initiatives that enhance the quality, efficiency, and consistency of client support services. 
• Research, write, edit, or otherwise contribute to reports, articles, memos, publications or other work product produced on behalf of CIVHC. 

Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

Supervisory Responsibilities:

• None

Required Skills / Abilities:

• Strong analytical and critical thinking skills with the ability to independently investigate, analyze, and resolve complex technical and data-related questions while understanding the underlying causes of analytical results. 
• Proficiency in SQL for data extraction, transformation, and analysis, including intermediate SQL concepts such as joins, common table expressions (CTEs), window functions, aggregations, and query optimization; experience with R, Python, or similar analytical tools. 
• Ability to independently interpret complex data models, data dictionaries, business rules, and technical documentation to support analytical projects and reporting. 
• Experience building, validating, and maintaining datasets, dashboards, reports, and/or other analytical deliverables while applying data quality assurance, validation, and data governance practices. 
• Experience working with large, complex healthcare claims datasets, preferred familiarity with APCD claims database structures, fields, and tables. 
• Ability to select appropriate analytical methods and approaches within established frameworks while exercising sound judgment and escalating issues outside defined scope. 
• Strong written and verbal communication skills with the ability to present analytical findings, explain technical concepts, answer questions about work products, and communicate effectively with both technical and non-technical audiences. 
• Fully participates in internal and external meetings, collaborates effectively with project teams and partners, and develops productive working relationships with stakeholders. 
• Working knowledge of healthcare claims data, coding systems (ICD, CPT, HCPCS, revenue codes), healthcare data standards, HIPAA, PHI, and related regulatory requirements, applying this knowledge with minimal supervision. 
• Excellent organizational and time management skills with the ability to manage multiple priorities, independently complete assignments, and consistently meet service-level expectations. 
• Demonstrated customer service orientation with the ability to build collaborative relationships across departments and with external partners. 
• Demonstrated ability to independently resolve routine and known data issues while contributing to process improvements and sharing knowledge with team members. 
• Ability to lead assigned reports and analytical projects, delivering high-quality work products with increasing independence. 
• Provides informal mentorship by sharing knowledge, supporting onboarding activities, and assisting less experienced team members as appropriate. 
• Demonstrates a commitment to continuous learning, process improvement, innovation, and contributing to a collaborative, inclusive team environment.

Education & Experience

Required:

• Bachelor's degree in Public Health, Health Informatics, Computer Science, Biostatistics, Data Analytics, 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) or more years of experience working with healthcare claims data, healthcare analytics, client support, data management, or applied research. 
• Experience writing intermediate SQL queries and working with relational databases, including joins, CTEs, window functions, and data transformations. 
• Experience building datasets, dashboards, reports, and other analytical deliverables. 
• Experience interpreting data models, business rules, data dictionaries, and technical documentation. 
• Experience independently investigating complex data questions, selecting appropriate analytical methods, and communicating technical findings to diverse audiences. 
• Experience supporting internal stakeholders and external clients, researchers, policymakers, healthcare organizations, or project partners. 
• Experience independently investigating complex data questions, selecting appropriate analytical methods, and communicating technical findings to diverse audiences. 
• Familiarity with the Colorado APCD or another all-payer claims database is preferred. 
• Demonstrated ability to independently manage report-level work, contribute to service-line initiatives, and consistently deliver high-quality analytical products with minimal guidance. 

Physical Requirements:
This position primarily involves computer-based work in office and remote work environments. The employee must be able to perform the essential functions of the position, with or without reasonable accommodation. The role routinely requires communicating and exchanging information with others and using a computer and other standard office technology. The position may involve remaining in a stationary position for portions of the workday, moving within an office or meeting environment, and occasionally lifting or moving light office materials. 

CIVHC is committed to providing reasonable accommodations to qualified individuals with disabilities in accordance with applicable law. Individuals who require accommodation to perform the essential functions of the position may engage in the reasonable accommodation process with Human Resources. 

Other Duties
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 https://civhc.org/about-civhc/who-we-are/careers/

Application Deadline
This position will remain open until 10/30/2026. 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: November/2026

Compensation & Benefits

The salary range for this position is $75,000 – $85,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 
• Position may qualify for Public Service Loan Forgiveness Program. For more information, go to: https://studentaid.ed.gov/sa/repay-loans/forgiveness-cancellation/public-service

Work Authorization

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.