Plan Sponsor Reporting Technologist

CVS Health

1d

About The Position

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.

Requirements

• 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.
• Google Cloud technology knowledge a must including cloud‑native tools for compute, storage, orchestration, and data processing.

Nice To Haves

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

Responsibilities

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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level