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.