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

• 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
  

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