Operations Analyst Fall Intern

Program Dates: Flexible on start date/end date and flexible on full-time or part-time work The base pay for this position is $24 per hour This is a Boston based opportunity At this time, Wayfair will not sponsor applicants for employment authorization for this position for the following work visas: STEM OPT EAD, H-1B, H-1B1, E-3, O-1, J-1, or TN Role Overview: We’re looking for a Sales & Service Analytics Intern this fall to support our team in driving impactful analysis, dashboarding, and automation efforts. This role will collaborate closely with analysts and stakeholders to deliver actionable insights, streamline reporting, and ensure data accuracy. Strong skills in SQL (preferably Google BigQuery) are essential for this role. Key Responsibilities: Assist with analytics tasks across the team, including dashboard development and maintenance Conduct ad hoc analysis to support business questions and stakeholder needs Write and optimize queries in Google BigQuery (GBQ) or similar SQL-based environments Leverage AI tools where appropriate to improve speed and efficiency of analysis Support automation efforts through query development and data structuring Primary Projects: Revamp the Specialized WBR (weekly business review): Build structured, automated data pipelines and dashboards to support business reviews Proactive Monitoring Infrastructure: Develop alerting mechanisms to flag data issues or refresh failures in key tables and dashboards, ensuring data accuracy and reporting reliability What You’ll Need: Basic Qualifications: Current Sophomore, Junior or Senior student pursuing an undergraduate degree in a relevant discipline (eg. analytics, supply chain, business operations) with a 3.0 GPA minimum Authorization to work in the United States without visa sponsorship by Wayfair now or in the future. Visa sponsorship includes the following work visas: STEM OPT EAD, H-1B, H-1B1, E-3, O-1, J-1, or TN Preferred Qualifications: Strong skills in SQL (preferably Google BigQuery) Strong business acumen: ability to understand how various parts of the business interact; can identify and approach problems from a customer or supplier perspective Exceptional analytical and quantitative problem-solving skills: excited about working with and synthesizing big data into actionable insights; comfortable using data software to conduct analyses and synthesize findings Excellent written and verbal communication skills: ability to summarize and share results with key stakeholders Proficient with Microsoft Excel/Google Sheets Why You’ll Love Wayfair: Wayfair was selected as a top 100 Internship program for 2025 by Yello & WayUp! We take pride in delivering a best in-class experience! You’ll be assigned real projects and contribute directly to your team’s goals and objectives. Purpose & Inclusion at Wayfair: At Wayfair, we pride ourselves on fostering an environment where every individual experiences a fair and equitable employee journey. We are committed to developing targeted resources that raise awareness around inclusion and eliminate barriers, ensuring Wayfair provides a fair and inclusive workplace experience for everyone. Social Impact & Responsibility: At Wayfair, we focus on helping people on their journey to home - specifically those who have lost their way from home. We do this by leveraging our best assets, such as collaborating with leading nonprofit organizations, coordinating in-kind product donations, empowering our employees to get involved through paid volunteer time off programs, and encouraging our customers to donate. This multi-faceted approach allows us to support communities in need in authentic ways that align with Wayfair's broader mission of helping everyone, anywhere create their sense of home. About Wayfair Inc. Wayfair is one of the world’s largest online destinations for the home. Whether you work in our global headquarters in Boston, or in our warehouses or offices throughout the world, we’re reinventing the way people shop for their homes. Through our commitment to industry-leading technology and creative problem-solving, we are confident that Wayfair will be home to the most rewarding work of your career. If you’re looking for rapid growth, constant learning, and dynamic challenges, then you’ll find that amazing career opportunities are knocking. No matter who you are, Wayfair is a place you can call home. We’re a community of innovators, risk-takers, and trailblazers who celebrate our differences, and know that our unique perspectives make us stronger, smarter, and well-positioned for success. We value and rely on the collective voices of our employees, customers, community, and suppliers to help guide us as we build a better Wayfair – and world – for all. Every voice, every perspective matters. That’s why we’re proud to be an equal opportunity employer. We do not discriminate on the basis of race, color, ethnicity, ancestry, religion, sex, national origin, sexual orientation, age, citizenship status, marital status, disability, gender identity, gender expression, veteran status, genetic information, or any other legally protected characteristic. Your personal data is processed in accordance with our Candidate Privacy Notice ( ). If you have any questions or wish to exercise your rights under applicable privacy and data protection laws, please contact us at [email protected] .