Analytics Engineer Internship for E-Commerce
Internship
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.
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
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 of programming languages Understanding of Git for version control Solution-oriented ; curious intellectual mindset and curiosity -
- Strong written and verbal communication with a team player, highly collaborative attitude.
We provide fast results, we scope projects and we are always learning 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. Assistance for Individuals with Disabilities Wayfair is fully committed to providing equal opportunities for all individuals, including individuals with disabilities. As part of this commitment, Wayfair will make reasonable accommodations to the known physical or mental limitations of qualified individuals with disabilities, unless doing so would impose an undue hardship on business operations. If you require a reasonable accommodation to participate in the job application or interview process, please let us know by completing our Accomodations for Applicants form.
