Oracle Fusion SCM Consultant

• 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, 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, 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), Bridge and aggregate layers

• 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, Slowly changing dimensions (SCDs)
• Have experience producing Source-to-Target mapping documentation for ETL/ELT projects, data migration initiatives, and integration workstreams

Exposure to HRMS, Project Management, and Primavera modules