Business Analyst - Transportation
Williams-Sonoma, Inc. · Memphis, TN · 1 wk ago
On-siteInformation TechnologyFull-time
About the role
The Business System Analyst - Transportation position is located in Memphis, TN. This position is not eligible for visa sponsorship.
Responsibilities
- Develop and maintain executive-level dashboards and reports tracking transportation KPIs including cost per shipment, on-time delivery, carrier performance, and mode efficiency.
- Design, build, and manage ETL workflows to consolidate data from carrier portals, TMS platforms, internal supply chain systems, and third-party logistics providers.
- Conduct deep-dive analyses on freight spend, lane optimization, capacity planning, and network design to surface cost-saving opportunities.
- Partner with procurement and carrier management teams to provide data-driven support during contract negotiations and RFP cycles.
- Build and maintain scalable data models that support both operational reporting and strategic scenario planning.
- Champion data quality standards across transportation datasets, identifying gaps and working with IT and data engineering teams to resolve them.
- Explore and pilot AI/ML applications within transportation analytics, including predictive freight cost modeling and anomaly detection.
- Communicate findings clearly to both technical and non-technical stakeholders, including senior leadership.
Requirements
- High School Diploma or Equivalent.
- At least 1+ years of experience in Power BI or Tableau; ability to build production-grade dashboards with calculated fields, drill-throughs, and row-level security.
- At least 3+ years in logistics, supply chain, or transportation analytics; familiarity with freight modes (FTL, LTL, ocean, air, parcel) and carrier management.
- Able to bend, reach, squat, and climb stairs/ladders.
Qualifications
- Bachelor's degree in Supply Chain, Business Analytics, Industrial Engineering, or a related field; MBA or advanced degree a plus.
- Familiarity with AI/ML concepts applied to supply chain such as demand forecasting, cost prediction, or anomaly detection; experience with Copilot, Python, or ML platforms.
- Experience working within global or multi-regional transportation networks (North America, Europe, APAC).
- Knowledge of trade compliance, customs, or international freight documentation.
- Experience with Python or R for statistical analysis or automation.
- APICS CSCP or similar supply chain certification.
Benefits
Generous discount on all Williams-Sonoma, Inc. brand products. 401(k) plan and other investment opportunities. Paid vacations, Employee Assistance Programs, Time Off to Volunteer, Matching Gifts Community Service Program, and Holidays (in some locations). Health benefits, dental and vision insurance, including same-sex domestic partner benefits, Legal and Identity Protection Plans and Pet Insurance.