Plan Sponsor Reporting Technologist

Location: CT - Work from home

Remote Type: Remote

Time Type: Full time

Job Description

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time.

Position Summary

Participates in the design, build, manage and responsible for successful delivery of large-scale data structures and Pipelines and efficient Extract/Load/Transform (ETL) workflows. Acts as the data engineer for large and complex projects involving multiple resources and tasks, providing individual mentoring in support of company objectives.

A strong foundation in Google Cloud Platform (GCP), Apache Spark, Scala, Python, SQL technologies are essential.

• Healthcare analytics knowledge would be beneficial
• Applies understanding of key business drivers to accomplish own work.
• Uses expertise, judgment, and precedents to contribute to the resolution of moderately complex problems.
• Leads portions of initiatives of limited scope, with guidance and direction.
• Deep knowledge of architecture, frameworks, and methodologies for working with and modelling large data sets, such as Spark , HDFS, YARN, Hive and edge nodes and NoSQL databases.
• Strong SQL skills with commensurate experience in a large database platform.
• Able to perform code reviews to ensure the code meets the acceptance criteria.
• Experience in Data Modelling/Mapping and implementing them in development.
• Collaborates with client team to transform data and integrate algorithms and models into automated processes.
• Utilizes strong programming skills—especially Scala, Python, Java and similar languages —to build scalable and robust data pipelines and services.
• Builds data marts and data models to support clients and other internal customers.
• Designs and builds data marts, curated datasets, and analytical data models to support clients and other internal customers.
• Integrates data from a variety of sources, assuring that they adhere to data quality and accessibility standards.
• Follows the complete SDLC and delivers work within Agile frameworks (Scrum/SAFe).
• Google Cloud technology knowledge a must including cloud‑native tools for compute, storage, orchestration, and data processing.

Required Qualifications

• 5+ years of progressively complex related experience.
• Strong problem-solving skills and critical thinking ability.
• Strong collaboration and communication skills within and across teams.
• Ability to leverage multiple tools and programming languages to analyze and manipulate data sets from disparate data sources.
• Ability to understand complex systems and solve challenging analytical problems. Experience with bash shell scripts, UNIX utilities & UNIX Commands.
• 3+ years experience in Scala, Java, Python, Hive, MySQL, or NoSQL or similar technologies.
• Knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries against data in the HDFS environment.
• Experience building data transformation and processing solutions.
• Expert high-level coding skills such as SQL/PL-SQL and scripting languages (UNIX) required. Scala is a plus.
• Experience with source code control systems (GIT) and CI/CD process (Jenkins/Team City/Octopus)
• Involved in the design, prototyping and delivery of software solutions within the big data eco-system
• Requires significant knowledge across multiple areas and applications, has a significant healthcare business knowledge and impact to numerous applications.

Preferred Qualifications

• Nice to have AWS knowledge (S3/Redshift/Lambda/Data Pipeline).
• Working experience in Exasol/Redshift/Snowflake is a plus.

Education

Bachelor's degree or relevant experience.

Anticipated Weekly Hours

Time Type

Pay Range

The typical pay range for this role is:

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. 
 

Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong.

Great benefits for great people

We take pride in our comprehensive and competitive mix of pay and benefits – investing in the physical, emotional and financial wellness of our colleagues and their families to help them be the healthiest they can be. In addition to our competitive wages, our great benefits include:

• Affordable medical plan options, a 401(k) plan (including matching company contributions), and an employee stock purchase plan.

• No-cost programs for all colleagues including wellness screenings, tobacco cessation and weight management programs, confidential counseling and financial coaching.

• Benefit solutions that address the different needs and preferences of our colleagues including paid time off, flexible work schedules, family leave, dependent care resources, colleague assistance programs, tuition assistance, retiree medical access and many other benefits depending on eligibility.

For more information, visit https://jobs.cvshealth.com/us/en/benefits

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.