Oracle ERP Technical Developer

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, change management, and production support.

Who you are:

• Bachelor's degree in computer science, information systems, engineering, or a related field.
• 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 a middleware tool such as Boomi, Jitter bit 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 that combine 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 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 SQL, PL/SQL and Python experience preferred.
• Experience with Oracle Fusion financial ERP modules.
• Strong analytical, problem-solving, communication, documentation, and stakeholder-management skills.
• Experience with AI-based automation or agentic AI in a finance or ERP setting.

Compensation and benefits:

The base salary range for this role is $93,800 to $172,000 USD. The actual amount may differ based on non-discriminatory factors such as experience, knowledge, skills, and location. All employees may be eligible for stock-based compensation grants. The Trade Desk also offers variable compensation-based incentives and commissions depending on the role. Expected benefits include comprehensive healthcare (medical, dental, and vision) with premiums paid in full for employees and dependents, retirement benefits such as a 401k plan and 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, and an Employee Stock Purchase Plan.

Equal opportunity and accommodations:

The Trade Desk is an equal opportunity employer. All aspects of employment will be based on merit, competence, performance, and business needs. The Trade Desk will consider qualified applicants with criminal histories in a manner consistent with the Los Angeles Fair Chance Initiative for Hiring and the San Francisco Fair Chance Ordinance. Requests for accommodation can be sent to [email protected].