Analytics Engineer

Bring your heart to CVS Health. Every one of us at CVS Health shares a single, clear purpose: Bringing our heart to every moment of your health. This purpose guides our commitment to deliver enhanced human-centric health care for a rapidly changing world. Anchored in our brand — with heart at its center — our purpose sends a personal message that how we deliver our services is just as important as what we deliver.Our Heart At Work Behaviors™ support this purpose. We want everyone who works at CVS Health to feel empowered by the role they play in transforming our culture and accelerating our ability to innovate and deliver solutions to make health care more personal, convenient and affordable.Position SummaryAs 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.

Pay RangeThe typical pay range for this role is:$72,100.00 - $173,040.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.In addition to your compensation, enjoy the rewards of an organization that puts our heart into caring for our colleagues and our communities. The Company offers a full range of medical, dental, and vision benefits. Eligible employees may enroll in the Company’s 401(k) retirement savings plan, and an Employee Stock Purchase Plan is also available for eligible employees. The Company provides a fully-paid term life insurance plan to eligible employees, and short-term and long term disability benefits. CVS Health also offers numerous well-being programs, education assistance, free development courses, a CVS store discount, and discount programs with participating partners. As for time off, Company employees enjoy Paid Time Off (“PTO”) or vacation pay, as well as paid holidays throughout the calendar year. Number of paid holidays, sick time and other time off are provided consistent with relevant state law and Company policies.For more detailed information on available benefits, please visit Benefits | CVS Health (https://jobs.cvshealth.com/us/en/benefits)We anticipate the application window for this opening will close on: 01/31/2025Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.We are an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex/gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.