Oracle SCM Techno Functional Consultant

Estuate Inc. is hiring for a contract role

Remote

Oracle - Techno-Functional Consultant

Finance and SCM Module

We are seeking an experienced **Techno-Functional Consultant** specializing in **Oracle Fusion Supply Chain Management (SCM)** with exposure to **Finance modules** such as Accounts Payable (AP). The candidate will act as the key functional bridge between business stakeholders and technical teams, supporting data extraction from Oracle Fusion, loading into a staging layer, and helping downstream teams understand and consume the data effectively.

Key Responsibilities

?? Functional Support & Business Engagement

- Work closely with business stakeholders to **understand and interpret requirements** through a business lens, ensuring clarity before passing to technical teams.
- Provide functional expertise across core Oracle Fusion modules:
   - **Inventory Management**
   - **Procurement**
   - **Order Management (OM)**
   - **Accounts Payable (AP)**
- Help business users **articulate their data needs clearly** and bridge the gap between what the business asks for and what the data can deliver.
- Act as a **go-to functional resource** for day-to-day queries from both business and technical teams.

?? Data Extraction & Technical Collaboration

- Support the technical team in navigating **Oracle Fusion data structures** across SCM and Finance modules, including key tables, views, and data entities such as:
   - Inventory transactions, on-hand balances, item master
   - Purchase Orders, Receipts, Supplier data
   - Sales Orders, Order Lines, Fulfilment data
   - AP Invoices, Payments, Supplier Invoices
- Guide the technical team on the most appropriate **Oracle Fusion data extraction methods**, including:
   - **OTBI (Oracle Transactional Business Intelligence)**
   - **BIP (Business Intelligence Publisher)**
   - **REST APIs**
   - **FTP-based extracts**
- Validate extracted data against Oracle Fusion source to ensure **accuracy and completeness** before loading into the staging layer.
- Support and review the **loading of data into the staging layer**, ensuring the data is correctly mapped and traceable back to the source.

?? Data Consumption & Modelling Guidance

- Help analytics and data teams **understand the functional meaning** of extracted data entities and how they relate to each other across SCM and Finance modules.
- Provide functional context to support **data modelling decisions**, such as:
   - How Inventory transactions relate to financial postings
   - How Purchase Orders link to Receipts and AP Invoices (Procure-to-Pay flow)
   - How Sales Orders connect to Fulfilment and Revenue (Order-to-Cash flow)
- Advise on how data can be **consumed**  without going into detailed technical design.
- Support teams in understanding **key identifiers, hierarchies, and reference data** (e.g., Item Categories, Inventory Organizations, Business Units, Cost Centers).

?? Cross-Team Enablement

- Be available to **answer functional questions** from BI, analytics, and data teams regarding Oracle Fusion SCM and Finance data.
- Conduct **informal knowledge-sharing** to improve team understanding of module-specific data and business processes.
- Support **data validation exercises** by providing functional context on expected data behaviour and business rules.

Required Skills & Experience

**Skill Area**

**Requirements**

**Oracle Fusion SCM**

Strong hands-on functional knowledge in Inventory, Procurement, Order Management

**Oracle Fusion Finance**

Working knowledge of Accounts Payable (AP) module and its data

**Data Extraction**

Familiarity with Oracle Fusion extraction methods – OTBI, BIP, REST APIs

**Technical Acumen**

Ability to work alongside technical teams, understand SQL queries, data mappings and staging concepts

**Business Engagement**

Proven ability to listen to business requirements and translate them into clear functional and data needs

**Cross-functional Collaboration**

Experience working across multiple teams including technical, analytics, and business

Nice-to-Have Skills

- Exposure to **Procure-to-Pay (P2P)** and **Order-to-Cash (O2C)** end-to-end processes
- Familiarity with **data warehousing or staging layer concepts**
- Experience with reporting tools such as **Oracle Analytics Cloud (OAC), Power BI, or Tableau**
- Knowledge of **Oracle Fusion data model** and standard reporting subject areas

Soft Skills

- Strong **communication skills** with the ability to explain complex functional concepts in simple terms
- Comfortable working in a **collaborative, multi-team environment**
- Pragmatic and **solution-oriented** approach
- Ability to **prioritize and manage** multiple requests from different teams simultaneously
- Proactive in flagging **data or functional gaps** to the relevant stakeholders"