- Performance Monitoring & Reporting (40%):
- Monitor daily and weekly performance metrics across all DC operational categories including Safety, Quality, Delivery, Cost, and Culture (SQDCC)
- Track key performance indicators (KPIs) such as order accuracy, on-time shipment, labor productivity, inventory accuracy, units per hour, and cost per unit shipped
- Maintain and update performance dashboards in Power BI, Looker, or other business intelligence platforms
- Generate standardized daily, weekly, and monthly performance reports for DC leadership and functional managers
- Support Op Ex reporting cadence with timely data compilation and Sr Leadership-ready presentations
- Identify performance variances and flag anomalies requiring immediate attention or investigation
- Create visual scorecards and performance summaries for shift meetings, leadership huddles, and monthly business reviews
- Data Analysis & Trend Identification (30%):
- Extract operational system data for comprehensive analysis
- Perform advanced data manipulation and analysis in Microsoft Excel including pivot tables, complex formulas, and statistical analysis
- Conduct trend analysis to identify patterns in operational performance across shifts, departments, product categories, and time periods
- Analyze historical data to forecast future performance and capacity requirements
- Identify correlations between operational variables (e.g., staffing levels vs. productivity, order volume vs. accuracy)
- Develop predictive insights to support proactive decision-making and resource planning
- Benchmark performance against internal targets, historical baselines, and industry standards
- Root Cause Analysis & Problem Solving (20%):
- Investigate recurring operational issues and performance gaps using structured problem-solving methodologies
- Conduct deep-dive analysis on systemic problems including chronic pick exceptions, delivery delays, quality defects, and productivity challenges
- Collaborate with operational teams to gather context, validate data findings, and understand process constraints
- Document root causes with supporting data evidence and present findings to leadership
- Develop data-driven recommendations for corrective actions and process improvements
- Track effectiveness of implemented solutions through before-and-after performance comparisons
- Support continuous improvement initiatives with analytical insights and measurement frameworks
- Respond to ad hoc analysis from DC leadership with timely and accurate insights
- Business Intelligence & Visualization Development (10%):
- Partner with BI architect and IT teams to identify dashboard and reporting enhancement opportunities
- Define requirements for new visualizations, metrics, and reporting capabilities based on operational needs
- Test and validate new reports and dashboards to ensure data accuracy and usability
- Train end-users on accessing and interpreting dashboard data
- Maintain documentation of data sources, calculation methodologies, and report specifications
- Recommend automation opportunities to streamline manual reporting processes
- Translate complex data analysis into clear, actionable recommendations for non-technical audiences
- Serve as subject matter expert on performance metrics, data definitions, and reporting capabilities