We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time.
Job Summary
As a Senior Analytics Engineer within the Pharmacy Services Finance Business Intelligence, Automation, & Advanced Analytics organization, you’ll have the opportunity to become a trusted consultant to the CFO organization, building scalable and sustainable pipelines for massive amounts of enterprise data. Leveraging industry leading technology, you’ll be tasked with engineering the architecture of Finance data supporting critical analytics from numerous disparate sources, all integrated into semantic models and marts. You’ll have the opportunity to collaborate closely with business stakeholders and analytics partners to dive deep into the data at CVS Health, ensuring data-driven decisions can be made on a timely and consistent basis.
Job Responsibilities
- Develop high quality, scalable architecture and integration for data pipelines and models
- Provide subject matter expertise in the engineering space, making recommendations on project scope, architecture, deliverables, acceptance, and deployment
- Translate complex business questions and requirements into accessible data structures that can be leveraged to drive analytics and decision-making
- Leverage industry and enterprise standard frameworks to build sustainable and automated source data extraction, load, and transformation
- Identify potential failure points and optimization opportunities in existing production solutions to engineer a more efficient, consistent, and timely pipeline
- Develop internal tools to streamline development and ensure consistency and quality in code
- Craft appropriate documentation to ensure sustainability and usability by technical partners
- Build strong and enduring relationships with business partners, promoting trust and collaboration
- Proactively partner with visual analytics teammates to collaborate on solution architecture and execution
- Provide technical guidance and direction to more junior engineers
Basic Qualifications
- Bachelor’s degree in a quantitative or STEM field
- 7+ years of experience writing expert level SQL within database systems such as BigQuery, SAP HANA, Teradata
- 5+ years of experience with Python or other object-oriented languages in an analytics engineering setting
- 5+ years of experience with data, orchestration, and pipeline engineering services such as Airflow, Spark, Kubernetes, preferably Composer / Dataproc
- 3+ years of experience deploying to, and managing CI/CD within, cloud database platforms
- 3+ years of experience managing serverless architecture and integrations across multiple cloud services
Preferred Qualifications
- Master’s degree in a STEM field
- Experience engineering scalable and sustainable production-ready solutions that require minimal manual intervention
- Experience with designing and implementing Kimball dimensional models
- Ability to identify potential technical problems and craft innovate solutions to overcome them
- Experience working in an agile project environment
- Exceptional written and oral communication skills with the ability to influence at multiple levels of the organization
- Ability to work quickly under potentially ambiguous circumstances
Anticipated Weekly Hours
40Time Type
Full timePay Range
The typical pay range for this role is:
$92,700.00 - $185,400.00This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above.
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
We take pride in offering a comprehensive and competitive mix of pay and benefits that reflects our commitment to our colleagues and their families.
Additional details about available benefits are provided during the application process and on Benefits Moments.
Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.
Skills Required
- Bachelor's degree in a quantitative or STEM field
- 7+ years writing expert-level SQL in systems such as BigQuery, SAP HANA, Teradata
- 5+ years with Python or other object-oriented languages in an analytics engineering setting
- 5+ years with data orchestration and pipeline engineering services (Airflow, Spark, Kubernetes; preferably Composer/Dataproc)
- 3+ years deploying to and managing CI/CD within cloud database platforms
- 3+ years managing serverless architecture and integrations across multiple cloud services
- Master's degree in a STEM field
- Experience engineering production-ready, scalable, low-manual-intervention solutions
- Experience designing and implementing Kimball dimensional models
- Experience working in an agile project environment
- Exceptional written and oral communication skills and ability to influence at multiple levels
- Ability to work quickly under ambiguous circumstances and identify technical problems with innovative solutions
What We Do
CVS Health is the leading health solutions company that delivers care in ways no one else can. We reach people in more ways and improve the health of communities across America through our local presence, digital channels and our nearly 300,000 dedicated colleagues – including more than 40,000 physicians, pharmacists, nurses and nurse practitioners. Wherever and whenever people need us, we help them with their health – whether that’s managing chronic diseases, staying compliant with their medications, or accessing affordable health and wellness services in the most convenient ways. We help people navigate the health care system – and their personal health care – by improving access, lowering costs and being a trusted partner for every meaningful moment of health. And we do it all with heart, each and every day.
