Data Engineer, People Analytics & Data Pipelines

Quest Oracle Community; City of Albany (NY); On-site; USD 83,000 - 222,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

Paid time off

Retirement savings options

Wellness programs

Job summary

CVS Health is seeking a Data Engineer for People Analytics to design, build, and manage data pipelines and analytics data models. You will lead data workflows, ensure data quality, and support HR reporting using Python, SQL, and cloud platforms.

You will mentor a team of engineers, enforce governance and security, and collaborate with HR and IT to translate business needs into scalable data solutions. A CS degree and cloud experience are required.

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 pipelines

ETL/ELT

SQL

Python

Cloud platforms

Data warehousing

Scheduling tools

Education

Bachelor's degree in CS/related field

Master's degree preferred

Tools

Airflow

Composer

Job description

CVS Health is seeking a Data Engineer for People Analytics to design, build, and manage data pipelines and analytics data models. You will lead data workflows, ensure data quality, and support HR reporting using Python, SQL, and cloud platforms.

You will mentor a team of engineers, enforce governance and security, and collaborate with HR and IT to translate business needs into scalable data solutions. A CS degree and cloud experience are required.