People Analytics Data Engineer - Cloud ETL & Pipelines

CVS Health; Topeka (KS); On-site; USD 83,000 - 222,000; Full time

Job summary

CVS Health is seeking a Data Engineer - People Analytics to design data warehouse models, build robust data pipelines, and enable HR and workforce analytics in cloud platforms for scalable insights.

You will lead and mentor a team of data engineers, ensure data quality and governance, partner with HR and IT stakeholders, and support reporting in Python and R while upholding security and compliance.

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

• Data Pipeline Management: 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.
• Data Engineering and Transformation: Develop and optimize data workflows to ensure data accuracy, quality, and availability for the People Analytics team and stakeholders across HR and business units.
• Technical Leadership: Oversee a team of data engineers, providing mentorship, support, and guidance on best practices in data engineering, version control, and coding standards.
• Analytics & Reporting Support: 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.
• Data Security and Compliance: 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.
• Collaboration with Stakeholders: 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 & RDBMS

Python

Cloud platforms

Data warehousing

Airflow/Composer

Education

Bachelor's degree in CS / Data Engineering / Data Science

Master's degree preferred

Tools

Workday

PowerBI

Tableau

Job description

CVS Health is seeking a Data Engineer - People Analytics to design data warehouse models, build robust data pipelines, and enable HR and workforce analytics in cloud platforms for scalable insights.

You will lead and mentor a team of data engineers, ensure data quality and governance, partner with HR and IT stakeholders, and support reporting in Python and R while upholding security and compliance.