Business Intelligence & Automation Lead, Strategic Finance

OpenAI; San Francisco (CA); Hybrid; USD 120,000 - 180,000; Full time

Job summary

An established industry player is seeking a Business Intelligence & Automation Lead to revolutionize data-driven decision-making. This role focuses on building scalable, automated data products that democratize access to insights across Strategic Finance. You will define the BI architecture, manage data pipelines, and create intelligent agents to streamline financial processes. This position offers the unique opportunity to leverage cutting-edge AI technologies while collaborating with cross-functional teams. If you're passionate about using data to drive strategic decisions and thrive in a fast-paced environment, this is the perfect opportunity for you.

Benefits

Relocation assistance

Flexible work hours

Health insurance

Remote work options

Qualifications

• 6+ years of experience in Analytics Engineering or BI Development.
• Fluency in SQL and Python or another scripting language.

Responsibilities

• Build and own the architecture for automated insight delivery.
• Design and deploy agentic solutions to automate financial workflows.

Skills

SQL

Python

Analytics Engineering

Business Intelligence Development

Data Visualization (Tableau, Looker)

Financial Metrics Understanding

Tools

Tableau

Looker

Job description

Business Intelligence & Automation Lead, Strategic Finance

The Strategic Finance team is responsible for some of the largest investment categories at OpenAI. Our mission is to maximize long-term enterprise value by enabling rigorous, data-driven decision-making. We partner closely with Product, Engineering, Go-To-Market, and Finance to build scalable, automated data products that surface the insights leaders need to allocate resources, assess investments, and guide OpenAI’s growth.

About the Role

We are looking for a Business Intelligence & Automation Lead who is obsessed with building automated, scalable data products to democratize access to insights across Strategic Finance and beyond. This person will serve as the technical foundation for insight delivery, transforming fragmented workflows into clean, reliable, and powerful data products and intelligent agents that drive strategic decisions at scale.

As one of the founding members of this vertical, you will define our BI architecture, own core data pipelines and semantic layers, and build dashboards, agent workflows, and automated reporting systems that surface business-critical insights. You’ll partner with Data Science, Finance, Engineering, and Go-To-Market teams and, uniquely, you will have the opportunity to harness OpenAI’s internal agentic infrastructure to prototype and deploy AI agents that automate complex financial processes.

This role is based in our San Francisco HQ. We use a hybrid work model of three days in the office per week and offer relocation assistance.

In this role, you will:

Build and own the architecture for self-serve and automated insight delivery — from data pipelines to dashboards, alerts, and agents.

Design and deploy agentic solutions using OpenAI’s internal tools to automate financial workflows such as daily pacing updates and forecast variance explanations.

Create scalable and reusable dashboards to support forecasting, LTV analysis, pricing, investment decisions, and KPI reporting.

Develop data tools and intelligent agents that unlock self-serve access to core company metrics across business units.

Translate ambiguous business needs into technical solutions that are resilient, extensible, and intuitive.

Define and enforce data quality standards, governance best practices, and documentation.

You might thrive in this role if you:

Have 6+ years of experience in Analytics Engineering, BI Development, or a hybrid DS/DE role at a high-growth or high-scale company.

Are fluent in SQL and Python or another scripting language for automation.

Have deep experience with BI tools like Tableau, Looker, or equivalent (e.g. designing scalable semantic layers and metric definitions).

Are excited by the opportunity to build agents that automate manual financial and reporting processes and want to be at the forefront of using OpenAI’s own technologies to do so.

Understand financial and operational metrics deeply and have worked closely with FP&A or Strategic Finance teams.

Take initiative and ownership over the full lifecycle of data systems, tools, and agents.

Communicate clearly with both technical and non-technical stakeholders, translating insight into impact.

Thrive in fast-paced, ambiguous environments and love solving foundational problems.

About OpenAI

OpenAI is an AI research and deployment company dedicated to ensuring that general-purpose artificial intelligence benefits all of humanity. We push the boundaries of the capabilities of AI systems and seek to safely deploy them to the world through our products. AI is an extremely powerful tool that must be created with safety and human needs at its core, and to achieve our mission, we must encompass and value the many different perspectives, voices, and experiences that form the full spectrum of humanity.

We are an equal opportunity employer and do not discriminate on the basis of race, religion, national origin, gender, sexual orientation, age, veteran status, disability or any other legally protected status.

For US Based Candidates: Pursuant to the San Francisco Fair Chance Ordinance, we will consider qualified applicants with arrest and conviction records.

We are committed to providing reasonable accommodations to applicants with disabilities, and requests can be made via thislink .

At OpenAI, we believe artificial intelligence has the potential to help people solve immense global challenges, and we want the upside of AI to be widely shared. Join us in shaping the future of technology.