OpenAI

Analytics Engineer, People Data

OpenAI

full-time

Posted on:

Origin:  • 🇺🇸 United States • California

Visit company website
✨ AI Apply
Apply

Salary

💰 $220,000 per year

Job Level

Mid-LevelSenior

Tech Stack

AirflowBigQueryCloudPythonSQLTableau

About the role

  • Hands-on owner of People analytics database: model, transform, test, and document HR data to deliver trustworthy data foundations
  • Build and own canonical People data models (employee, org/role, movement, recruiting funnel, comp history, mobility) in dbt with SCD handling, tests, docs, and data contracts
  • Partner with Data Platform/IT to ingest HRIS/ATS/Payroll/ID data; own the T in ELT (dbt), tests, and data contracts
  • Define a metrics/semantic layer and ship curated marts for the Head of People Analytics; enable self-serve via BI (Looker/Mode/Hex/Tableau)
  • Implement privacy-by-design (PII minimization, RBAC), lineage, and governance in partnership with Legal/Privacy/Security
  • Manage analytics CI/CD (Git, code review, environments, releases) and maintain runbooks, dictionaries, and lineage docs
  • Collaborate within People Systems team and report to Head of People Experience & Technology

Requirements

  • 5+ years as a HR IT, Analytics or Data Engineer (or equivalent) delivering production-grade HR data models and durable data products (governed marts, semantic layers, APIs etc.)
  • Expert SQL; deep experience with dbt and dimensional/event-temporal modeling
  • Proficient in Python for transforms/automation (not ML platform work)
  • Hands-on with a cloud warehouse (Snowflake/BigQuery) and an orchestrator (Dagster/Prefect/Airflow)
  • Track record integrating HRIS/ATS/payroll/identity sources and hardening metrics for exec-level decisions
  • Experience building canonical People data models with SCD handling, tests, docs, and data contracts
  • Strong stakeholder communication; asks the right questions to understand business context
  • Working knowledge of GDPR/CCPA, data minimization, and access management