Business Intelligence Analyst II

Chewy • Clayton, IN

1d

About The Position

The Business Intelligence Analyst II independently owns operational reporting and analytics for defined Core Fulfillment domains, helping leaders and operators understand performance, investigate issues, and improve the customer experience. The role covers advanced SQL analysis, dashboard and data-product development, recurring reporting, data quality, and operational deep dives. The analyst manages workstreams from requirements through delivery, adoption, and maintenance, including projects where requirements may be ambiguous. They translate operational needs into trusted metrics, actionable insights, and practical recommendations, and support ongoing improvement by building reusable frameworks, reviewing analytical work, and mentoring less experienced analysts.

Requirements

• Bachelor's 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.
• 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.

Nice To Haves

• 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.

Responsibilities

• 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 using multiple sources to 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.
• Analyze 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 for intended decisions.
• Translate findings into clear data stories, visualizations, and recommendations; 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.

Benefits

• 401(k) and a new-hire and annual equity grant; C08+ positions may also be eligible for an annual bonus.
• Medical/Rx, vision, dental, life, disability, hospital indemnity, critical illness, and accident insurance.
• Parental leave, family services benefits, backup dependent care, flexible spending accounts, telemedicine, pet adoption reimbursement, and an employee assistance program.
• Discounts, including 10% off pet insurance and 20% off at Chewy.com.
• Unlimited PTO for exempt salary team members, subject to manager approval.
• Six paid holidays per year.
• Paid sick and family leave may be available in compliance with applicable state and local regulations.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level