Oracle Fusion SCM Consultant
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Client of Salt is seeking an experienced Oracle Fusion SCM SME with a strong techno-functional background to support SCM reporting, data integration, migration, and analytics initiatives.
Key Skills for This Role
Responsibilities
- Act as the primary functional authority for Oracle Fusion SCM modules including Procurement, Inventory Management, Order Management, Finance, Supply Chain Planning, and Costing
- Engage with business stakeholders to elicit, analyze, and document SCM reporting requirements including KPIs, operational dashboards, regulatory reports, and management information packs
- Translate complex SCM business processes into structured functional specifications for integration and reporting design
- Facilitate workshops and working sessions with finance, operations, and procurement teams to validate reporting scope and data requirements
- Lead the creation and maintenance of comprehensive Source to Target (S2T) mapping documents covering Oracle Fusion SCM data objects
- Maintain complete data lineage documentation to ensure traceability from Oracle source systems through transformation layers to final reporting outputs
- Collaborate closely with data engineers on ETL/ELT pipeline design and ensure S2T mappings are implementable within integration platforms such as Azure Data Factory and Databricks
- Define and document business transformation rules for SCM data including unit of measure conversions, currency normalization, status code lookups, supplier hierarchies, item classification mappings, and inventory valuation logic
- Support the design and development of SCM analytical reports and dashboards including procurement spend analysis, inventory aging reports, supplier performance reporting, order fulfillment analysis, and supply chain cost reporting
- Define SCM reporting data models including fact tables, dimension tables, and bridge and aggregate layers
Requirements
- 7+ years of hands on experience with Oracle Fusion, with deep expertise across two or more modules such as Procurement, Inventory, Order Management, Finance, and Supply Chain Planning
- Strong understanding of Oracle Fusion SCM data models including transactional tables, lookup codes, flex fields, and multi org structures
- Proven experience in gathering and documenting SCM reporting requirements within enterprise implementation or migration projects
- Proficient in SQL with the ability to independently write and review extraction queries against Oracle Fusion SCM schema objects
- Working knowledge of data warehouse/data lakehouse concepts including star schema, dimensional modeling, fact dimension relationships, and slowly changing dimensions (SCDs)
- Experience producing Source to Target mapping documentation for ETL/ELT projects, data migration initiatives, and integration workstreams
Full Job Posting
Job Overview
- We are seeking an experienced Oracle Fusion SCM SME with a strong techno functional background to support SCM reporting, data integration, migration, and analytics initiatives.
- The ideal candidate should possess deep expertise across Oracle Fusion SCM modules including Procurement, Inventory Management, Order Management, Finance, Supply Chain Planning, and Costing, along with strong SQL and data mapping capabilities.
- Experience in source to target mappings, ETL/ELT processes, reporting requirements gathering, and data warehousing concepts is essential.
- Exposure to HRMS, Project Management, and Primavera modules will be an added advantage.
Key Responsibilities
- Act as the primary functional authority for Oracle Fusion SCM modules including Procurement, Inventory Management, Order Management, Finance, Supply Chain Planning, and Costing.
- Engage with business stakeholders to elicit, analyze, and document SCM reporting requirements including KPIs, operational dashboards, regulatory reports, and management information packs.
- Translate complex SCM business processes into structured functional specifications for integration and reporting design.
- Facilitate workshops and working sessions with finance, operations, and procurement teams to validate reporting scope and data requirements.
- Lead the creation and maintenance of comprehensive Source to Target (S2T) mapping documents covering Oracle Fusion SCM data objects including tables, views, OTBI subject areas, and BICC PVO models.
- Maintain complete data lineage documentation to ensure traceability from Oracle source systems through transformation layers to final reporting outputs.
- Collaborate closely with data engineers on ETL/ELT pipeline design and ensure S2T mappings are implementable within integration platforms such as Azure Data Factory and Databricks.
- Define and document business transformation rules for SCM data including unit of measure conversions, currency normalization, status code lookups, supplier hierarchies, item classification mappings, and inventory valuation logic.
- Support the design and development of SCM analytical reports and dashboards including procurement spend analysis, inventory aging reports, supplier performance reporting, order fulfillment analysis, and supply chain cost reporting.
- Define SCM reporting data models including fact tables (purchase orders, goods receipts, shipments, work orders), dimension tables (supplier, item, warehouse, cost center, project), and bridge and aggregate layers.
Job Requirements
- Possess 7+ years of hands on experience with Oracle Fusion, with deep expertise across two or more modules such as Procurement, Inventory, Order Management, Finance, and Supply Chain Planning.
- Demonstrate strong understanding of Oracle Fusion SCM data models including transactional tables, lookup codes, flex fields, and multi org structures.
- Have proven experience in gathering and documenting SCM reporting requirements within enterprise implementation or migration projects.
- Be proficient in SQL with the ability to independently write and review extraction queries against Oracle Fusion SCM schema objects.
- Possess working knowledge of data warehouse/data lakehouse concepts including star schema, dimensional modeling, fact dimension relationships, and slowly changing dimensions (SCDs).
- Have experience producing Source to Target mapping documentation for ETL/ELT projects, data migration initiatives, and integration workstreams.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Client of Salt
Oracle Fusion Finance Solution Architect
Riyadh, KSA
We are looking for an experienced Oracle Fusion Finance Solution Architect to join a major ERP transformation programme in Riyadh. This role is suited to a senior Oracle Finance...
Senior Studio Production Manager
Dubai, UAE
We are hiring a Senior Studio Production Manager to oversee end-to-end studio operations for a large-scale, multi category retailer. The role is responsible for managing a team ...
GCP Cloud Architect
Riyadh, KSA
Seeking experienced Cloud Architects to design secure, scalable cloud solutions on Azure and GCP, ensuring compliance and governance for enterprise clients.
IT Disaster Recovery (ITDR) Consultant
Riyadh, KSA
The role involves leading IT Disaster Recovery assessments, designing recovery plans, and developing governance frameworks while engaging stakeholders and ensuring compliance.
AI Engineer
, UAE
Design and implement LangGraph agent graphs, build LLM extraction pipelines, and integrate AI tools while ensuring model evaluation and testing.
SAP S/4HANA SCM Consultant (MM/WM)
Riyadh, KSA
Seeking an experienced SAP S/4HANA SCM Consultant to implement Materials Management and Warehouse Management solutions, ensuring business process optimization and integration.
Senior Consultant SAP BW Migration Expert
United Arab Emirates, UAE
Lead assessment and migration planning for SAP BW, requiring expertise in SAP technologies, stakeholder management, and cloud data platforms.
SAP Basis Lead
Saudi Arabia, KSA
Lead technical delivery of SAP S/4HANA Greenfield implementation, ensuring installation, upgrades, and administration of SAP landscape with strong expertise in architecture and ...
Oracle Fusion Finance Solution Architect
Riyadh, KSA
Senior Studio Production Manager
Dubai, UAE
GCP Cloud Architect
Riyadh, KSA
IT Disaster Recovery (ITDR) Consultant
Riyadh, KSA
AI Engineer
, UAE
SAP S/4HANA SCM Consultant (MM/WM)
Riyadh, KSA
Senior Consultant SAP BW Migration Expert
United Arab Emirates, UAE
SAP Basis Lead
Saudi Arabia, KSA