Oracle Fusion Data Intelligence Consultant

Themesoft Inc.; Phoenix (AZ); On-site; USD 110,000 - 170,000; Full time

Job summary

The Themesoft Inc. team in Phoenix, AZ is seeking a senior analytics consultant with extensive Oracle Cloud experience to convert finance processes into measurable dashboards and KPIs.

The role focuses on delivering insights through Oracle Fusion analytics and allied tools, collaborating with stakeholders across Finance and Analytics workstreams. You will leverage Oracle Fusion Data Intelligence, OAC, OTBI, and BI Publisher to design and deploy end-to-end analytics solutions, while guiding UAT,

Qualifications

• Experience with Oracle Fusion Applications Finance modules is required.
• Strong background in Oracle Fusion Data Intelligence, analytics, and reporting.
• Proficient with Oracle Analytics Cloud (OAC), OTBI and BI Publisher.
• Advanced SQL and complex query development skills.
• Data modeling, warehousing, ETL/ELT, data integration, APIs and performance troubleshooting.

Responsibilities

• Design dashboards, scorecards, KPIs, and executive reporting.
• Translate business requirements into analytics solutions for finance and procurement.
• Lead workshops, map business processes, and facilitate stakeholder discussions.
• Support UAT, end-user training, and solution adoption.

Skills

Oracle Fusion Apps

Oracle FDI

OAC

OTBI

BI Publisher

SQL Mastery

Data Modeling

ETL/ELT

Data Integration

APIs

Performance Tuning

Stakeholder Mgmt

UAT & Training

Oracle Cloud Deployments

Job description

Location: Phoenix, AZ — Onsite

Primary Skill: Oracle Cloud Infrastructure

Required Skills

• Strong hands-on experience with Oracle Fusion Applications, particularly Finance.
• Experience with Oracle Fusion Data Intelligence (FDI) and Oracle analytics solutions.
• Strong knowledge of Oracle Analytics Cloud (OAC), OTBI, and BI Publisher.
• Strong SQL and complex query development skills.
• Experience with data modeling, data warehousing, ETL/ELT, data integration, APIs, performance tuning, and troubleshooting.
• Strong understanding of Oracle Fusion Finance business processes.
• Experience gathering business requirements and translating them into analytics and reporting solutions.
• Experience designing dashboards, scorecards, KPIs, and executive reporting.
• Strong experience conducting fit-gap analysis and recommending Oracle FDI best practices.
• Excellent stakeholder management, workshop facilitation, business process mapping, and client-facing communication skills.
• Experience supporting UAT, user training, and solution adoption.
• Experience with at least 2 end-to-end Oracle Cloud implementations is preferred.
• Finance and Procurement analytics experience is highly desirable.
• Oracle Cloud certifications are preferred.
• Engage with business stakeholders to understand reporting, analytics, KPI, and business intelligence requirements.
• Analyze end-to-end Oracle Fusion Finance business processes and identify opportunities for analytics and reporting improvements.
• Design and develop business dashboards, scorecards, KPIs, and executive reporting solutions using Oracle FDI and related analytics technologies.
• Perform fit-gap analysis and recommend scalable solutions aligned with Oracle FDI capabilities and best practices.
• Develop and optimize SQL queries, data models, ETL/ELT processes, and data integration solutions.
• Work with OAC, OTBI, BI Publisher, and Oracle Fusion Data Intelligence to deliver business reporting and analytics.
• Troubleshoot data, integration, query, and performance-related issues.
• Facilitate requirements workshops, business process mapping sessions, and solution design discussions.
• Support business users through UAT, training, deployment, and solution adoption.
• Collaborate with technical and functional teams across Oracle Cloud, Finance, Data, and Analytics workstreams.
• Support global delivery and consulting engagements while maintaining strong stakeholder communication.
• Contribute to data governance and master data management initiatives where applicable.
• Support integrations between Oracle Fusion and third-party analytics platforms such as Power BI and Tableau.
• Explore and leverage Oracle Fusion AI/GenAI capabilities where applicable.