Oracle Fusion ERP Reporting and Analytics Consultant

Fusion ERP Reporting & Analytics Technical Consultant

We are looking for a skilled Fusion ERP Reporting & Analytics Consultant with 7+ years of experience in Oracle Fusion reporting and analytics. The role is responsible for designing, developing, testing, troubleshooting, and supporting reports, dashboards, data models, and analytics solutions across Oracle Fusion ERP modules.

The ideal candidate will bring strong hands-on expertise in OTBI, BI Publisher, SQL, Financials subject areas, dashboards, data models, and report development, along with the ability to translate business reporting needs into accurate, high-performing, and user-friendly analytics solutions

- 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.

Qualifications & Skills

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.

Good-to-Have

• Experience with Oracle Visual Builder Studio and Application Composer for custom extensions.
• Experience with report migration, security configuration, role-based access, and production support.
• Familiarity with ERP integrations and downstream reporting dependencies.
• Oracle Fusion ERP or reporting-related certifications.
• Experience working in customer-facing consulting, managed services, or support-integrated delivery environments.

Self-Assessment Questions

• Do you have 7+ years of hands-on experience designing and developing reports in Oracle Fusion ERP?
• Have you independently built BI Publisher reports, OTBI dashboards, SQL-based data models, and reporting layouts?
• Can you troubleshoot report performance, data accuracy, subject area, and SQL issues across Fusion ERP modules?
• Have you worked on reporting requirements for Oracle Fusion Financials, and preferably PPM or Supply Chain?
• Are you comfortable working directly with business stakeholders and functional consultants to translate reporting needs into technical solutions?

 

Career Level - N/A

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 accommodation-request_mb@oracle.com 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.

Experience Level

Senior Level