Business System Analyst II

Williams-Sonoma•Memphis, TN

5d•Onsite

About The Position

Williams-Sonoma, Inc. is seeking a data-driven Business System Analyst II to join their Global Transportation team in Memphis, TN. This role will be the analytical driver of logistics operations, transforming complex freight, carrier, and cost data into actionable insights to guide strategic decisions across the international supply chain. The analyst will collaborate cross-functionally with transportation, procurement, finance, and operations teams, influencing how data is utilized throughout the organization. The position is not eligible for visa sponsorship.

Requirements

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
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

Nice To Haves

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

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 identify 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.