Senior Data Engineer, Mental Well-Being

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 SummaryOur team is dedicated to enhancing mental well-being of our members by leveraging data-driven insights and advanced analytics. We strive to empower our organization with robust data management, business intelligence, and reporting solutions that identify opportunities for improving member mental health while effectively managing costs. Through collaboration and innovation, we are committed to transforming data into actionable strategies that support our mission of fostering a healthier, more resilient community.This role can be remote in the US and must align to either central or Eastern time zone work schedulesWhat you will do:

Collaborates with internal and external stakeholders to translate business needs into technical requirements under the guidance of the manager and the principal data engineer.

Prepares documentation such as process diagrams, source to target mapping, data dictionaries, file specifications, ERDs, wireframes, and pseudocode.

Develops datasets, tables, and views in a relational database environment, including development of SQL queries, stored procedures, and functions.

Develops automated ETL processes using SQL and Python to ingest data and maintain source tables for reporting and analytics.

Performs extensive verification and validation testing to ensure results meet requirements and stakeholder needs.

Troubleshoots and resolves system issues.

Manages conflicting priorities across multiple projects concurrently.

Clearly communicates technical ideas to nontechnical clients in written and verbal form.

Provides training and guidance to support teammates.

Provides feedback and advice to management to guide decision making.

Makes recommendations to improve data management processes, metric definitions, and evaluation methods.

Responsible for project commitments to quality and on-time deliverables.Designs and conducts analyses using healthcare claims and services data.

Required Qualifications

3+ progressive years of experience as a Data Engineer in an enterprise level environment

3+ years of experience with advanced SQL programming ability in a data warehouse or big data analytics environment (CTEs, subqueries, windowed aggregations, stored procedures, etc.).

3+ years of experience building high quality ETL/ELT pipelines to prepare data for downstream reporting/analytics

1+ years of experience designing and developing ETL/ELT solutions in Google Cloud Platform including Spark on Dataproc, Dataflow, and Data Fusion

Preferred Qualifications

5+ years of experience of Google Cloud Data Engineering experience in health care – care management, PBM, Claims Experience developing and maintaining Airflow DAGs with Python in Cloud Composer

Well-versed in data modeling concepts (dimensional/fact, cardinality, normalization, etc.)

Strong problem-solving skills and critical thinking ability.

Strong collaboration and communication skills within and across teams.

5+ years of experience in BigQuery and SQL including developing data structures to support reporting and analytics.

Experience with Teradata, Tableau, Google Cloud SDK is a plus.

Strong analytical and problem-solving skills are essential, as well as communication, time management, attention to detail, and adaptability.

Must be comfortable working with remote teams and senior members of business units and product owners.

Prior experience mentoring or providing guidance to junior team members is a plus.

In-depth knowledge of healthcare industry standards, regulations, and data privacy concerns is highly desirable.

Proven expertise in building robust data pipelines and ETL processes to transform and prepare data for analytics.

Demonstrated ability to work independently and effectively drive projects to completion.

Excellent communication skills, with the ability to collaborate effectively with cross-functional teams and stakeholders.

EducationBachelor's degree or equivalent work experiencePay RangeThe typical pay range for this role is:$83,430.00 - $203,940.00This 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.For more detailed information on available benefits, please visit Benefits | CVS Health (https://jobs.cvshealth.com/us/en/benefits)We anticipate the application window for this opening will close on: 01/04/2025Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.We are an equal opportunity and affirmative action employer. We do not discriminate in recruiting, hiring, promotion, or any other personnel action based on race, ethnicity, color, national origin, sex/gender, sexual orientation, gender identity or expression, religion, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.