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

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! Our Opportunity 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.

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