Senior Data 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 Summary:

If you are eager to make a real impact in the health care industry through your own meaningful contributions, explore a role in technology with CVS Health. Our journey calls for technical innovators and data visionaries: come help us pave the way.

At CVS Health, we possess an extensive repository of healthcare data that spans over 150 million individuals, providing an unparalleled foundation for ambitious Data Engineers. In this role, you will engage with complex business challenges, harnessing modern tools and technologies to securely store, process, transform, and enrich terabyte to petabyte scale healthcare data. Your work will underpin data-driven business decisions and contribute to our mission of delivering industry-best data products / software with a customer-first mindset and team-oriented approach.

As a Senior Data Engineer, you will be instrumental in designing, developing, and maintaining optimal data pipelines to assemble large and intricate datasets, catering to the business requirements of various CVS lines of business. Collaborating closely with teams, you will craft tools to provide actionable insights and integrate them with consumer touchpoints.

In this role, you will:

• Responsible to develop data pipeline and transformation processes by implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes and standardize data before loading it into the datasets all while implementing data validation and reconciliation processes to ensure the accuracy and completeness of integrated data.
• Responsible to implement encryption techniques, access controls, and data masking to ensure data privacy and compliance with regulatory requirements using Cloud technologies GCP, AWS and SQL technologies.

• Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition.

• Collaborating with stakeholders including the Product, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues.
• Responsible to provide guidance and mentorship to junior data engineers. As experienced professionals in the field, they are responsible for sharing their knowledge and expertise with their team members. This includes providing technical guidance, reviewing code, and offering constructive feedback to help junior engineers grow and develop their skills.

As leaders in healthcare, our analytics and engineering teams deliver innovative solutions to business problems by collaborating with cross-functional teams in a dynamic and agile environment. You will be part of a team that values collaboration and encourages innovative thinking at all levels. You will be intellectually challenged to solve problems associated with large scale complex, structured and unstructured data, which will allow you to grow your technical skills and engineering expertise.

Required Qualifications:

• 3+ years of experience with SQL, NoSQL
• 3+ years of experience with Python (or a comparable scripting language)
• 3+ years of experience with Data warehouses (such as data modeling and technical architectures) and infrastructure components
• 3+ years of experience with ETL/ELT and building high-volume data pipelines.
• 3+ years of experience with reporting/analytic tools
• 3+ years of experience with Query optimization, data structures, transformation, metadata, dependency, and workload management
• 3+ years of experience with Big Data and cloud architecture
• 3+ years of hands-on experience building modern data pipelines within a major cloud platform (GCP, AWS, Azure)
• 3+ years of experience with deployment/scaling of apps on containerized environment (i.e., Kubernetes, AKS)
• 3+ years of experience with real-time and streaming technology (i.e., Azure Event Hubs, Azure Functions, Kafka, Spark Streaming)
• 1+ year(s) of soliciting complex requireme