Senior Analytics Engineer

at  CVS Health

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

REQUIRED QUALIFICATIONS

• 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

• 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

EDUCATION

Bachelor’s degree in a quantitative or STEM field required
Master’s degree in a STEM field preferred

• 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