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.
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. Click here to learn more.
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
