Weekend Data Analyst Sql Excel Jobs in Bend, OR (NOW HIRING)

POSITION SUMMARY:

The Planning Analyst is responsible for accelerating the integration of advanced analytics, statistical modeling, and data science methodologies into the core inventory planning processes. Acting as the technical engine of the planning department, this role focuses on converting complex datasets into actionable forecasting and optimization models, enhancing the predictability of the supply chain. This position works closely with Inventory Planners to institutionalize data-driven decision-making, optimize modern planning software capabilities, and elevate the technical sophistication of the Sales and Operations Planning (S&OP) process through predictive analytics and simulation modeling.

PRIMARY RESPONSIBILITIES/FUNCTIONS

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions/primary responsibilities.

30% - Advanced Statistical Modeling & Optimization

• Develop, validate, and maintain advanced statistical models and machine learning algorithms to improve demand forecasting accuracy, safety stock parameters, and lead-time variability.

• Run inventory optimization analyses to determine the most cost-effective positioning of stock across warehouses, minimizing total holding costs while preserving fill rates.

25% - Workflow Automation & Analytics Integration

• Seamlessly integrate advanced analytical scripts (e.g., Python, advanced SQL queries) and data visualization tools (e.g., Tableau, Thoughtspot) into standard, repetitive planning workflows to automate and elevate routine processes.

• Design, build, and maintain automated dashboards to track critical inventory performance metrics such as days inventory on hand, fill rates, forecast bias, and stock accuracy, ensuring data integrity across all reports.

20% - S&OP Simulation & Strategic Advisory

• Provide deep-dive predictive analytics and scenario-based simulations for S&OP meetings, visualizing the long-term impacts of inventory constraints, market volatility, or supply chain disruptions.

• Translate highly complex, ambiguous data anomalies into clear, concise, and actionable business recommendations for Inventory Planners and management to mitigate excess stock or shortages.

15% - Systems Optimization & Infrastructure Collaboration

• Serve as the technical super-user for modern supply chain planning software, unlocking advanced capabilities, tuning optimization algorithms, and configuring workflows to better reflect business realities.

• Collaborate closely with data and business operations teams to ensure underlying data infrastructure and data pipelines perfectly support the requirements of the inventory planning models.

10% - External Data Integration & Frameworks

• Develop planning frameworks with suppliers, business partners, and public domain sources (e.g., NOAA) to bring extended data sets and relevant information to the planning process.

Educational/Experience Requirements:

• Bachelor's degree in Supply Chain Management, Business Analytics, Data Science, Statistics, Industrial Engineering, Operations Research, or a highly quantitative field.

• A Master's degree or specialized certification (e.g., ASCM/APICS CSCP, CPIM, or Certified Analytics Professional) is a strong plus.

• 3+ years of experience in supply chain planning, demand forecasting, or inventory management, with a clear and proven track record of deploying analytical or programmatic solutions to business problems.

Required Technical Skills/Knowledge:

• Proficiency in SQL, Python, or R for statistical modeling, process automation, and data pipeline management.

• Strong working knowledge of advanced data visualization tools such as Tableau, Thoughtspot, or Power BI.

• Experience with inventory planning tools, ERP, and WMS. Experience with Blue Yonder supply chain solutions is a strong plus.

General Knowledge and Abilities:

• Demonstrated track record of intellectual curiosity and exceptional problem-solving skills with the ability to dive deep into large, messy datasets, identify anomalies, and formulate creative solutions.

• Ability to translate complex statistical and data science concepts into clear, actionable business language for planners, operational teams, and executive leadership.

• Strong interpersonal skills to effectively collaborate across planning, purchasing, warehousing, operations, finance, and technical teams.

Physical Requirements:

Sedentary position; frequently required to sit, occasionally required to stand, walk, stop, kneel, and bend. Requires the ability to communicate verbally and exchange information over the phone, by video, and in person.

Work Environment:

3 of 5 business workdays in office (required), 2 of 5 business days work from home (optional).