Supply Chain Analyst (Demand Planning)

Engagement teams range from three people to more than 200 on multi-year transformation programs.

The role

This is a new role. The team has doubled in size over the past year. This role is data-heavy: Excel, SQL and Power BI every day. Reports to the Supply Chain Manager. Remote position. Most of the team is in Sioux Falls, but nobody is required to come in. You can set your own hours around a daily morning check-in. Most communication happens in Slack, with short video calls when needed.

Main duties

• Set and review safety stock and reorder points.
• Identify slow-moving and obsolete inventory and recommend actions.
• Pull data from the ERP and WMS with SQL.
• Clean up item master data such as lead times, pack sizes and lot sizes.
• Document assumptions and methods behind each model.
• Model the effect of supplier lead time changes on stock levels.
• Report weekly KPIs to supply chain leadership.

Qualifications

• 2+ years of supply chain, inventory or operations analysis experience.
• Advanced Excel (pivot tables, XLOOKUP, Power Query)
• Comfortable with large data sets.
• Bachelor's degree in supply chain, industrial engineering, business analytics or a related field.
• Working SQL skills.

Nice to have

• Six Sigma Green Belt.
• APICS CPIM or CSCP.

Pay: $74,000 - $100,000 per year

Perks and benefits

• Health insurance.
• 401(k) with 4% match.
• Paid parental leave.

Rodriguez Advisory provides equal employment opportunities to all employees and applicants.

Start: Flexible.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Rodriguez Advisory LLC.