Senior Data Engineer, CG Performance Forecasting
Must be ONSITE in Boston, MA (Monday - Thursday)
Wayfair’s Forecasting & Replenishment Analytics team is looking for a Data Scientist/Engineer to create advanced analytical tools and modeling solutions that will help us predict inventory coverage and penetration in CastleGate across various granularities as well as create insights to understand the capability gaps in the program. In this team, you will grow your technical skills, build and eventually own products that are leveraged by cross-functional teams at Wayfair. builds algorithmic solutions to enhance the customer experience, the supplier experience, and internal operational efficiencies that ultimately drive our bottom line. The team consists of technical analysts, data science/ML/economics experts, ML/software engineers and product managers who are responsible for developing and managing global large-scale forecasting and replenishment systems that power Wayfair’s complex supply chain.
The Data Scientist/Engineer for the CG Performance Forecasting team will drive continuous improvement of this space by creating advanced analytical tools and modeling solutions that will help us predict inventory coverage and penetration in CastleGate and work with cross-functional stakeholders for adoption. The Technical Analyst will become an expert in the CG Performance Forecasting space and will engage with Technology, Operations, and Finance partners to ensure we have a unified signal that accurately reflects the future of the business and can be leveraged by these teams. Within this broader team, the CG Performance Forecasting team measures, monitors and predicts performance metrics relevant to Wayfair’s CastleGate program which serve as key inputs for the Commercial/Operations organizations and continuously enhance the CastleGate value proposition for our suppliers and customers.
What You’ll Do:
- Design, develop, and optimize data pipelines to ensure seamless data flow from various sources to storage and analytics systems
- Work with ETL (Extract, Transform, Load) processes to clean and structure raw data for usability
- Set up and maintain scalable, secure, and high-performance databases, data lakes, or warehouses
- Develop and maintain self-service analytics in Looker, designing intuitive LookML models, dashboards, and data exploration tools for business users
- Extract, model, and analyze data from complex sources (operations, logistics, product, and customer databases) to deliver business insights and recommendations
- Serve as the subject matter expert for data, analytics, and testing in specific business domains, ensuring accurate interpretation of core metrics and consumer behavior.
- Develop predictive modeling solutions to generate forward-looking performance projections, improving operational forecasts and aiding labor and capacity planning
- Perform statistical analysis on large datasets to identify performance trends and enhance operational efficiency
- Create key metrics and analytical tools to monitor performance, identify trends, and develop targeted action plans in Wayfair’s CastleGate program
- Build efficient, reusable data structures adaptable to a dynamic environment
- Partner with Inventory Management, Network Management, and Ops Forecasting teams to drive adoption of insights and enhance CastleGate program value for suppliers and customers
- Collaborate across commercial, operations, and technology teams to align Data Science-driven strategies with Wayfair’s business objectives
What You'll Need
- Masters or Bachelors degree in a quantitative field (computer science preferred)
- 2+ years of professional experience
- Professional experience in writing code in structured programming languages (Python, R), writing scripts using GBQ or SQL, creating Pivot Tables and Vlookups in Google Sheets or Excel, and using data visualization tools such as Data Studio, Looker, Tableau or PowerBI
- Team-first attitude with enthusiasm for cross-functional collaboration
- High attention to detail and proven ability to manage multiple, competing priorities simultaneously
- An entrepreneurial spirit and mindset; you must be adaptable and comfortable with change
An Important Note about Wayfair's In-Office Policy:
All Boston-based interns, Co-ops, and corporate employees will be in office in a hybrid capacity. Employees will work in the office on designated days, Monday - Thursday, and work remotely Friday.
Massachusetts Applicants: I understand that it is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
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 (https://www.wayfair.com/careers/privacy). If you have any questions or wish to exercise your rights under applicable privacy and data protection laws, please contact us at dataprotectionofficer@wayfair.com.