Supply Planning BI Analyst — KPI Dashboards & IBP

Socket.dev; United States; On-site; USD 85,000 - 105,000; Full time

Job summary

Socket.dev in the United States is seeking a Supply Planning Analyst to design, develop, and continuously improve reporting, KPI visibility, and advanced analytics that support IBP and supply planning processes.

The role partners with Supply Planning, Operations, Sourcing, Finance, and IT to build Power BI dashboards, automate reporting, support scenario analysis, and enhance data usability for planning reviews, troubleshooting, and cross-functional decisions.

Qualifications

• Bachelor's degree in supply chain, Business Analytics, Information Systems, Industrial Engineering, Finance, or related field preferred.
• Minimum 5 years of experience in supply chain planning, business intelligence, analytics, operations planning, or related disciplines preferred.
• Strong experience with Power BI, data modeling, dashboard development, KPI reporting, and data visualization.
• Proficient in Microsoft Office Suite, with advanced Excel and Business Intelligence reporting capabilities.

Responsibilities

• Lead the development and maintenance of Power BI dashboards, KPI reporting, scorecards, and automated analytics supporting Supply Planning and IBP.
• Develop and monitor key supply planning KPIs, including OTIF, IPF, shrink, take rate, forecast accuracy, inventory health, service levels, and planning performance.
• Design reporting solutions that enable rapid KPI review, root-cause analysis, and data-driven decision-making.
• Maintain a centralized source of truth for supply planning metrics and reporting.
• Develop automated exception reporting and risk identification tools to proactively highlight supply and inventory issues.
• Lead 80/20 analytics and performance reporting to prioritize high-impact opportunities and corrective actions.
• Partner with Supply Planning, Operations, Horticulture, Sourcing, Finance, and IT to deliver actionable dashboards and business insights.
• Provide analytical support, scenario modeling, and KPI trend analysis for IBP reviews.
• Establish and govern KPI definitions, reporting standards, and data governance processes.
• Analyse supply planning performance, identify root causes, and recommend corrective actions.
• Translate business requirements into scalable reporting, predictive analytics, and self-service BI solutions.
• Identify and resolve data quality issues affecting reporting accuracy and planning decisions.
• Support system integrations by defining reporting requirements, data models, and performance metrics.
• Document KPI methodologies, reporting logic, and governance standards to drive consistency and adoption.
• Support strategic projects related to planning optimisation, forecast visibility, inventory management, and supply chain performance.

Skills

Power BI

Data modeling

Dashboard development

KPI reporting

Data visualization

Excel

Education

Bachelor's degree in related field

Tools

Power BI

Excel

SQL

Job description

Socket.dev in the United States is seeking a Supply Planning Analyst to design, develop, and continuously improve reporting, KPI visibility, and advanced analytics that support IBP and supply planning processes.

The role partners with Supply Planning, Operations, Sourcing, Finance, and IT to build Power BI dashboards, automate reporting, support scenario analysis, and enhance data usability for planning reviews, troubleshooting, and cross-functional decisions.