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

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.