Senior Analytics Engineer, Clinical Data

Clover Health is reinventing health insurance by combining data with human empathy to improve member health outcomes. The Senior Analytics Engineer will build and maintain the data foundation for clinical analytics and AI initiatives by modeling, cleansing, validating, and deploying clinical, claims, pharmacy, EMR, and operational data into a clinical data warehouse. The role partners with clinical, operational, data science, and AI stakeholders to ensure reliable, well-documented, analysis-ready data.

Responsibilities:

• Design and develop conceptual, logical, and physical data models for clinical, claims, pharmacy, and EMR data to support the clinical data warehouse
• Build, test, and deploy new and modified tables, views, and schemas to the clinical data warehouse, following established data modeling and warehousing standards
• Mine, extract, and validate data from Athena EMR through the Athena Dataview, translating clinical source data into warehouse-ready structures
• Assess, cleanse, and organize data from disparate sources (claims, lab, pharmacy, EMR, and operational systems) so it can be reliably structured and integrated into the clinical data warehouse
• Partner with AI, machine learning, and data science teams to structure and document warehouse tables so AI engines can efficiently access data and surface accurate insights
• Develop and maintain complex SQL, ETL/ELT logic, and stored procedures to transform raw source data into curated, analysis-ready tables
• Establish and maintain data modeling standards, data dictionaries, naming conventions, and lineage documentation for the clinical data warehouse
• Ensure data accuracy, quality, and integrity across the warehouse through validation routines, testing, and ongoing monitoring of table deployments
• Gather requirements from clinical, operational, and analytics stakeholders and translate them into data model designs and technical specifications
• Prepare and present data architecture, data model, and warehouse deployment recommendations to leadership and technical stakeholders in support of Clover Care Services business initiatives

Requirements:

• A BA/BS in Computer Science, Data Engineering, Mathematics, Statistics, Healthcare Informatics, or a related discipline, with 5+ years of relevant professional experience
• Hands-on experience with data modeling (conceptual, logical, and physical) and dimensional/warehouse design (e.g., star schema, snowflake schema, data vault)
• Proven experience developing, testing, and deploying tables, views, and ETL/ELT pipelines into an enterprise or clinical data warehouse
• Direct experience mining and extracting data from Athena EMR, including working with the Athena Dataview or comparable EMR reporting/extract tools
• Strong SQL proficiency and hands-on Python experience, including using Python to query, transform, validate, and automate workflows involving large, complex healthcare datasets (claims, lab, pharmacy, and EMR)
• Working knowledge of Git and GitHub for version control, code review, pull requests, documentation, and collaborative development workflows
• Experience assessing and organizing disparate healthcare data sources into clean, standardized, well-documented data structures suitable for downstream analytics and AI/ML consumption
• Familiarity with data governance practices, including data dictionaries, metadata management, lineage tracking, and data quality validation
• Knowledge of healthcare data standards and coding systems (ICD-10, CPT, DRG) and familiarity with healthcare quality measures (e.g., HEDIS, CMS, NCQA)
• Exposure to how AI/ML engines and analytics platforms consume structured data, and an interest in designing data models that make insight generation easier for those systems
• Strong communication skills with the ability to translate complex data architecture and modeling decisions into clear guidance for clinical, technical, and operational stakeholders, using tools such as Excel and data visualization platforms
• preferably within Medicare Advantage