Health Care Data Analyst I
About The Position
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. CIVHC is seeking a detail-oriented and self-motivated data analyst to join the Data Analytics & Insights team. The Health Care Data Analyst will support and contribute to projects that drive actionable insights from complex healthcare claims data. Analysts in this role work closely with their Team Lead and the larger Analytics & Insights team to clean, analyze, and visualize large data sets, while learning advanced techniques and industry standards. This is an ideal opportunity for someone eager to grow their technical skills and healthcare expertise in a collaborative, people-focused environment. Successful candidates are curious, detail-oriented, and passionate about turning data into meaningful information that supports better decisions.
Requirements
- 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.
- Bachelor's degree in public health, computer science, biostatistics, or a related field required; Master’s degree preferred.
- One (1) or more years of experience working with data analysis, health care data, or academic/research experience involving data (internship experience accepted).
- Experience working with complex data sets containing dependent or interconnected variables, familiarity with health care claims data preferred.
- Experience interpreting data models, data dictionaries and queries.
- SQL experience and technical skill writing queries.
- Analytical mindset with strong problem-solving ability.
Nice To Haves
- Five (5) years of progressively responsible experience in data analysis may be considered in lieu of a degree.
- Exposure to additional programming languages (e.g., SAS, R, Python).
- Exposure to data visualization tools such as Tableau (other tools a plus); enthusiasm for developing deeper visualization expertise.
- Working knowledge or interest in learning healthcare data standards, coding systems, and regulatory considerations (e.g., HIPAA, PHI).
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.
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
