Data Architect

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