Analytics Engineer

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. And we do it all with heart, each and every day.

Position Summary

As an Analytics Engineer within the Pharmacy Services Finance Business Intelligence, Automation, & 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
• Translate complex business questions and requirements into accessible data structures that can be leveraged to drive analytics and decision-making
• Leverage industry standard methodologies to build sustainable and automated source data extraction, load, and transformation
• 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 data visualization & analytics partners to collaborate on solution architecture and execution

Required Qualifications

• 5+ years of experience writing advanced to expert level SQL within database systems such as SAP HANA, Google BigQuery, Teradata
• 3+ years of experience with orchestration and pipeline engineering technology such as Airflow, Spark, Kubernetes, preferably Composer / Dataproc
• 3+ years of experience analyzing large data sets with a focus in finance or insurance
• 3+ years of experience with Python or other object-oriented languages in a data engineering setting  
• 1+ years of experience with serverless architecture and integration

Preferred Qualifications

• Experience with Kimball/Inmon dimensional data modeling
• Experience working in an agile project environment
• Experience with cloud database platforms
• 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

Education

• Bachelor’s degree in a quantitative or STEM field OR equivalent (4 years’ experience and High School Diploma/GED) required.

Anticipated Weekly Hours

Time Type

Pay Range

The typical pay range for this role is:

This 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 our comprehensive and competitive mix of pay and benefits – investing in the physical, emotional and financial wellness of our colleagues and their families to help them be the healthiest they can be. In addition to our competitive wages, our great benefits include:

• 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.

For more information, visit https://jobs.cvshealth.com/us/en/benefits

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.