Sr. Consultant – Oracle Fusion

Join Delphi - Where Innovation meets transformation

At Delphi, we believe in creating an environment where our people thrive. Our hybrid work model empowers you to choose where you work—whether it's from the office, your home, or a mix of both—so you can prioritize what matters most. We are committed to supporting your personal goals, family, and overall well-being while driving transformative results for our clients.

We welcome exceptional talent from anywhere across the globe. Interviews and onboarding are conducted virtually, reflecting our digital-first mindset.

Rooted in the region, we specialize in delivering tailored, impactful solutions in Data, Advanced Analytics and AI, Infrastructure, Cloud Security, and Application Modernization. Whether it’s enabling predictive analytics, transforming operations with automation, or driving customer engagement with intelligent platforms, we are the trusted partner for organizations ready to embrace a smarter, more efficient future.

Role

Oracle Fusion Techno Functional Consultant

Location

KSA onsite

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:

o Unit-of-measure conversions

o Currency normalization

o Status code lookups

o Supplier hierarchies

o Item classification mappings

o Inventory valuation logic

Support the design and development of SCM analytical reports and dashboards including:

o Procurement spend analysis

o Inventory aging reports

o Supplier performance reporting

o Order fulfillment analysis

o Supply chain cost reporting

Define SCM reporting data models including

o Fact tables (purchase orders, goods receipts, shipments, work orders)

o Dimension tables (supplier, item, warehouse, cost center, project)

o 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:

o Star schema

o Dimensional modeling

o Fact-dimension relationships

o Slowly changing dimensions (SCDs)

Have experience producing Source-to-Target mapping documentation for ETL/ELT projects, data migration initiatives, and integration workstreams.

Required Technical Skills

Act as the primary functional authority for Oracle Fusion SCM modules including:

o Procurement

o Inventory Management

o Order Management

o Finance

o Supply Chain Planning

o Costing

Engage with business stakeholders

o Elicit SCM reporting requirements

o Analyze business reporting needs

o Document reporting requirements

Support reporting initiatives including

o KPIs

o Operational dashboards

o Regulatory reports

o Management information packs

Experience Requirements

7+ years of hands-on experience with Oracle Fusion, with deep module coverage across two or more

of

Procurement, Inventory, Order Management, Finance, Supply Chain Planning.

Preferred Qualifications

• Bachelor’s degree in B.Tech or equivalent qualification.
• Experience working on HRMS modules.
• Experience with Project Management modules.
• Experience with Primavera modules.

What we offer

At Delphi, we are dedicated to creating an environment where you can thrive, both professionally and personally. Our competitive compensation package, performance-based incentives, and health benefits are designed to ensure you're well-supported. We believe in your continuous growth and offer company-sponsored certifications, training programs, and skill-building opportunities to help you succeed.

We foster a culture of inclusivity and support, with remote work options and a fully supported work-from-home setup to ensure your comfort and productivity. Our positive and inclusive culture includes team activities, wellness and mental health programs to ensure you feel supported.