Data Engineer II

Our Opportunity:
Advertising is a critical component of the ecommerce ecosystem and provides a critical revenue stream to the company. The Chewy Sponsored Ads team is looking for Data Engineer II to help with integrating and processing data from various streams to influence product strategy, data science research and machine learning strategy, business and analytical team's strategy.
Sponsored Ads creates a win-win ecosystem for shoppers, brand owners and Chewy. Shoppers (pet Parents) are offered a range of alternate options to help them choose better and learn about new products, new brands, new promotions, and different price points. Brand owners and advertisers get to showcase their product offerings in the front row for their target audience (proud pet owners) and maximize their reach.
Come be part of the Sponsored Ads team's impactful journey at Chewy!
What You'll Do:

• Own the design, development, and maintenance of our end-to-end data pipelines
• Tackle complex data issues to provide insights needed to accomplish our business goals
• Develop data products for analytics and data scientist Team Members to boost their efficiency
• Assist in crafting Proof of Concepts and advise, consult, mentor and coach other data and analytic professionals on data standards and practices
• Lead the evaluation, implementation and deployment of emerging tools and process for analytic data engineering to improve our efficiency as a team
• Develop and deliver communication and education plans on analytic data engineering capabilities, standards, and processes
• Code, test, and detail new or modified data systems to build robust and scalable applications for data analytics
• Actively contribute to team discussions and initiatives, valuing diverse perspectives and encouraging a cooperative work atmosphere.
• Data cataloging & documentation of data sources
• Regularly meet with business partners and analytics teams to understand and solve data needs, short-term and medium-term
• Build trust with internal collaborators to encourage data-driven decision-making
• Partner with data engineering to grow the value of our data products by onboarding new data from our backend and 3rd party systems

What You'll Need:

• Bachelor of Science or Master's degree in Computer Science, Engineering, Information Systems or related field.
• 5+ years of experience in Data Engineering or Business Intelligence roles working with ETL, Data Modeling, and Data Architecture, developing modem data pipelines and applications for analytics (e.g., BI, reporting, dashboards) and advanced analytics (e.g., machine learning, deep learning) use cases.
• Expertise crafting and implementing enterprise data pipelines using modern data engineering approach and tools: Spark, PySpark, Scala, Docker, Databricks, Glue, cloud-native EDW (Snowflake, Redshift), Kafka/Confluence, Presto/Dremio/Athena
• Proficiency in AWS ecosystem, Java, Python, SQL
• Proficiency in data warehouse methodologies and techniques from transactional databases to dimensional data modeling, to wide denormalized data marts.
• Experience with writing and reviewing version-controlled code (GitHub).
• Experience effectively presenting insights and summarizing complex data to diverse audiences through visualizations.
• To be a self-starter with the ability to take initiative and drive projects forward independently.
• Familiarity with Retail Media or Ad Tech is a plus

The specific salary offered to a candidate may be influenced by a variety of factors including but not limited to the candidate's relevant experience, education, and work location. In addition, this position is eligible for 401k and a new hire and annual equity grant.
We offer different types of insurance, such as medical/Rx, vision, dental, life, disability, hospital indemnity, critical illness, and accident. We offer parental leave, family services benefits, backup dependent care, flexible spending accounts, telemedicine, pet adoption reimbursement, employee assistance program, and many discounts including 10% off pet insurance and 20% off at Chewy.com.
Salaried-exempt team members have unlimited PTO, subject to manager approval. Team members will receive six paid holidays per year. Team members may be eligible for paid sick and family leave in compliance with applicable state and local regulations.
Pay Range
$115,500-$183,500 USD
Chewy is committed to equal opportunity. We value and embrace diversity and inclusion of all Team Members. If you have a disability under the Americans with Disabilities Act or similar law, and you need an accommodation during the application process or to perform these job requirements, or if you need a religious accommodation, please contact CAAR@chewy.com.
If you have a question regarding your application, please contact HR@chewy.com.
To access Chewy's Customer Privacy Policy, please click here. To access Chewy's California CPRA Job Applicant Privacy Policy, please click here.