At CVS Health, we're building a world of health around every consumer and surrounding ourselves with dedicated colleagues who are passionate about transforming health care. As the nation's leading health solutions company, we reach millions of Americans through our local presence, digital channels and more than 300,000 purpose‑driven colleagues – caring for people where, when and how they choose in a way that is uniquely more connected, more convenient and more compassionate.
Position Summary
Aetna, a CVS Health company, is the nation's premier health innovation company helping people on their path to better health. We are building a new health care model that is easier to use, less expensive, and puts the consumer at the center of their care. Aetna's Medicare Stars Team is growing and expanding! This is an exciting opportunity to join a high‑performing, collaborative team as a Data Scientist. The role focuses on leveraging the Stars Data Ecosystem for Business Analytics, improving understanding of business patterns, predicting future trends, and implementing effective solutions to various challenges.
Key Responsibilities
- Design and implement unified data pipelines in Snowflake that combine structured tables, semi‑structured data (JSON/Parquet), and large collections of documents (PDF, DOCX, text).
- Build agentic document analytics workflows: large‑scale document ingestion, text extraction, cleaning, chunking, embeddings, vector store creation, and efficient retrieval for analytic queries.
- Implement Natural Language Query interfaces that translate user text prompts into analytic queries or retrieval flows and return explainable results.
- Integrate Snowflake with LLMs (OpenAI or equivalent) for summarization, question‑answering, classification, and code‑generation using External Functions, Snowpark, and secure API patterns.
- Create performant retrieval‑augmented generation (RAG) architectures that leverage Snowflake‑stored embeddings and external or internal vector indexes.
- Author Snowpark/Python/SQL transformations, Streams & Tasks, and job orchestration to enable near‑real‑time and batch analytical workloads.
- Implement data modeling and governance patterns within Snowflake – schemas, role‑based access control, masking, lineage, and metadata for analytics and compliance.
- Partner with product, ML/AI, BI, and engineering teams to translate business requirements into robust production‑ready solutions.
- Build monitoring, observability, and cost controls for compute, storage, and API usage related to document analytics and LLM integration.
- Produce technical documentation, runbooks, and clear explanations of model/LLM behavior and limitations to non‑technical stakeholders.
Required Qualifications – Technical Skills
- Statistical Analysis – proficiency in R, SAS, and Python.
- Data Visualization – compelling visualizations using Tableau, Power BI, and D3.js.
- Database Management – knowledge of SQL and NoSQL databases.
- Programming – strong skills in Python, Java, and C++.
- Expertise in unified data pipelines, agentic document analytics, NLQ interfaces, Snowflake‑LLM integration, RAG architectures, Snowpark transformations, data governance, production‑ready solutions, monitoring, observability, cost controls, and documentation.
Analytical Skills
- Critical Thinking – approach problems from multiple perspectives.
- Quantitative Analysis – interpret and manipulate data effectively.
- Attention to Detail – ensure accuracy in data analysis and model development.
Interpersonal Skills
- Communication – excellent verbal and written communication.
- Team Collaboration – work collaboratively with diverse teams.
- Leadership – lead projects and mentor junior team members.
Preferred Qualifications
- Relevant experience in data analysis, machine learning, and business intelligence.
- Professional certifications in data science, machine learning, or business analytics are beneficial.
Education
- A bachelor's degree in Statistics, Mathematics, Computer Science, or Engineering. Advanced degrees (Master's or Ph.D.) are highly desirable.
Anticipated Weekly Hours – 40
Time Type – Full time
Pay Range – $64,890.00 – $222,480.00
Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.
Great benefits for great people
- Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.
- No‑cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching.
- Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility.
Application window for this opening will close on: 01/24/2026
Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.