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

Job Description:

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

Chewys Procurement Real Estate & Facilities (PREF) Analytics team is seeking a Business Intelligence Engineer to develop scalable analytics solutions that improve procurement 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 wed love to hear from you.

What Youll 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.

What Youll Need

• Bachelors 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 candidates relevant experience education and work 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 .

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.

Chewy is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race color ancestry national origin gender citizenship marital status religion age disability gender identity results of genetic testing veteran status as well as any other legally-protected characteristic. 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 .

To access Chewys California CPRA Job Applicant Privacy Policy please click here.