Williams-Sonoma – Robbie Ryan – 2026
Summary
Robbie Ryan served as a Sustainability Intern in San Francisco during Summer 2026 with Williams-Sonoma, Inc. (WSI). His work focused on three workstreams: supplier engagement, supplier risk assessment, and GHG assurance. His goals were to identify opportunities to advance supplier decarbonization efforts, develop a tool to assess supplier risks and performance, and build a control framework to support WSI’s GHG assurance efforts.
Goals
To achieve his first goal, Robbie analyzed energy consumption and emissions data for suppliers across several international markets and used the findings to create practical decarbonization guidance for suppliers. For the supplier risk assessment, Robbie designed a data model and associated Power BI dashboard to highlight key aspects of supplier environmental and social data. Finally, Robbie created process flow documentation and designed relevant controls within each process to support the team’s GHG assurance efforts. The largest challenge Robbie faced was designing a versatile Power BI dashboard that included key performance metrics for executives while also highlighting more detailed information for subject matter experts.
Solutions
Robbie’s work impacted WSI in three ways. First, his decarbonization guidance will help suppliers identify appropriate strategies to reduce their Scope 2 emissions. Second, his data model provides a roadmap for WSI to improve its supplier data collection process, while the Power BI dashboard demonstrates the analysis that can be enabled by more comprehensive data. Lastly, the process flow documentation and associated controls provide guardrails for the team to execute its assurance process smoothly while maintaining high-quality data.
Potential Impact
Overall, Robbie created key documentation and tools to support WSI in strengthening supplier engagement, improving supplier data collection and analysis, and mitigating risks associated with GHG reporting.