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.
