Business Intelligence Analyst II

Job Description:

Our Opportunity

Chewy Operations Teams relies on trusted metrics reporting and analysis to manage performance across a large and complex fulfillment network. We are looking for a Business Intelligence Analyst II to independently own operational reporting and analytics that help leaders and operators understand results investigate issues and improve the customer experience.

This role combines advanced SQL analysis dashboard and data-product development recurring reporting data quality leadership and operational deep dives. The BIA II will own analytical workstreams within defined fulfillment domains navigate questions whose requirements are not always clear and translate operational needs into trusted metrics actionable insights and practical recommendations.

What Youll Do

• Independently own operational metrics dashboards recurring reports and analytical workstreams for defined Core Fulfillment domains from requirements through delivery adoption and ongoing maintenance.
• Develop advanced SQL queries analysis-ready datasets and repeatable analytical workflows that combine multiple sources and support operational reviews investigations and improvement initiatives.
• Monitor and reconcile reporting data across systems investigate anomalies and lead quality control and testing for important metrics dashboards and analytical deliverables.
• Perform deep-dive analysis using large and complex datasets apply appropriate statistical methods identify root causes and performance drivers quantify opportunities and recommend actions.
• Partner with Operations Operations Support Analytics Data Science and Technology teams to resolve ambiguous requirements document business logic and design analytical solutions that address the intended decision.
• Translate findings into clear data stories visualizations and recommendations then work with stakeholders to apply the analytical approach and measure results.
• Create reusable frameworks and team practices review analytical work and mentor less experienced analysts in SQL visualization validation documentation and stakeholder communication.

What Youll Need

• Bachelors degree in Analytics Business Economics Engineering Information Systems Mathematics Statistics Supply Chain or a related field or equivalent practical experience.
• 2 to 4 years of relevant full-time experience in business intelligence data analytics operations analytics or a related role supporting a business or operations team.
• Advanced SQL proficiency including complex joins common table expressions window functions data transformation logic troubleshooting and performance-conscious query design.
• Solid understanding of data modeling and experience working with large multi-source datasets in Snowflake or a comparable data warehouse.
• Demonstrated experience building and maintaining dashboards or reporting products in Tableau Power BI or a comparable business intelligence platform.
• Working knowledge of ETL or ELT techniques and experience monitoring analytical data processes for accuracy completeness and unexpected change.
• Experience applying statistical techniques such as hypothesis testing correlation regression or time-series analysis to operational or business questions.
• Demonstrated ability to turn unclear operational questions into documented requirements analytical plans quality-controlled deliverables and decision-ready recommendations with limited direction.
• Experience using version control and work-management tools such as Git Jira and Confluence or comparable tools to document and manage analytical development
• Strong written and verbal communication project ownership and peer-development skills including the ability to review work constructively and mentor others.

Bonus

• Experience with fulfillment supply chain logistics retail operations or another large process-driven network.
• Familiarity with dbt or another governed SQL transformation framework.
• Python or R experience for analysis automation statistical modeling or data validation.

• Experience supporting operational experiments forecasting capacity planning labor planning or continuous improvement initiatives.

• The specific salary offered to a candidate may be influenced by a variety of factors including but not limited to the candidates relevant experience education and work addition this position is eligible for 401k and a new hire and annual equity grant. C08 positions may also be eligible for annual bonus.

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 .

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.

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 .

To access Chewys California CPRA Job Applicant Privacy Policy please click here.