BI Engineer II Search and Discovery

Our Opportunity

Millions of pet parents with unique needs visit looking for products for their beloved pets. We have the task to decide what products would be most useful to them and help them discover those products. How do we do this

Meet the Discovery team @ Chewy. We use best-in-class machine learning techniques and continuously test outcomes to simplify product discovery for pet parents looking for their pet needs on . Our outstanding multi-disciplinary team of data scientists business intelligence engineers software engineers and product managers work together to power personalized recommendations and product discovery for pet parents. Our team has single-threaded ownership of the space allowing us to build impactful products that we can experiment measure with metrics and deliver at a fast pace.

We are hiring a BI Engineer II for our Discovery team in Bellevue this position you will help us build scalable robust analytics solutions for product and conversational discovery experiences at Chewy. You will demonstrate a passion for delivering outstanding customer experience experience building scalable data solutions and bring communication skills that instill trust with your partners.

What Youll Do

• Design develop and maintain scalable data models dashboards and analytics solutions to support decision-making across the Discovery team.
• Leverage structured and unstructured data to uncover insights into customer behavior chat interactions and search/product discovery patterns.
• Partner closely with Product UX and Data Science teams to shape hypotheses and evaluate experiments that improve the customer journey across chat and on-site experiences.
• Translate complex data findings into clear compelling narratives that drive stakeholder alignment and inform roadmap prioritization.
• Develop real-time and batch data pipelines using best practices in data modeling ETL/ELT and warehousing!
• Own the development and delivery of essential data and performance reporting for customer discovery and chat-based experiences.
• Produce documentation dashboards and reports that are accessible maintainable and actionable!

What Youll Need

• BA/BS in Computer Science Engineering Mathematics or a related field.
• 4 years of experience building automated data solutions for analytics with a deep understanding of data modeling SQL and ETL/ELT pipelines.
• Hands-on experience with Redshift Snowflake and S3 or similar data lakes.
• Demonstrated experience integrating data into business/product planning including defining and validating KPIs and user behavior metrics.
• 3 years of experience working with BI tools (Tableau preferred) to build intuitive dashboards and visual narratives.
• 2 years of experience coding in Python R or a similar language.
• Proven ability to craft a data storytranslating analytical insights into strategic recommendations for both technical and non-technical audiences.
• Comfortable working in a dynamic ambiguous environment with incomplete or messy data.
• Strong communication and collaboration skills across technical and non-technical stakeholders.

Bonus

• Experience formulating and testing product or feature-level hypotheses in partnership with product teams.
• Familiarity with Airflow Streamlit and/or other AWS ecosystem tools.
• Background in statistical modeling or predictive analytics.
• Experience with NLP sentiment analysis or conversational analytics (e.g. chatbots virtual assistants or conversation-level event modeling).