Business System Analyst II
Indexed description
- Over 4,000 Full-Time Associates across the Supply Chain
- 14.5M square feet of small parcel, personalization, furniture, and manufacturing space in the domestic US, Williams-Sonoma has developed an agile and capable distribution network consisting of the following:
- Large package / furniture distribution centers located in Southern California, Northern California, Texas, Georgia, and New Jersey totaling 9.2M square feet plus another 1.2M square feet of standalone final-mile furniture hubs.
- Small package eCommerce distribution centers located in Mississippi and Arizona totaling 3.2M square feet, consisting of over 1,000 full-time associates and 1,500 seasonal/temporary associates in Mississippi.
- Sutter Street Manufacturing upholstery factories located in North Carolina and Mississippi totaling with over 1,400 full-time employees producing approximately $900 million to $1 billion in sales of upholstered furniture.
- Transportation Department for Ocean, Air, Trucking, and Rail consisting of over 30 transportation professionals located in Memphis, TN.
- 700 associates in our Sourcing offices in 10 countries in Asia and Europe including China, Vietnam, Singapore, India, Italy, and Turkey.
The Business System Analyst II position is located in Memphis, TN.
This position is not eligible for visa sponsorship.
You'll be excited about this opportunity because you will....
- 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.
- High School Diploma or Equivalent.
- At least 3+ 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 5+ years in logistics, supply chain, or transportation analytics; familiarity with freight modes (FTL, LTL, ocean, air, parcel) and carrier management.
- This is an onsite and in office role.
- Hands-on experience with Alteryx or comparable ETL tools; comfortable building repeatable, automated workflows for data blending and transformation.
- Proficient in SQL for querying large datasets; experience with cloud data platforms (Snowflake, Databricks, Redshift, or similar).
- Proven ability to translate analytical outputs into business narratives; experienced presenting to cross-functional stakeholders and senior leadership.
- Bachelor's degree in Supply Chain, Business Analytics, Industrial Engineering, or a related field; MBA or advanced degree a plus.
- Experience working within global or multi-regional transportation networks (North America, Europe, APAC).
- 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.
- Familiarity with TMS platforms (e.g., Oracle TMS, MercuryGate, BluJay, SAP TM).
- 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.
- Able to bend, reach, squat, and climb stairs/ladders.
- 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.
- For more information on our benefits offers, please visit MyWSIBenefits.com.
- To learn more about our Supply Chain culture and regional associate events, please visit: https://shorturl.at/R3OAX (Login credentials may be required).
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search