Oracle Fusion Reporting Consultant

We are seeking multiple expert-level report writing consultants with deep Oracle Fusion expertise to join our team. These are fully remote engagements for senior practitioners who can independently design, build, and optimize reports across Oracle's reporting stack while also bringing strong Microsoft reporting capabilities. The ideal candidates are hands-on experts who can deliver production-ready reporting with minimal oversight and advise stakeholders on best-fit reporting approaches.

Start: ASAP

Duration 6-12 months +

Remote

Design, develop, and maintain complex reports and dashboards across the Oracle Fusion reporting ecosystem.

Build and optimize reports using tools such as BI Publisher (BIP), Oracle Transactional Business Intelligence (OTBI), Financial Reporting Studio (FRS), Narrative Reporting, and Oracle Analytics Cloud (OAC).

Create self-service analyses and visualizations using OAC Data Visualization (DV).

Develop reporting and analytics using Fusion Data Intelligence (FDI) / Fusion Analytics Warehouse (FAW).

Extract and stage Fusion data for downstream reporting using BI Cloud Connector (BICC).

Develop ad-hoc analyses and reports using Oracle Smart View for Office, including against EPM/financial reporting cubes.

Develop interactive dashboards and data visualizations in Microsoft Power BI.

Build paginated/pixel-perfect operational reports using SQL Server Reporting Services (SSRS) and/or Power BI paginated reports.

Create and maintain Excel-based reporting using Power Query and Power Pivot for data transformation and modeling.

Translate business and functional requirements into clear, accurate, and performant reporting solutions.

Tune report performance, troubleshoot data and rendering issues, and ensure data accuracy and integrity.

Document report specifications, data sources, and design decisions.

Collaborate with functional teams, data teams, and business stakeholders to validate outputs.

Advise on the appropriate reporting technology for a given use case and recommend reporting best practices.

• Proven, expert-level experience writing reports within Oracle Fusion (Cloud) applications.
• Demonstrated hands-on expertise across Oracle reporting technologies: BIP, OTBI, FRS, Narrative Reporting, and OAC (including OAC Data Visualization).
• Experience with BI Cloud Connector (BICC) for Fusion data extraction.
• Hands-on experience with Oracle Smart View for Office for ad-hoc analysis and reporting.
• Strong working knowledge of Microsoft Power BI, including data modeling, DAX, and dashboard development.
• Experience building paginated reports with SSRS and/or Power BI paginated reports.
• Proficiency with advanced Excel reporting, including Power Query and Power Pivot.
• Solid SQL skills and the ability to work with Oracle Fusion data structures and subject areas.
• Ability to gather requirements and deliver complete reporting solutions independently.
• Excellent communication skills and comfort working in a fully remote environment.

• Experience with Fusion Data Intelligence (FDI) / Fusion Analytics Warehouse (FAW).
• Experience across multiple Oracle Fusion pillars (e.g., ERP, HCM, SCM, EPM).
• Familiarity with data integration and extract strategies for Fusion data.
• Exposure to Microsoft Fabric or Power BI Report Server.
• Prior experience leading or mentoring other report developers.
• Relevant Oracle and/or Microsoft certifications.