Oracle ERP Technical Developer

The Trade Desk; Irvine (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

The Trade Desk is seeking an Oracle ERP Technical Developer to design, build, and support data and analytics solutions across Oracle Fusion ERP and external systems. You will ingest, transform, and model data, develop dashboards, and support BI Publisher reports.

You will work with middleware tools (Boomi, Jitterbit, OIC) to enable real-time and batch integrations, and leverage AI features to improve analytics productivity and enable natural language querying.

Skills

Data modeling

BI dashboards

Power BI

Tableau

Data integration

SQL

AI for analytics

LLMs for queries

Tools

Oracle BI Cloud Connector (BICC)

Oracle Fusion ERP

Boomi

Jitterbit

OIC

REST APIs

SOAP

FTP/SFTP

VBCS

BI Publisher

Incorta BI

Job description

The Trade Desk is a global technology company and the world’s leading independent platform for digital advertising, with over 3,000 employees across more than 30 offices. Our technology helps advertisers reach the right audiences across the open internet - from streaming TV and podcasts to mobile apps, news, and more.

Advertising powers the content people love. By making it more transparent, effective, and responsible, we help support trusted journalism, quality entertainment, and creators worldwide. The world’s brands and agencies rely on us to reach their customers and grow their businesses responsibly.

The scale of our platform brings unique technical challenges - from processing massive datasets in real time to building systems that operate reliably on a global scale. When you work here, your impact is worldwide. We welcome diverse perspectives, encourage curiosity, and build teams that learn from one another. If you’re driven to solve meaningful challenges, we’d love to meet you.

What we do:

The Finance Systems team supports the technology needs of the Finance organization by managing and maintaining key applications, including Oracle ERP, Oracle EPM, Incorta BI, Coupa P2P, Kyriba, GetPaid, Boomi Middleware, Anaplan and multiple other applications.

The Oracle ERP Technical developer will be responsible for designing, developing, and supporting integrated data and analytics solutions, middleware integrations and Oracle ERP Extensions. This role manages data ingestion and transformation, developing data models, dashboards, and BI Publisher reports.

What you'll do:

• Configure and support Oracle BI Cloud Connector (BICC) extracts from Oracle Fusion Cloud ERP.
• Design and support downstream ingestion processes that load BICC extract files into data warehouses and BI semantic models.
• Extract, ingest, and transform data from non-Oracle and external systems.
• Develop batch and real-time data extraction processes using Boomi, Jitterbit, OIC (or equivalent middleware), REST APIs, SOAP web services, database connections, FTP/SFTP etc
• Design data models, star schemas, fact tables, dimension tables, calculated measures, and KPIs that support accurate cross-system reporting.
• Develop enterprise reporting datasets that combine Oracle Fusion ERP extracts with data from external systems.
• Design and develop interactive BI dashboards, scorecards, executive reports, and self-service analytics solutions using Power BI and/or Tableau.
• Design, develop, enhance, and support BI Publisher reports for Oracle Fusion ERP.
• Build Oracle Fusion Cloud ERP extensions using Oracle Visual Builder Cloud Service (VBCS).
• Develop and support inbound, outbound, real-time, and scheduled integrations between Oracle Fusion ERP and third-party systems.
• Gather business and technical requirements and translate them into technical design documents.
• Leverage Generative AI tools to improve analytics productivity and insight generation.
• Work with Large Language Models (LLMs) to enable natural language querying and automated report generation
• Follow organizational standards for security, data privacy,