Business Intelligence Engineer II

At Chewy, it is our mission to become the most trusted and convenient online destination for pet parents and our partners vets and service providers alike.  Our success is measured by the happiness of the people and pets we serve, not simply by the amount of pet supplies we deliver. That’s why we continue to think of outside-the-Chewy-box ways to delight, surprise, and thank our loyal pet lovers!

Our Opportunity:

We are looking for a Business Intelligence Engineer II at our facility in Bellevue, Washington to design, develop, implement, test, document, and operate large-scale dataset to define metrics and build BI solutions in the form of Dashboard report and/or LLM agents for analytics and deep business insights as part of our Outbound Supply Chain technology.

What You’Ll Do:

• Implement data ingestion routines from online system into database using best practices in data modeling, ETL/ELT processes on AWS Glu/Lambda in collaboration with engineering team.
• Design and develop on-line reporting business intelligence tools using Tableau dashboard and/or LLM agents by writing complex SQL queries to retrieve appropriate data. Use available tools (Snowflake, Python, Tableau, Agent etc.) to construct, maintain, distribute and enhance BI data delivery.
• Contribute to data governance initiatives by adhering to data quality standards and best practices. Document data processes, definitions, and methodologies to ensure clarity and consistency.
• Build insights and create recommendations by identifying trends, patterns and insights for Supply chain stakeholders.
• Present insights and recommendation to stakeholders written and verbal communications that can be understood by a business and non-technical audience audience.
• Train and empower business stakeholders to acces and analyze data independently

What You’Ll Need:

• Bachelor's degree in Computer Science, Business Analytics, Engineering, Mathematics, Data Analytics, Information System, Operations Management or related field and 3 years of experience.
• Will also accept a Master’s degree and 1 year of experience.
• Experience must include 1 year data analytics role
• Application of analytic skills to integrate data into operational/business planning;
• Data visualization tools like Tableau Quicksights
• Knowledge of data management fundamentals and ETL principles.
• Experience or coursework must include: advanced knowledge of SQL and data modeling;
• Building automated data warehousing environments for production reports or tables;
• Redshift, Snowflake DWH’s and S3 or similar data lakes;
• Python or similar coding languages.
• Skills in statistical analysis and data science techniques is a plus

Does this sound like you? If so, we would love to hear from you! Come run with the Pack!

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 and benefits, 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. 

Exempt salary 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. 

Base Salary Range$113,000—$180,500 USD

Chewy is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, ancestry, national origin, gender, citizenship, marital status, religion, age, disability, gender identity, results of genetic testing, veteran status, as well as any other legally-protected characteristic. 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.

To access Chewy's Customer Privacy Policy, please click here.  

To access Chewy's California CPRA Job Applicant Privacy Policy, please click here.