Cloud Data Engineer II

Wayfair - Boston, MA

Full-time - Mid Level

Boston, MA

Furniture, Home Furnishings, Electronics, and Appliance Retailers

About the position

As a Cloud Data Engineer at Wayfair, you will play a crucial role in designing and delivering data solutions that support our Supply Chain Operations. This hands-on position involves building data pipelines, developing data warehouses and lakes, and enabling real-time streaming and big data solutions. You will collaborate closely with business and engineering teams to create scalable and accurate data platforms that drive business strategies and decisions.

Responsibilities

• Build data pipelines to assemble large, complex sets of data that meet non-functional and functional business requirements
• Deliver Data Engineering capabilities for streaming and batch-based data ingestion, enrichment, and aggregation
• Design and develop sophisticated data models and visualizations that support multiple use cases across different products or domains
• Define and manage SLA for all data sets in allocated areas of ownership
• Work closely with data architect, SMEs, and other technology partners to develop & execute on the data architecture roadmap for different functional areas
• Mentor and grow technical skills of engineers across multiple sprint teams by giving high quality feedback in design and code reviews and providing training for new methods, tools, and patterns
• Collaborate with your stakeholders and other business analytics team leaders

Requirements

• Bachelor's or Masters in Computer Science, Computer Engineering, Statistics, or another quantitative discipline
• 5+ years of experience in Data Engineering role
• 3+ years of programming experience with at least one language such as Python, Scala, Java, or other modern OOP programming language
• 3+ years' experience in writing SQL statements
• 3+ years' experience with schema design and dimensional data modeling
• Experience building and optimizing ‘big data' data pipelines, architectures, and data sets
• Experienced developing in cloud platforms such as Google Cloud Platform (preferred), AWS, Azure, or Snowflake at scale
• Experience with real-time data streaming tools like Kafka, Kinesis, Apache Storm, or any similar tools
• Experience in designing data engineering solutions using open source and proprietary cloud data pipeline tools such as Airflow, dbt, Glue, and Beam
• Experience in development of custom built BI and big data reporting solutions using tools like Looker, DataStudio, or any similar tools
• Experience with code management tools (e.g., Git, SVN) and DevOps tools (e.g., Docker, Jenkins)
• Excellent communication and presentation skills, strong business acumen, critical thinking, and ability to work cross functionally through collaboration with engineering and business partners
• Ability to learn quickly and drive deliverables while maintaining ownership/bias
• A team player who is at ease delivering in a group setting

Nice-to-haves

• Supply Chain or E-commerce analytics experience a strong plus
• Prior experience in data science or closely related quantitative field

Benefits

• Paid Holidays
• Paid Time Off (PTO)
• Full Health Benefits (Medical, Dental, Vision, HSA/FSA)
• Life Insurance
• Disability Protection (Short Term & Long Term Disability)
• Global Wellbeing: Gym/Fitness discounts (including US Peloton, Global ClassPass, and various regional gym memberships)
• Mental Health Support (Global Mental Health, Global Wayhealthy Recordings)
• Caregiver Services
• 401K Matching (Employee Matching Program)
• Tuition Reimbursement
• Financial Health Education (Knowledge of Financial Education - KOFE)
• Tax Advantaged Accounts
• Family Planning Support
• Parental Leave
• Global Surrogacy & Adoption Policy
• Rewards & Recognition
• Global Employee Anniversary Awards
• Paid Volunteer Work
• Employee Discount
• U.S. Bluebikes Membership
• Global Pod Outings
• Emphasizing a supportive & flexible work environment that encourages a balance between personal and professional commitments