Senior Analytics Engineer, Clinical Data

The Clover Care Services organization delivers proactive support and care to our members through our Clover Home Care teams, and quality improvement services to our aligned insurance plan providers through our practice engagement team. We have built one of the most proactive, data-driven health care services platforms in New Jersey and are excited about the future of technology and how it impacts our ability to bring transformative results to both patients and providers. As a Senior Analytics Engineer in the Clover Care Services (CCS) organization, you will design and build the data foundation that powers CCS analytics and AI initiatives. This role is centered on data modeling, table development, and deployment of production-ready tables to the clinical data warehouse. You will mine and extract data from Athena EMR through the Athena Dataview, and assess, cleanse, and organize clinical, claims, and operational data so it is properly structured in the clinical data warehouse for consumption by downstream reporting tools and AI engines. You will partner with clinical and operational stakeholders, as well as data science and AI teams, to ensure the warehouse is built on reliable, well-modeled, and well-documented data. The right person must be a data-driven, highly analytical builder with exceptional organizational skills, strong data modeling instincts, and a passion for building the data infrastructure that lets AI and analytics teams draw insights with confidence. As a Senior Analytics Engineer , you will: - 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. Success in this role looks like: - In your first 90 days, you will: Learn the intricacies of the Athena EMR data, the Athena Dataview, and the other data sets that feed the clinical data warehouse. Build and deploy your first set of data models and tables to the clinical data warehouse. Document data modeling standards and warehouse table conventions for the CCS team. - After 6 months you will: Partner with stakeholders to design and implement a scalable data model for mining and structuring Athena EMR data via the Athena Dataview. Deploy a robust set of curated, AI-ready tables to the clinical data warehouse that support both reporting and AI-driven insight generation.