Senior Consultant-Demand Planning & Supply Chain

Role Summary
We are seeking an experienced Demand Planning and Supply Chain Planning Data Modeler for to support analytics, reporting, and data architecture initiatives within a High-Tech Manufacturing environment. The ideal candidate will bring deep expertise in demand planning and supply chain planning business processes, combined with strong hands-on experience in data modeling for both transactional and analytical use cases. This role will work closely with business stakeholders, functional SMEs, and data/BI teams to design scalable, high-quality data models that support demand forecasting, supply planning, inventory optimization, and performance analytics.

Key Responsibilities
Demand & Supply Chain Planning Process Expertise
Understand and model end-to-end Demand Planning and Supply Chain Planning processes, including:
Demand forecasting and statistical forecasting
Forecast adjustments and overrides
Consensus demand planning (S&OP / IBP inputs)
Supply planning and capacity planning
Production planning and scheduling
Inventory planning and optimization
Safety stock and reorder point planning
Allocation, ATP/CTP, and backlog management
High-Tech Manufacturing nuances,  such as
Make-to-Stock (MTS), Make-to-Order (MTO), and Configure-to-Order (CTO) models
BOM-driven planning and multi-level assemblies
Contract manufacturing and outsourced production
Long lead-time components and constrained supply
High SKU velocity and rapid product life cycles
Data Modeling & Architecture
Design and maintain  logical and physical data models  for demand and supply planning data domains.
Develop  fact and dimension models  (star / snowflake schemas) for analytics and reporting.
Model key entities such as:
Products and product hierarchies
Customers and customer segments
Demand forecasts (statistical, consensus, final)
Supply plans and production plans
Inventory balances and movements
BOMs and routings
Capacities, constraints, and lead times
Ensure data models support:
Forecast accuracy and bias metrics
Inventory turns and days of supply
Service level and fill rate KPIs
Supply-demand alignment and constraint analysis
Data Integration & Collaboration
Work with source systems such as:
ERP systems (Oracle)
Demand planning and supply planning applications
Manufacturing execution systems (MES)
Partner with ETL / data engineering teams to ensure accurate data ingestion, transformations, and refresh cycles.
Collaborate with business and analytics teams to translate planning and reporting requirements into robust data structures
Governance & Quality
Ensure data consistency, integrity, and traceability across demand and supply planning data sets.
Define master data definitions, hierarchies, and business rules.
Support data validation, reconciliation, and issue resolution across planning systems.

Required Skills & Experience
Must have
5+ years of experience across demand planning, supply chain planning, and data modeling roles.
Strong hands-on experience in data modeling for demand and supply planning analytics.
Deep understanding of demand planning and supply chain planning processes in a High-Tech Manufacturing environment.
Proven experience designing fact and dimension models for planning and supply chain analytics.
Experience working with ERP-sourced data (Oracle).
Ability to translate planning process flows into scalable data models
Data modeling tools (e.g., ERwin, ER/Studio, Lucidchart, or similar)
Advanced SQL for data validation, reconciliation, and analysis
Data warehouse concepts (star schema, snowflake schema, slowly changing dimensions)
Familiarity with BI tools (Tableau, Power BI, Looker, etc.) is a plus

Nice to have

Experience with Oracle Supply Chain Planning Cloud (Demand Management, Supply Planning)
Knowledge of S&OP / IBP processes

Experience with forecast accuracy metrics (MAPE, MAD, Bias)
Exposure to global manufacturing and multi-site planning environments.