Tech Stack
Tag name is followed by "@" symbol and proficiency level value.
About proficiency levels:
- 1-2 — basic awareness. Minimal hands-on experience, and a rudimentary understanding of the technology's purpose;
- 3-6 — daily use. Comfortable and regular usage, capable of handling common tasks and challenges related to the technology;
- 7-9 — you are an expert, you can teach others, you know all the pitfalls and tricks;
- 10 — exceptional knowledge, comprehensive understanding, and adeptness in all aspects of the technology, including advanced problem-solving. Think twice before claiming or demanding such level.
Airflow @ 3
Data Modeling @ 3
Data Pipelines @ 3
Debugging @ 3
Python @ 3
Reporting @ 3
SQL @ 6
- 1-2 — basic awareness. Minimal hands-on experience, and a rudimentary understanding of the technology's purpose;
- 3-6 — daily use. Comfortable and regular usage, capable of handling common tasks and challenges related to the technology;
- 7-9 — you are an expert, you can teach others, you know all the pitfalls and tricks;
- 10 — exceptional knowledge, comprehensive understanding, and adeptness in all aspects of the technology, including advanced problem-solving. Think twice before claiming or demanding such level.
Details
About the Team
OpenAI's User Safety & Risk Operations (USRO) team helps protect products and users from abuse, fraud, safety risks, and other forms of misuse. The team translates real-world user and operational signals into timely decisions, practical interventions, and improvements to products and systems.
This role sits on the Risk Incubation & Systems (RIS) team, which investigates emerging risks, builds data and automation capabilities, and develops workflows that can scale into durable operational homes.
About the Role
Build and maintain data pipelines and shared datasets used across USRO for analysis, measurement, and automation. Working with operational teams and engineers, you will turn data from different systems into reliable sources that colleagues can use in their work.
Projects are taken from initial requirements through production use, including testing and documentation. As team needs change, you will help maintain and extend the systems you build.
This role is based in San Francisco and requires working in the office three days per week. It may involve exposure to sensitive or concerning content; strong discretion, good judgment, and resilience are essential.
Responsibilities
- Work with USRO teams to understand data needs and define requirements for datasets and reporting.
- Build, maintain, and monitor production data pipelines and Airflow DAGs, including scheduling, dependencies, backfills, and troubleshooting failures.
- Build and maintain reusable data models, reporting cubes, and shared operational reporting metrics so teams can use consistent definitions across dashboards and analyses.
- Set up data quality and freshness checks, document lineage and ownership, and make the work supportable after handoff.
- Document data sources and transformations so colleagues can trace results back to the underlying records.
- Apply access and privacy requirements when designing datasets and reporting.
Requirements
- Strong SQL skills.
- Practical experience using Python to build and maintain data pipelines.
- Experience building and debugging scheduled pipelines that other people depend on.
- Practical understanding of data modeling, joins, deduplication, tests, and monitoring.
- Ability to trace a surprising metric back to its inputs and explain what downstream users can and cannot conclude.
- Experience partnering with non-engineers to turn ambiguous needs into dependable data products.
Nice to Have
- Experience with Airflow or similar workflow orchestration tools.
- Experience transferring prototypes or new workflows into reliable, scaled operations.
Benefits
- Medical, dental, and vision insurance, with employer contributions to Health Savings Accounts.
- Pre-tax accounts for health, dependent care, and commuter expenses.
- 401(k) retirement plan with employer match.
- Paid parental, medical, and caregiver leave.
- Paid time off, company holidays, office closures, and paid sick or safe time as required by law.
- Mental health and wellness support.
- Employer-paid basic life and disability coverage.
- Annual learning and development stipend.
- Daily meals in offices and eligible meal delivery credits.
- Relocation support for eligible employees.
- Equity, performance-related bonuses for eligible employees, and additional taxable fringe benefits may also be provided.