Business Intelligence Engineer III

Our Opportunity:

Chewy is seeking a highly motivated, goal-oriented, dedicated BI Engineer III to join our exciting and fast-paced team in Bellevue, WA. Our team is growing and if you are equally passionate about supply chain, transportation, management information systems, e-commerce, and career growth, an opportunity at Chewy may be a great match! You will get to work side by side with smart, passionate, and highly motivated entrepreneurs. You will be involved in many aspects of building the business and will not be limited by the small-minded bureaucracy typically found in larger companies. We are looking for someone who has the personality, passion, excitement, and drive to succeed!

What You’ll Do:

• Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key decisions and process improvements
• Work closely with the Supply Chain teams in areas including forecasting analytics and design, inventory placement, customer experience and replenishment management continuously optimizing for improved customer experience and in-stock positions
• Analyze demand and resource requirements against available resources to identify risks and opportunities and provide recommendations to solve for resource constraints
• Collaborate with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL and various technological platforms
• Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation
• Respond to high priority requests from senior business leaders
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for secondary data sets

What You’ll Need:

• BA/BS in Computer Science, Engineering, Mathematics or related field.
• Advanced knowledge of SQL and data modeling
• Intermediate Knowledge in Python and advanced data visualization tools such as Plotly/Dash/React/D3Js etc.
• 7+ years of experience building automated data warehousing environments for production reports or tables. Familiarity with Redshift, Snowflake DWH’s and S3 or similar data lakes preferred
• 5+ years’ experience with data visualization tools like Tableau, Looker, Quicksight or similar (familiarity with Tableau preferred).
• 3+ years of experience with data modeling in large Data warehousing, data lake environment
• Advanced ability to draw insights from data and clearly communicate them to the stakeholders and senior management as required.
• Be hard-working, and show ability to deliver on ambiguous projects with incomplete or ‘dirty’ data.
• Knowledge of data management fundamentals and data storage principles.
• Ability and interest in working in a fast-paced and rapidly-changing environment.
• Excellent communication skills, both written and verbal

Bonus:

• Experience with AI/ML , specially using LLM/Agents/Bots in Data Engineering/Visualization/Analysis
• Experience in gathering requirements and formulating business metrics for reporting
• Experience building on AWS Platform services
• Experience with statistical models and building predictive models from scratch

Compensation & Benefits: 

Our salary range for a BI Engineer III position is $134,500.00 - $215,000.00. 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.