Job Description

Job Information

Date Opened

12/30/2025

Job Type

Full time

Job Opening Status

In-progress

Work Experience

5+ years

Industry

FMCG/Foods/Beverage

City

Dubai

State/Province

Dubai

Country

United Arab Emirates

Zip/Postal Code

337-1500

About Us

Raqmiyat is a UAE-based IT and digital transformation company specializing in consulting, staffing, and enterprise technology solutions. We empower banking, government, and enterprise clients across the Middle East to achieve their digital objectives.

The Data Architect is responsible for

designing, governing, and optimizing enterprise data architecture

spanning

Oracle Fusion ERP

and

non-Oracle analytics platforms

such as

Snowflake, Power BI, and cloud data lakes

.


The role ensures

accurate, traceable, and compliant data flows

across

procure-to-pay, plan-to-produce, quality, inventory, and order-to-cash

processes in a

Food & Beverages manufacturing

context.

Key Responsibilities

1. Oracle Fusion & Manufacturing Data Architecture

Architect end-to-end data flows across: + Oracle Fusion Financials, SCM, Manufacturing, Inventory, Quality, and Procurement

Understand

F&B manufacturing data models

, including: + Batches, lots, recipes, BOMs, yields, scrap, and rework
+ Shelf life, expiry, and traceability

Design ERP data extensions while minimizing customization Govern quarterly Oracle Fusion releases and data impact

2. Enterprise Analytics Architecture (Oracle + Non-Oracle)

Design analytics architecture using: + Snowflake (or equivalent cloud data warehouse)
+ Power BI for enterprise reporting and self-service analytics
+ Optional data lake / streaming platforms

Define

canonical data models

for: + Production efficiency (OEE, yield, variance)
+ Quality & compliance reporting
+ Costing, margin, and inventory analytics

Ensure metric consistency between OTBI, OAC (if used), and Power BI

3. Data Integration & Pipelines

Define integration patterns using: + Oracle BICC, OTBI extracts, REST APIs
+ OIC or non-Oracle iPaaS tools
+ Batch and near-real-time pipelines

Integrate Fusion with: + MES, LIMS, WMS
+ Supplier, logistics, and distributor systems

Optimize latency for operational and executive reporting

4. Manufacturing, Quality & Traceability Data

Architect data models supporting: + Lot & batch genealogy
+ Ingredient traceability (farm-to-fork)
+ Recall readiness and regulatory audits

Enable analytics for: + Quality deviations and root cause analysis
+ Waste reduction and yield optimization
+ Shelf-life and expiry risk monitoring

5. Data Governance, MDM & Quality

Define

master data strategy

across: + Items, suppliers, customers, recipes, plants

Establish

data ownership and stewardship

Define data quality rules and reconciliation controls Support metadata, lineage, and auditability

6. Security, Privacy & Compliance

Protect sensitive data: + Financials, supplier contracts, formulations, PII

Design role-based access across ERP and analytics platforms Ensure compliance with: + Food safety regulations
+ Internal audit and SOX (if applicable)
+ Data privacy regulations

7. Architecture Governance & Stakeholder Management

Participate in

Architecture Review Boards

Provide design assurance for ERP, manufacturing, and analytics initiatives Guide system integrators and analytics vendors Collaborate with Manufacturing, Quality, Finance, and Supply Chain teams

Key Deliverables

Oracle Fusion SnowflakePower BI Reference Architecture Manufacturing & Quality Data Models Canonical ERP-to-Analytics Data Definitions Data Governance & MDM Framework Integration & Pipeline Design Documents Architecture Review & Compliance Reports

Requirements

Required Skills & Experience

Oracle & ERP

Strong experience with: + Oracle Fusion ERP (SCM, Manufacturing, Inventory, Financials)
+ Fusion data models and BICC / OTBI
+ Oracle Integration Cloud or equivalent