Oracle ERP Technical Developer

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

Job summary

The Trade Desk is seeking a seasoned BI/ETL developer to support Oracle Fusion ERP data extraction, design data models, and build enterprise dashboards. You will work on real-time and batch integrations, crafting semantic models and KPI definitions using Power BI/Tableau.

The role emphasizes data accuracy, security, and cross-system reporting in a fast-paced environment. You will collaborate with Finance Systems to translate business needs into technical designs, leverage AI tools for

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.

Skills

Analytical thinking

Communication

Stakeholder management

Problem solving

Attention to detail

Education

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

Tools

Power BI

Tableau

Boomi

Jitterbit

OIC

SQL

Python

Oracle Fusion Cloud

Oracle BI Cloud Connector

Oracle Visual Builder Cloud Service

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.

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.

The Trade Desk does not accept unsolicited resumes from search firm recruiters. Fees will not be paid in the event a candidate submitted by a recruiter without an agreement in place is hired; such resumes will be deemed the sole property of The Trade Desk. The Trade Desk is an equal opportunity employer. All aspects of employment will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.

The Trade Desk will consider qualified applicants with criminal histories for employment in a manner consistent with the requirements of the Los Angeles Fair Chance Initiative for Hiring, Ordinance No. 184652.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

In accordance with various US state laws, the range provided is the Trade Desk's reasonable estimate of the base compensation for this role. The actual amount may differ based on non-discriminatory factors such as experience, knowledge, skills, and location. All employees may be eligible to become The Trade Desk shareholders through eligibility for stock-based compensation grants, which are awarded to employees based on company and individual performance. The Trade Desk also offers other compensation depending on the role such as variable compensation-based incentives and commissions. Plus, expected benefits for this role 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 thru the first year and 160 hours thereafter, and around 13 paid holidays per year. Employees can also purchase The Trade Desk stock at a discount through The Trade Desk's Employee Stock Purchase Plan.

The Trade Desk also offers a competitive benefits package.

Note: Interns are not eligible for variable incentive awards such as stock-based compensation, retirement plan, vacation, tuition reimbursement or parental leave

At the Trade Desk, Base Salary is one part of our competitive total compensation and benefits package and is determined using a salary range. The base salary range for this role is $93,800 — $172,000 USD

As an Equal Opportunity Employer, The Trade Desk is committed to creating an inclusive hiring experience where everyone has the opportunity to thrive.

Please reach out to us [e-mail] request an accommodation or discuss any accessibility needs you may require to access our Company Website or navigate any part of the hiring process.

When you contact us, please include your preferred contact details and specify the nature of your accommodation request or questions. Any information you share will be handled confidentially and will not impact our hiring decisions.