Business Intelligence Engineer II

Chewy•Bellevue, WA

2d•$148,000 - $180,500•Onsite

About The Position

This role is for a Business Intelligence Engineer II in Bellevue, WA, within the AI and Data Innovation team. The position is full-time. The engineer will be responsible for designing, developing, and maintaining metrics, reports, analyses, and dashboards to support key decisions and process improvements. They will collaborate closely with Supply Chain teams on areas such as forecasting analytics, inventory placement, customer experience, and replenishment management, aiming to optimize customer experience and in-stock positions. The role involves analyzing demand and resource requirements, identifying risks and opportunities, and recommending solutions for resource constraints. The engineer will also interface with other technology teams to extract, transform, and load data from various sources using SQL and other platforms. Key responsibilities include adopting best practices in reporting and analysis, responding to high-priority requests from senior business leaders, and improving reporting processes through automation and self-service support.

Requirements

Bachelor’s degree in Business Analytics, Supply Chain, Information Management, Data Science, or related field of study and 3 years of experience required as a Business Intelligence Analysts or a related position/occupation.
Master’s degree in Business Analytics, Supply Chain, Information Management, Data Science, or related field of study and 1 year of experience required as a Business Intelligence Analysts or a related position/occupation.
SQL and data modeling within large-scale data warehouse or data lake environments.
Building automated data warehousing environments for production reports or tables.
Python and data visualization tools such as Streamlit/FastAPI/Plotly/Dash/React/D3Js etc.
Data visualization tools like Power BI, Tableau, Looker, Quicksight or similar.
Ability to draw insights from data and clearly communicate them to the stakeholders and senior management as required.
Data management fundamentals, storage principles, and developing scalable data transformation pipelines using dbt (data build tool) including modular SQL modeling, testing, and documentation.
Building AI-powered tools such as chatbots or AI agents to support data access, reporting, or automation.

Responsibilities

Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key decisions and process improvements.
Work closely with the Supply Chain teams in areas including forecasting analytics and design, inventory placement, customer experience and replenishment management continuously optimizing for improved customer experience and in-stock positions.
Analyze demand and resource requirements against available resources to identify risks and opportunities and provide recommendations to solve for resource constraints.
Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL and various technological platforms.
Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.
Respond to high priority requests from senior business leaders.
Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for secondary data sets.

Benefits

401k
new hire and annual equity grant
annual bonus (for C08+ positions)
medical/Rx insurance
vision insurance
dental insurance
life insurance
disability insurance
hospital indemnity insurance
critical illness insurance
accident insurance
parental leave
family services benefits
backup dependent care
flexible spending accounts
telemedicine
pet adoption reimbursement
employee assistance program
10% off pet insurance discount
20% off at Chewy.com discount
unlimited PTO (subject to manager approval for exempt salary team members)
six paid holidays
paid sick and family leave (in compliance with applicable state and local regulations)