Senior Data Engineer

Key Skills

Algorithms, Apache Kafka, AWS, Azure, Data Engineering, Data science techniques, Data structuring, ETL/ELT technologies, Google Cloud Platform (GCP), Kubernetes-K8s, NoSQL, Optimization, PySpark, Python Programming, SPARK Programming, SQL

Job Description

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 Staff 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:

• Develops large scale data structures and pipelines to organize, collect and standardize data that helps generate insights and addresses analytical needs.
• Collaborates with product business and data science team to collect user stories, translate into technical specifications, and implement data transformation, algorithms and models into automated processes.
• Provide technical leadership and mentorship to a team of data engineers. Collaborate with cross-functional teams to align analytical initiatives with overall business goals
• Analyzes current information technology environments to identify and assess critical capabilities and recommend solutions. Experiments with available tools and advice on new tools to determine optimal solution given the requirements dictated by the use cases.
• Uses strong programming skills in PySpark, Python or any of the major languages to build robust data pipelines and dynamic systems.
• 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 development
• Experience with complex systems and solving challenging analytical problems
• Strong collaboration and communication skills within and across teams
• Knowledge of data visualization and reporting
• Experience with schema design and dimensional data modeling
• Google Professional Data Engineer Certification
• Knowledge of microservices and SOA
• Formal SAFe and/or agile experience. Previous healthcare experience and domain knowledge
• Experience designing, building, and maintaining data processing systems
• Experience architecting and building data warehouse and data lakes

Education:

• Bachelor’s Degree or equivalent work experience in Computer Science, Information Systems, Data Engineering, Data Analytics, Machine Learning, or related field required. Master’s Degree preferred.

Pay Range

The typical pay range for this role is:

$101,970.00 - $203,940.00

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.

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.