Data Architect

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

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 Snowflake

• Power 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

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