Oracle Fusion Analytics Finance Functional Consultant

7 - 12 years

Hyderabad Pune Bengaluru

Posted:5 hours ago

Job Description

  • Job Description Summary
  • Role Summary
  • We are seeking an experienced Oracle Fusion Finance Functional Resource to bridge our core Oracle ERP financial modules and our SQL-based analytics ecosystem. You will ensure accurate financial data extraction, validate General Ledger (GL) and Accounts Receivable (AR) datasets, and support reliable reporting across Power BI.
  • Job Description
  • Key Responsibilities
  • Data Validation & Reconciliation:

    Perform end-to-end data validation and reconciliation between Oracle Fusion Financials (GL, AR) and downstream SQL databases/Power BI dashboards to guarantee 100% financial accuracy.
  • Analytics & Reporting Support:

    Design, validate, and troubleshoot financial reports in Power BI, translating complex accounting logic into clear analytical views.
  • Data Extraction & SQL Querying:

    Write and optimize SQL queries to extract, transform, and audit data across Oracle Fusion tables (via OTBI, BI Publisher, or external data pipelines).
  • Troubleshooting & Root Cause Analysis:

    Investigate data discrepancies, broken data connections, and reporting anomalies across Oracle data connectors and reporting layers.
  • Stakeholder Collaboration:

    Partner with offshore/onshore finance teams and data engineers to refine reporting requirements and maintain data governance standards.
  • Required Qualifications
  • Oracle Fusion Expertise:

    3+ years of hands-on functional experience with Oracle Fusion Cloud Financials, specifically

    General Ledger (GL)

    and

    Accounts Receivable (AR)

    .
  • SQL & Data Architecture:

    Strong proficiency in writing complex SQL queries and understanding Oracle Fusion underlying database schemas/tables.
  • BI & Reporting Tools:

    Proven experience building, validating, and troubleshooting reports in

    Power BI

    (including managing Oracle data connections and gateways).
  • Analytical Mindset:

    Demonstrated ability to reconcile sub-ledger to GL balances and trace data lineage from source transaction to visual report.
  • Offshore Readiness:

    Strong written and verbal communication skills with the ability to work independently and overlap with global team hours as needed.
  • Preferred Qualifications
  • Experience with Oracle Fusion Analytics Warehouse (FAW), OTBI, or BI Publisher (BIP).
  • Familiarity with ETL/ELT pipelines connecting Oracle Cloud ERP to external SQL data warehouses (e.g., Azure SQL, Snowflake, SQL Server).

Skills Required

Consulting Power Bi Downstream Power Bi Dashboards SQL Analytics Functional Fusion Financials

Learn the skills this job asks for

Free courses, interview questions and practice for each skill.

Work Mode

Hybrid

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Jade Global logo
Jade Global

Information Technology and Services

San Diego

RecommendedJobs for You