Health Care Data Analyst II

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.

Supervisory Responsibilities: None 

Reports To: Manager, Data Analytics & Insights

Duties/Responsibilities/Essential Functions: 

• 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.
• Proactively seek opportunities to learn new tools, methods, and industry knowledge to expand skillset.
• This position may require occasional travel for work-related activities or events.

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

 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.
• Commitment to fostering a positive, inclusive, and collaborative team environment.

 Education and Experience: 

• 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).
• 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.
• Analytical mindset with strong problem-solving ability.

Physical Requirements: 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.
• Ability to focus and concentrate for prolonged periods

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.

Position Timeline:

Our target is to fill this position by December 15, 2025. Application review will begin immediately and will continue on a rolling basis until the position is filled. We encourage interested candidates to apply as soon as possible for full consideration.

Compensation and Benefits:

The salary range for this position is $75,000 - $90,000 annually, based on relevant experience, education, and internal equity. CIVHC offers a comprehensive benefits package including medical, dental, and vision coverage; paid time off; life and disability insurance; and retirement plan contributions.

Equal Opportunity Employer:

CIVHC is proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, or any other legally protected status.