Health Care Data Analyst II

About the position 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. Responsibilities • 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. • Proactively seek opportunities to learn new tools, methods, and industry knowledge to expand skillset. Requirements • 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. • 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. • Analytical mindset with strong problem-solving ability. 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. For more information, go to: Apply tot his job