Business Intelligence Engineer II, Procurement, Real Estate & Facilities Analytics

Chewy’s Procurement, Real Estate & Facilities (PREF) Analytics team is seeking a Business Intelligence Engineer to develop scalable analytics solutions that improve procurement decision-making. In this role, you will partner with Category Managers, Finance, Supply Chain, and Operations to build reporting, automate analytics, and deliver insights that support sourcing strategies, supplier performance, and operational excellence.

You will combine strong technical expertise with business acumen to transform complex data into actionable recommendations that enable better business decisions. If you enjoy building end-to-end analytics solutions, solving complex business problems with data, and creating scalable BI products, we’d love to hear from you.

What You’ll Do

• Design, develop, test, document, and maintain scalable data models, dashboards, reports, and self-service BI solutions supporting Procurement analytics.
• Build automated reporting frameworks that improve visibility into spend, supplier performance, savings, compliance, and operational KPIs.
• Develop forecasting models, scenario analyses, and analytical tools that support sourcing strategies and category planning.
• Translate complex analytical findings into clear, actionable recommendations for business partners and leadership.
• Develop and maintain ETL/ELT pipelines using modern data engineering guidelines.
• Build scalable SQL and Python solutions to automate reporting processes and improve data quality.
• Integrate data from multiple internal and external sources into governed analytical datasets.
• Gather business requirements and translate them into scalable BI products and reporting solutions.
• Support strategic sourcing initiatives through analytical modeling, reporting, and business insights.
• Collaborate with Finance, Operations, and Supply Chain to validate assumptions, resolve data issues, and support planning activities.
• Design dashboards and reporting structures that improve operational visibility across Procurement.
• Recommend process improvements that increase reporting efficiency, automation, and data quality.
• Produce clear documentation for datasets, dashboards, and analytical processes.

• Bachelor’s degree in Computer Science, Information Systems, Analytics, Data Science, Engineering, or a related field, or equivalent practical experience.
• 4+ years of experience building enterprise BI solutions, analytical applications, or data models.
• Expert SQL skills with experience designing and optimizing complex queries and datasets.
• Advanced Python skills (Pandas, NumPy, SciPy, Statsmodels, or similar).
• Experience building Tableau dashboards and self-service reporting solutions.
• Experience developing ETL/ELT pipelines in enterprise data warehouse or cloud environments.
• Strong understanding of dimensional modeling, data governance, and data quality guidelines.
• Experience independently managing analytics projects from requirements gathering through delivery.
• Experience automating reporting and analytical workflows using SQL and Python.
• Strong analytical, problem-solving, and communication skills.
• Experience translating business requirements into scalable technical solutions.

Bonus

• Experience supporting Procurement, Strategic Sourcing, Supply Chain, or Category Management organizations.
• Experience building forecasting, optimization, or predictive analytical models.
• Experience with dbt and modern analytics engineering practices.
• Experience with AWS technologies such as Airflow, Athena, S3 or QuickSight.
• Experience with Hadoop, Hive, Spark, or other distributed data technologies.
• Experience using Git or other version control systems.
• Comfortable working in a pet-friendly environment.

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

Pulled from the full job description Pet insurance Parental leave 401(k) Health insurance Vision insurance Dental insurance Family leave, 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.

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 pet lovers who are dedicated to us!