Health Care Data Analyst I

About the position 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. 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. 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. • Five (5) years of progressively responsible experience in data analysis may be considered in lieu of a degree. • One (1) to three (3) 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. 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. Apply tot his job