People Analytics Data Engineer — Cloud ETL & Insights

CVS Health; Hartford (CT); On-site; USD 83,000 - 222,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Paid time off

Retirement benefits

Job summary

CVS Health is seeking a Data Engineer for the People Analytics team to build data warehouses, pipelines, and analytics in cloud platforms. You will lead data engineering efforts, mentor juniors, and collaborate with HR and IT stakeholders to deliver reliable data for reporting in R, Python, and BI tools.

Requirements include 3+ years in data engineering, ETL/ELT, SQL, and hands-on experience with Workday-friendly HRIS data flows; a Bachelor's in CS or related field is expected, with Master's

Qualifications

• 3+ years' experience in Data Engineering.
• 3+ years' experience with ETL/ELT processes and tools.
• 3+ years' experience with SQL and relational databases.
• 2+ years' experience programming in Python for data manipulation, automation, and analysis.
• 3+ years' experience with cloud platforms, prefer GCP (may consider Azure or AWS).
• 2+ years' experience with data warehousing solutions (e.g., Snowflake, Redshift, BigQuery).
• 2+ years' experience with scheduling tools like Airflow or Composer.

Responsibilities

• Design, build, and manage robust data pipelines and ETL processes that integrate HR data from various systems, including Workday, talent management, payroll, and other data sources.
• Develop and optimize data workflows to ensure data accuracy, quality, and availability for the People Analytics team and stakeholders across HR and business units.
• Oversee a team of data engineers, providing mentorship, support, and guidance on best practices in data engineering, version control, and coding standards.
• Work closely with People Analytics to structure data for analysis, develop data models, and create reproducible workflows that enable efficient reporting in R, Python, and other analytics tools.
• Ensure data governance and security protocols are followed in accordance with company policies and industry regulations, with a focus on HR data confidentiality and compliance.
• Partner with HR leaders, IT, and People Analytics teams to understand business requirements, streamline data requests, and provide insights to support strategic decisions.

Skills

Data engineering

ETL/ELT

SQL

Python

Cloud platforms

Data warehousing

Scheduling tools

Education

Bachelor's degree

Master's degree

Tools

Workday

Snowflake

Redshift

BigQuery

Airflow

Composer

Job description

CVS Health is seeking a Data Engineer for the People Analytics team to build data warehouses, pipelines, and analytics in cloud platforms. You will lead data engineering efforts, mentor juniors, and collaborate with HR and IT stakeholders to deliver reliable data for reporting in R, Python, and BI tools.

Requirements include 3+ years in data engineering, ETL/ELT, SQL, and hands-on experience with Workday-friendly HRIS data flows; a Bachelor's in CS or related field is expected, with Master's