Talent Analytics - Data Engineering

This person will be a mid to senior data engineer that will focus on the HR Talent Analytics Team. They will be working with compensation, market studies on pricing, etc This person will have access to compensation for the company. This is a backfill for someone that just put in their notice. We need this person to have experience with the HR systems as they will need to hit the ground running.

Talent Analytics - Data Engineering

Responsibilities

Tools

• AWS
• Step Functions, Lambda, RDS, Dynamo, Eventbridge, IAM, VPC, S3
• Github
• Terraform
• QuickSight
• within AWS, but with its own access patterns
• CultureAmp
• Payscale
• Qualtrics
• ADP
• Greenhouse Recruiting
• Docebo
• Not in use for current trainings, but occasional data pull requests for compliance
• Okta

Key Responsibilities

• Maintaining AWS infrastructure
• Low likelihood of net-new infrastructure, and no infrastructure work currently on the roadmap. The risk here is that if something breaks (we have alerting and monitoring in place), there could be wide-ranging downstream implications. Someone with infrastructure knowledge is a must, even if that person isn t
• Maintaining existing ingestions (troubleshooting errors) and adding new data ingestions as needed
• Current data ingests:
• ADP (workers endpoint & validation tables)
• CultureAmp (employees & reviews data)
• Using the CA API, as well as the Okta API (uses our svc acct to grab the relevant download URL from the network requests)
• FP&A (personnel file, monthly ingest)
• FreshService HR tickets
• Will need to further parse offboarding tickets for Exit Survey
• Google Sheets (compensation bands, FP&A -> HR mappings)
• Qualtrics Survey data
• SFTP reports (ADP & OfficeSpace (RTO)) via
• Greenhouse (Business Intelligence Connector via S3)

• Maintain existing egress processes and add new patterns as needed
• Current data egress:
• Certent SFTP
• Payscale SFTP
• Internal Mobility Slack Channel
• Internal Mobility DMs
• Employee Compensation (Google Sheets for HRBPs)
• ADP email updates (syncs from Okta)
• Payscale data updates (for comp cycles)
• Severance calculation sheets
• Promo Baseball Cards
• Qualtrics employee data import
• New Hire IT report (for Mike Z)
• QuickSight administration
• Maintaining user groups and access
• Slack Bots
• Qualtrics Slack Nudges (Employee Listening)
• PTO Tracking reminders (Iniya started this, not launched yet)
• Internal Mobility
• Ad hoc data requests
• Examples
• Allocation reporting for manager
• Affirmative Action Planning reporting for compliance
• EEOC data requests
• RIF data pulls
• Employee Data
• OWBPA
• AIA