Business Intelligence Engineer II

We are hiring awesome humans, and we hope that includes you!
Are you looking for more than just a job? At Chewy, you'll find yourself on a career path with other awesome humans, like yourself. You'll be part of a culture that values everything that you do, who you are, and the goals you have set for your career. We want to give you the opportunity to grow, earn competitive pay, and be happy while you do it. Sounds simple, but we love it.
Your Opportunity:
Chewy is looking for a BI Engineer to join our Merchandise Analytics team in Boston or Seattle. This role requires a strong foundation in data analysis and visualization, with a particular emphasis on building rich, interactive dashboards and reports using Python visualization libraries such as Plotly, Dash, or Streamlit. This team plays a vital role in many different aspects of the overall business performance. In addition to providing full-service reporting solutions for numerous cross functional stakeholders, Merchandise Analytics also provides deep dive analyses for key functional areas such as Assortment, Promotion, Customer Behavior, Autoship, Vendor Experience, and Data Science.
In this role, you will work alongside smart, passionate teammates with an entrepreneurial mindset and be involved in many aspects of building the business. If you are equally as passionate about data optimization, report generation, stakeholder engagement, general e-commerce operations, and career growth, an opportunity at Chewy may be a great match!
What You'll Do:

• Design, develop, and maintain interactive data visualizations and dashboards using Python-based tools (e.g., Dash, Plotly).
• Build scalable data pipelines and models to support BI solutions.
• Partner with Category Management teams to gather requirements and transform business questions into data-driven insights.

• Analyze demand and resource requirements against available resources to identify risks and opportunities and provide recommendations to solve for resource constraints

• Automate reporting processes to improve accessibility and usability of key metrics.
• Perform data extraction, transformation, and loading (ETL) from diverse data sources
• Validate data integrity and ensure consistency across reports and dashboards.
• Continuously optimize and refactor BI solutions for performance and maintainability.
• Stay up to date with trends in data visualization and BI technologies.

• Respond to high priority requests from senior business leaders

What You'll Need:

• BS/BA in Business Administration, Finance, Computer Science, Statistics, Information Management, Data Science or related field.

• 3+ years of experience in BI, data analytics, or a similar role.
• Proficiency in Python, with strong experience in visualization libraries (Plotly, Dash, etc...).
• Strong SQL skills and experience with relational databases.
• Familiarity with data modeling concepts and ETL processes.
• Solid understanding of data visualization best practices and user-centric design.

• Knowledge of data warehousing and experience with data transformation processes
• Look at solutions and see opportunities and can lead the way.
• Convey important insights from complex analysis in summarized business terms

Bonus (if applicable):

• Masters in Analytics, or equivalent advanced academic degree
• Experience working within Snowflake and Tableau
• Additional technical/programming experience including Java, Scala, DBT, or ChatGPT
• Data modeling experience in Retail/E-commerce

What You'll Get:

• A place where you can be your authentic self and grow your career. Our pet parents and partners are from everywhere--different places and different walks of life. It is what makes them unique. Likewise, Chewtopians are encouraged to bring their perspectives to deliver on our mission!

• Work in a culture that cares, with managers who value you and your career journey. Be empowered to think big, thrive on delivering results, and to become your best.

• Development of meaningful connections with a diverse group of Chewtopians through Team Member Resource Groups and celebrate inclusivity with various company events, programs, and activities.
• Comprehensive medical, dental, vision benefits, in addition to wellness programs and resources, enabling you to be your best self in and outside of work.

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 committed to equal opportunity. We value and embrace diversity and inclusion of all Team Members. 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.
If you have a question regarding your application, please contact HR@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.