Data Engineer, People Analytics & Pipelines

Quest Oracle Community; Montpelier (VT); On-site; USD 83,000 - 222,000; Full time

Job summary

CVS Health is seeking a Data Engineer - People Analytics to design and deliver data warehouse models, pipelines, and analytics for HR and workforce insights. You will partner with People Analytics and HR stakeholders to enable reliable reporting and data-driven decisions.

You will mentor a team of data engineers, uphold governance, security, and best practices in cloud platforms (GCP preferred), SQL, Python, and ETL tooling, while supporting cross-functional initiatives in a dynamic health care

Qualifications

• 3+ years' experience in data engineering.
• 3+ years' experience with ETL/ELT processes.
• 3+ years' experience with SQL and relational databases.
• 2+ years' experience programming in Python for data manipulation.
• 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 (GCP,AWS,AZURE)

Data warehousing

Airflow

Education

Bachelor's in CS/DS

Master's preferred

Tools

Snowflake

Redshift

BigQuery

Airflow

Job description

CVS Health is seeking a Data Engineer - People Analytics to design and deliver data warehouse models, pipelines, and analytics for HR and workforce insights. You will partner with People Analytics and HR stakeholders to enable reliable reporting and data-driven decisions.

You will mentor a team of data engineers, uphold governance, security, and best practices in cloud platforms (GCP preferred), SQL, Python, and ETL tooling, while supporting cross-functional initiatives in a dynamic health care