Fusion ERP Reporting & Analytics Technical Consultant

Key Responsibilities

• Design, develop, test, and support Oracle Fusion ERP reports and dashboards across Financials, Project Portfolio Management, and Supply Chain business areas.
• Build and enhance BI Publisher reports, including data models, layouts, bursting, parameters, and scheduling.
• Develop and configure OTBI analyses, dashboards, prompts, and subject-area-based reports aligned to business requirements.
• Write, optimize, and troubleshoot SQL queries for reporting, reconciliation, data validation, and performance tuning.
• Gather and analyze business reporting requirements, prepare technical specifications, and convert functional needs into scalable reporting solutions.
• Investigate and resolve reporting issues related to data accuracy, performance, security, integrations, and report output formats.
• Collaborate with functional consultants, business stakeholders, technical teams, and support teams to deliver accurate and meaningful reporting outcomes.
• Develop custom extensions using Oracle Visual Builder Studio and Application Composer where applicable.

Only Oracle brings together the data, infrastructure, applications, and expertise to power everything from industry innovations to life-saving care. And with AI embedded across our products and services, we help customers turn that promise into a better future for all. Discover your potential at a company leading the way in AI and cloud solutions that impact billions of lives.

True innovation starts when everyone is empowered to contribute. That’s why we’re committed to growing a workforce that promotes opportunities for all with competitive benefits that support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing [email protected] or by calling 1-888-404-2494 in the United States.

Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

Mandatory

• 7+ years of hands-on experience in Oracle Fusion ERP reporting and analytics.
• Strong experience with OTBI, BI Publisher, SQL, dashboards, data models, and report development.
• Solid understanding of Oracle Fusion ERP business processes, especially in Financials.
• Experience working with Financials subject areas and developing reports for modules such as General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cash Management, or related areas.
• Experience supporting reporting needs across Project Portfolio Management and/or Supply Chain business areas.
• Ability to create technical specifications based on business reporting requirements.
• Strong SQL development and troubleshooting skills, including performance tuning.
• Experience with XML, XSLT, JSON, and web services.
• Ability to analyze data issues, validate report outputs, and resolve reporting defects.
• Strong communication skills with the ability to work effectively with functional consultants and business stakeholders.

Career Level - N/A