Data Architect

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

• 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

Requirements

Required Skills & Experience

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