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