Oracle Fusion ERP & BI Data Integration Specialist

The Trade Desk; Los Angeles (CA); On-site; USD 94,000 - 172,000; Full time

Benefits offered by this job

Healthcare benefits

401(k) plan

Stock-based compensation

Job summary

The Trade Desk, a leading global adtech platform in Los Angeles, seeks an experienced BI and data integration engineer to support Oracle Fusion ERP and BI reporting. You will design data models, build dashboards in Power BI/Tableau, and develop scalable ETL/ELT pipelines.

Strong SQL, Python, and middleware experience are required to deliver cross-system analytics. You will work with Finance Systems to implement data-driven insights, leveraging AI enhancements and secure data practices across

Qualifications

• Bachelor's degree in computer science, information systems, engineering, or a related field.

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).
• Design data models, star schemas, fact and dimension tables, and KPIs for cross-system reporting.
• Develop enterprise reporting datasets combining Oracle Fusion ERP with external data.
• Create interactive BI dashboards, scorecards, executive reports, and self-service analytics using Power BI and Tableau.
• Develop 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 integrations between Oracle Fusion ERP and third-party systems.
• Translate business/technical requirements into design documents.
• Explore Generative AI tools to boost analytics productivity.
• Enable natural language querying with Large Language Models for automated reporting.
• Follow security, data privacy, change management, and production support standards.

Skills

Power BI

Tableau

SQL

Python

Stakeholder management

Data modeling

ETL/ELT

Oracle Fusion

REST APIs

Education

Bachelor's degree in computer science / information systems / engineering

Tools

Boomi

Jitterbit

OIC

Oracle BI Cloud Connector

Job description

The Trade Desk, a leading global adtech platform in Los Angeles, seeks an experienced BI and data integration engineer to support Oracle Fusion ERP and BI reporting. You will design data models, build dashboards in Power BI/Tableau, and develop scalable ETL/ELT pipelines.

Strong SQL, Python, and middleware experience are required to deliver cross-system analytics. You will work with Finance Systems to implement data-driven insights, leveraging AI enhancements and secure data practices across