Oracle ERP & Analytics Engineer: Data Pipelines, BI & AI

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 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.