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

Posted Yesterday
Be an Early Applicant
Bellevue, WA, USA
Hybrid
Mid level
eCommerce • Healthtech • Pet • Retail • Pharmaceutical
At Chewy, our mission is to be the most trusted and convenient destination for pet parents and partners, everywhere.
The Role
Build scalable BI solutions for Procurement, Real Estate & Facilities: design data models, ETL/ELT pipelines, automated reporting, dashboards, forecasting, and analytics to support sourcing, supplier performance, and operational decisions.
Summary Generated by Built In
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. 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.
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.

What You'll Need
  • 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.

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.
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 [email protected].
To access Chewy's California CPRA Job Applicant Privacy Policy, please click here.

Skills Required

  • Bachelor's degree in Computer Science, Information Systems, Analytics, Data Science, Engineering, or related field (or equivalent experience)
  • 4+ years of experience building enterprise BI solutions, analytical applications, or data models
  • Expert SQL skills; 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
  • 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
  • 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

What the Team is Saying

Amy
Olivia
Mark
Joyce
Michael
Sumit
Victoria Kenney
Crystal

Chewy Compensation & Benefits Highlights

How does Chewy ensure its pay and bonus plans are competitive?

Chewy approaches compensation through a total rewards strategy that combines salary, bonuses, equity opportunities, healthcare benefits, employee discounts, and career growth opportunities. The company emphasizes supporting employees across ecommerce, healthcare, pharmacy, customer service, technology, and fulfillment operations while competing for talent in both retail and tech markets.

Competitive compensation and bonus opportunities: Chewy offers market-based compensation packages that may include salary, performance bonuses, commissions, and equity depending on role and level. Built In also notes benefits such as relocation assistance, employee discounts, and bonus opportunities across multiple teams and functions. 

  • Healthcare and wellness support: Benefits include medical, dental, vision, prescription coverage, HSA/FSA options, life insurance, disability coverage, telemedicine, mental health resources, and wellbeing programs. Chewy also offers wellness-focused resources designed to support employees physically, mentally, and financially.
  • Retirement and financial wellbeing: Employees receive 401(k) plans with company matching along with financial wellness resources and broader support programs. Benefits are designed to support both short-term needs and long-term financial planning.
  • Pet-focused and family-oriented benefits: Chewy offers pet insurance discounts, employee discounts on Chewy products, parental leave, fertility support, family-focused benefits, and caregiving resources. The company’s benefits package is closely aligned with its pet-focused identity and customer mission.
  • Flexibility and workplace support: Corporate employees may have access to hybrid work arrangements, flexible scheduling, commuter benefits, PTO, paid holidays, and wellbeing initiatives. Employees also cite supportive managers and collaborative teams as important parts of the broader employee value proposition.
  • Long-term career investment: Compensation is reinforced through career growth opportunities, mentorship, leadership development, cross-functional learning, and exposure to large-scale ecommerce, automation, healthcare, and logistics initiatives. Employees often describe growth opportunities as an important part of the overall company experience.
  • External signals: Comparably reports that 70% of employee reviews are positive overall. Employees frequently highlight healthcare benefits, employee discounts, coworkers, and growth opportunities as strengths of the company experience. (Glassdoor; Comparably) 

 

Chewy Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Boston, MA
17,800 Employees
Year Founded: 2011

What We Do

Who We Are Chewy is where pet parents find everything they need for life with pets, from food to fun to pharmacy. We make pet care easier, more informed, and more joyful through fast, reliable delivery and award-winning 24/7 Customer Care, including access to pet health support when it’s needed. Founded in 2011, Chewy combines the convenience of online shopping with a high-touch, personalized experience built around the real moments of pet parenthood. Our Mission Chewy’s mission is to be the most trusted and convenient destination for pet parents and partners, everywhere. What We Do We support pet parents through the highs, lows, and everyday moments of the pet parenting journey with: • Pet food, treats, and daily essentials • Supplies for dogs, cats, fish, birds, reptiles, equine, and small pets • Pharmacy and veterinary services, including prescriptions and medications • Pet wellness and health products • Autoship for convenient recurring deliveries • Chewy+, our premium membership offering exclusive savings, faster delivery, and personalized pet care benefits • 24/7/365 customer support from knowledgeable, pet-loving experts What Makes Chewy Different Chewy is known for industry-leading service, deep personalization, and our customer-obsessed culture. We combine trust, convenience, and care, and pet parents come to us for: • Exceptional customer care • Human- and pet-centered product and experience design • Fast, dependable fulfillment across a nationwide operations network • A mission-driven culture built on empathy, trust, and passion for pets Our Culture Chewy’s culture is built for people who thrive on ownership, innovation, and impact. We value curiosity, creativity, and continuous improvement across all our teams. We empower Team Members—our Chewtopians—to learn, grow, and unleash their full potential in a collaborative, supportive, mission-driven environment. How We Work Chewy’s Operating Principles guide how we think, innovate, collaborate, and execute. These principles shape our character, decision-making, and approach to delivering results while connecting our people and culture in support of our mission. Where We Work Chewy headquarters: Plantation, FL, and Boston, MA Additional hubs: Bellevue, WA, and Minneapolis, MN

Why Work With Us

Why You Should Work at Chewy Chewy is a unique, fast-growing e-commerce and tech leader where builders, creators, and problem-solvers shape the future of pet care. Our teams drive innovation in a mission-driven culture that creates real impact for pets and the people who love them.

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Chewy Teams

Team
Product + Technology
Team
Veterinary
Team
Operations
Team
Customer Care
About our Teams

Chewy Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Typical time on-site: Not Specified
HQBoston, MA
HQPlantation, FL
Bellevue, WA
Dallas, TX
Minneapolis, MN
Learn more

Similar Jobs

Chewy Logo Chewy

Director, Product Design

eCommerce • Healthtech • Pet • Retail • Pharmaceutical
Hybrid
Bellevue, WA, USA
17800 Employees
205K-300K Annually

Chewy Logo Chewy

Associate Director, Healthcare Customer Care Operations

eCommerce • Healthtech • Pet • Retail • Pharmaceutical
Hybrid
Bellevue, WA, USA
17800 Employees
138K-245K Annually

Chewy Logo Chewy

Software Engineer

eCommerce • Healthtech • Pet • Retail • Pharmaceutical
Hybrid
Bellevue, WA, USA
17800 Employees
141K-225K Annually

Chewy Logo Chewy

Instock Manager

eCommerce • Healthtech • Pet • Retail • Pharmaceutical
Hybrid
Bellevue, WA, USA
17800 Employees
96K-153K Annually

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account