Oracle ERP Technical Developer

The Trade Desk•San Jose, CA

7h•$93,800 - $172,000

About The Position

The Oracle ERP Technical Developer will design, develop, and support integrated data and analytics solutions, middleware integrations, and Oracle ERP extensions for The Trade Desk’s Finance Systems team. The team supports Finance applications including Oracle ERP and EPM, Incorta BI, Coupa P2P, Kyriba, GetPaid, Boomi Middleware, and Anaplan. The role focuses on Oracle Fusion Cloud ERP data extraction and integrations, data ingestion and transformation, enterprise data models, dashboards, BI Publisher reports, and ERP extensions. It also involves using generative AI and large language models to improve analytics productivity, support natural-language querying, and automate report generation, while following organizational standards for security, data privacy, change management, and production support.

Requirements

Bachelor’s degree in computer science, information systems, engineering, or a related field.
At least 5 years of experience in software development, Oracle Fusion Cloud technical development, business intelligence development, or enterprise reporting.
Strong experience developing BI Publisher reports, including data models, SQL queries, templates, report bursting, and scheduled delivery.
Hands-on experience developing integrations using middleware such as Boomi, Jitterbit, or OIC.
Experience integrating Oracle Fusion ERP with external systems using REST APIs, SOAP web services, Oracle adapters, FTP/SFTP, and file-based interfaces.
Experience with Oracle Visual Builder Cloud Service, Oracle APEX, Oracle Process Automation, or Oracle SaaS extension technologies.
Experience designing or supporting ETL/ELT pipelines combining Oracle Fusion BICC extracts with third-party or internal system data.
Knowledge of dimensional modeling, star schemas, fact and dimension tables, semantic models, data marts, and data warehouse concepts.
Hands-on experience with Power BI, Tableau, or an equivalent tool for dashboard and analytics development.
Experience creating data models, KPI definitions, calculated measures, visualizations, dashboard filters, drill-through reporting, and scheduled refresh processes.
Strong analytical, problem-solving, communication, documentation, and stakeholder-management skills.

Nice To Haves

Strong SQL, PL/SQL, and Python experience.
Experience with Oracle Fusion financial ERP modules.
Experience with AI-based automation or agentic AI in a finance or ERP setting.

Responsibilities

Configure and support Oracle BI Cloud Connector (BICC) extracts from Oracle Fusion Cloud ERP.
Design and support downstream 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 middleware, APIs, web services, database connections, and FTP/SFTP.
Design data models, star schemas, fact and dimension tables, calculated measures, and KPIs for cross-system reporting.
Develop enterprise reporting datasets combining Oracle Fusion ERP extracts with external-system data.
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.
Use generative AI tools to improve analytics productivity and insight generation.
Work with large language models to enable natural-language querying and automated report generation.
Follow organizational standards for security, data privacy, change management, and production support.

Benefits

Comprehensive medical, dental, and vision healthcare, with premiums paid in full for employees and dependents.
401(k) plan with company match.
Short- and long-term disability coverage.
Basic life insurance.
Well-being benefits.
Reimbursement for certain tuition expenses.
Parental leave.
Sick time of 1 hour per 30 hours worked.
Vacation time for full-time employees: up to 120 hours through the first year and 160 hours thereafter.
Around 13 paid holidays per year.
Employee Stock Purchase Plan allowing employees to purchase company stock at a discount.
Employees may be eligible for stock-based compensation grants.
Variable compensation-based incentives and commissions may be offered depending on the role.