Analytics Engineer Internship for E-Commerce (m/f/x)

This role is for our Berlin office location, on a hybrid work model: Monday to Thursday - in office, Friday - remote.

This is a full time 6 months internship position, starting in January 2025.

Wayfair believes everyone should live in a home they love. Through technology and innovation, Wayfair makes it possible for shoppers to quickly and easily find exactly what they want from a selection of millions of items across home furnishings, décor, home improvement, housewares and more. Committed to delighting its customers every step of the way, Wayfair is reinventing the way people shop for their homes - from product discovery to final delivery.

At their core, Analytics Engineers at Wayfair are strong in quantitative analysis and coding but while building fast and scalable solutions for the organization. They think critically to tackle complex challenges, thrive in a fast-paced environment and are seeking a high-growth opportunity where they will have an immediate impact on day one. There are significant opportunities for new passionate team members fresh out of school or with previous professional experience.

You will join the Global Analytics Tech team focused on driving the design, creation and operation of the business infrastructure and key performance indicators that support our operations teams and our business strategy primarily driven by the synergies of the tech and business world.

Whether you’re building data warehouses, scalable data structures, analyzing performance of procedures, troubleshooting errors or building proactive monitoring systems you will be working with cutting edge technology and multi-terabyte datasets.

This is a hybrid role with an in-office expectation from Monday to Thursday.

What You’ll Do

• Assist in the design, development, and maintenance of data warehouses, pipelines and ETL (Extract, Transform, Load) processes
• Collaborate with data engineers and analysts to understand data requirements and ensure data availability for analysis
• Work with various data storage and processing technologies, including [Google SQL]
• Help clean, preprocess, and transform data from diverse sources to make it suitable for analysis
• Support the creation and optimization of databases and data warehouses
• Assist in troubleshooting and resolving data-related issues and bottlenecks
• Learn and apply best practices in data engineering, data modeling, and data governance
• Document data engineering processes and workflows for future reference
• Collaborate with cross-functional teams to support data-driven initiatives and projects

What You’ll Need

• Bachelors or Masters in Computer Science, Computer Engineering, Mathematics, Statistics, Information Systems, or other quantitative STEM disciplines field with strong academic record
• Experience in engineering roles performing backend data warehousing. Quantitative analysis as a plus
• Strong interest in data engineering, big data technologies, and data processing
• Hands-on with DBT/Dataforms, BigQuery, Airflow, GCP and BI tools
• and Python programming skills
• Basic understanding of data management concepts and databases
• Hands-on experience conducting quantitative analyses on large data sets; experience with data modeling tools and visualization tools
• Proficient knowledge of SQL (incl. aggregate functions, joins, etc.). 
• Proficiency in any Python and bash of programming languages
• Understanding of Git for version control 
• Solution-oriented & curious intellectual mindset and curiosity - We provide fast results, we scope projects and we are always learning
• Strong written and verbal communication with a team player, highly collaborative attitude- We communicate effectively without sugar coating, we focus on helping the team on the most value add projects
• Prior experience or coursework related to data engineering is a plus.

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 Berlin, 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.