Position Summary: The S&OP & Planning Analytics Specialist supports the Supply Chain Planning Department by preparing reliable reports, dashboards, data models, queries, and automated analytical outputs. The role acts as the department's reporting and analytics support function, converting planning data into clear insights for management reviews, operational follow-up, and decision-making. S&OP support is part of the role, but the main focus is overall department reporting, planning analytics, data preparation, automation, and performance visibility across demand, supply, inventory, distribution, and planning KPIs.
Key Responsibilities
1. Department Reporting & Analytics
- Prepare and maintain recurring planning reports covering demand, supply, inventory, distribution, availability, and planning KPIs.
- Create management summaries and analytical views to support planning decisions and operational follow-up.
- Consolidate data from different sources and present it in clear dashboards, reports, and business-ready formats.
- Maintain consistent report definitions, calculations, templates, and reporting standards.
2. Data Modeling, Querying & Automation
- Develop and maintain Power BI dashboards, semantic models, and analytical reports.
- Build and optimize SQL queries for sales, inventory, demand, supply, and operational data.
- Use advanced Excel, Power Query, and M language to clean, transform, model, and automate reports.
- Reduce manual reporting by standardizing data flows, templates, refresh logic, and automation processes.
3. Data Preparation & Validation
- Prepare and organize planning data required for reporting, analysis, and business reviews.
- Validate data completeness, accuracy, consistency, and logical alignment before publishing reports.
- Identify missing data, unusual movements, conflicting inputs, and data quality issues.
- Coordinate with stakeholders to resolve reporting gaps, master data issues, and inconsistencies.
4. Planning Performance & Decision Support
- Analyze planning performance across forecast, inventory, availability, supply gaps, replenishment, and service indicators.
- Compare actual performance against plans, targets, history, and agreed assumptions.
- Highlight variances, risks, exceptions, and improvement opportunities requiring attention.
- Translate complex data into clear insights and recommended focus areas.
5. S&OP Support
- Prepare S&OP reporting packs and analytical views for Demand Review, Supply Review, Pre-S&OP, and Executive S&OP meetings.
- Consolidate S&OP inputs and highlight gaps, risks, and alignment needs for discussion.
- Document key decisions, assumptions, risks, and follow-up actions when required.
6. Continuous Improvement
- Improve reporting quality, dashboard usability, data accuracy, automation, and process efficiency.
- Standardize KPI definitions, reporting templates, data sources, and analytical logic.
- Support the department's digital maturity by improving visibility, automation, and reporting discipline.
Required Qualifications:
- Bachelor's degree in Supply Chain, Business, Data Analytics, Engineering, Information Technology, or a related field.
- Minimum 2–3 years of experience in business intelligence, data analytics, reporting, automation, or supply chain planning analytics.
- Experience preparing department reports, dashboards, analytical models, and management summaries.
- Experience supporting planning, inventory, demand, supply, distribution, S&OP reporting.
