Oracle ERP Technical Developer

The Trade Desk; Chicago (IL); On-site; USD 110,000 - 150,000; Full time

Job summary

The Trade Desk in Chicago seeks an Oracle ERP Technical developer to design, build, and support integrated data and analytics solutions across Oracle Fusion ERP and external systems.

You will create data models, dashboards, and BI Publisher reports, while enabling real-time and batch data flows with middleware and APIs. This role emphasizes security, scalability, and AI-assisted analytics across the enterprise.

Responsibilities

• 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,

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,