Sr Data 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

If you’re 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:

• Provide subject matter expertise in the data engineering, making recommendations on project scope, tools & technology selection, architecture, deliverables, acceptance, and deployment
• Work with a team of data engineers that execute defined analytics processes, assisting with data ingestion / Conformance / Symantec mapping.
• Builds data marts and data models to support Data Science and other internal customers. Integrates data from a variety of sources, assuring that they adhere to data quality and accessibility standards
• Support building UI for internal application development
• Manage data ingestion and Conformance processes that exist in the GCP environment
• Build robust data pipeline and analytical process using Python, Java or any of the major languages

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, that 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 requirements and managing relationships with key stakeholders
• 1+ year(s) of experience independently managing deliverables

Preferred Qualifications

• Experience in designing and building data engineering solutions in cloud environments (preferably GCP)
• Experience with Git, CI/CD pipeline, and other DevOps principles/best practices

• Experience with bash shell scripts, UNIX utilities & UNIX Commands
• Understanding of software development methodologies including waterfall and agile.
• Ability to leverage multiple tools and programming languages to analyze and manipulate data sets from disparate data sources
• Knowledge of API develop