Business Intelligence Engineer II

In this role, you’ll own analytics solutions from business requirements through deployment and adoption. You’ll combine strong SQL and Python skills with modern visualization tools and AI-assisted workflows to build trusted data products, automate reporting, and make insights more accessible. You’ll also help stakeholders understand what drives customer contacts, service performance, and customer satisfaction - and identify opportunities to improve them.

This role is ideal for someone who brings technical depth, sound analytical judgment, and curiosity about applying AI to everyday business problems.

What You’ll Do

• Own analytics solutions end to end. Translate business questions into clear requirements, define success measures, and independently deliver reliable datasets, dashboards, and analytical tools.
• Build trusted data foundations. Write and optimize complex SQL queries, develop reusable data models, and use Python to extract, clean, integrate, and analyze data from multiple sources.
• Develop scalable reporting and monitoring. Work with batch and streaming data, where appropriate, to support timely reporting, anomaly detection, and operational alerts.
• Create intuitive analytics experiences. Build and maintain dashboards and applications using tools such as Tableau, Streamlit, and Plotly, helping users move from identifying an issue to understanding its drivers.
• Apply AI to improve analytics productivity. Use approved AI tools to accelerate SQL and Python development, exploratory analysis, documentation, and prototyping. Validate generated outputs for accuracy, efficiency, and alignment with business definitions.
• Turn unstructured feedback into measurable insights. Partner with relevant teams to apply AI-assisted classification, summarization, and text analysis to customer interactions, identifying emerging themes and validating findings against source data.
• Build and evaluate AI-enabled self-service tools. Contribute to experiences such as natural-language data exploration and automated insight summaries, grounded in governed data and clearly defined metrics.
• Measure business impact. Use statistical analysis, hypothesis testing, and appropriate evaluation methods to assess operational changes, automation, and AI-enabled Customer Care initiatives.
• Ensure quality, explainability, and responsible use. Implement data checks, investigate discrepancies, and communicate assumptions and limitations. Follow Chewy’s policies for privacy, security, and the use of customer data with AI tools
• Partner and communicate effectively. Work with business, operations, and technical stakeholders to prioritize needs and present clear findings and recommendations.
• Enable adoption and continuous improvement. Document data definitions and processes, train business users, contribute to peer reviews, and share reusable approaches that strengthen the team’s analytics practices.

• Bachelor’s degree in Computer Science, Statistics, Mathematics, Engineering, or a related field, or equivalentpractical experience.
• 3+ years of experience in business intelligence, data analytics, or a related role.
• Strong SQL skills, including complex joins, window functions, query optimization, and working with relationaldatabases.
• Proficiency in Python for data analysis and automation, including libraries such as pandas, matplotlib, or Plotly.
• Experience building dashboards or analytical applications using Tableau, Power BI, Streamlit, Plotly, or similartools.
• Experience with data modeling, ETL/ELT processes, data quality validation, and defining consistent businessmetrics.
• Working knowledge of statistics, hypothesis testing, and analytical methods, with the ability to distinguishcorrelation from causation.
• Familiarity with AI-assisted analytics or development workflows, including how to verify generated code andinsights and recognize unreliable outputs.
• Demonstrated ability to navigate ambiguous business questions and independently deliver solutions withmeasurable value.
• Strong communication and stakeholder partnership skills, including the ability to explain technical findings tonontechnical audiences.
• Experience using version control and maintaining documented, reproducible analytical work.

Bonus (Preferred Qualifications)

• Experience with cloud platforms and modern data warehouses, such as AWS, Azure, or GCP.
• Experience analyzing Customer Care, contact center, retail, or e-commerce data.
• Hands-on experience integrating large language models into analytical workflows through approved APIs orenterprise tools.
• Familiarity with grounding AI outputs in trusted data, evaluating response quality, and designing appropriatehuman review.
• Experience with text analytics, customer feedback classification, or analysis of conversation data.
• Exposure to streaming data, workflow orchestration, automated monitoring, or experimentation

The base salary range for this role is $102,500 - $189,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. 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 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.