Business Intelligence Engineer II

About the Role
Chewy is hiring! We are seeking a Business Intelligence Engineer II to join our People Analytics team within HR. This role will focus on building scalable data solutions, developing insightful visualizations, and performing statistical analyses to support workforce decision-making. The ideal candidate is a data-driven problem solver with strong SQL and Python skills and experience independently leading analytics projects Does this sound like you?
Key Responsibilities

• Design, develop, and maintain scalable BI solutions to support HR and People Analytics initiatives.
• Build interactive data visualizations to drive insights and decision-making, preferably within Tableau.
• Leverage Generative BI tools such as Amazon QuickSight to automate data insights.
• Write and optimize complex SQL queries for ETL processes, data validation, and analytics.
• Develop and automate Python scripts for data processing, analysis, and reporting.
• Conduct statistical analyses and build models to uncover workforce trends and opportunities.
• Partner with HR collaborators to define critical metrics, reporting frameworks, and data-driven insights.
• Ensure data accuracy, consistency, and governance across HR data sources.
• Optimize and streamline data pipelines, collaborating with data engineers to enhance ETL processes.
• Support self-service analytics by developing scalable datasets and BI assets.
• Work with work management tools such as JIRA, code repositories such as Git, and documentation platforms such as Confluence or Alation.
• Lead projects independently, handling partners and getting results.

Qualifications Required:

• 3+ years validated experience in BI, analytics, or data engineering roles.
• Strong expertise in SQL (window functions, CTEs, performance tuning).
• Experience with Python for data automation, transformation, and analysis.
• Proficiency in data visualization tools (preferably Tableau).
• Ability to perform statistical analysis and interpret data trends.
• Experience with JIRA, Git, and documentation tools such as Confluence or Alation.
• Shown ability to lead projects independently and work multi-functionally.
• Willingness to mentor and coach junior Team Members.

Preferred:

• Experience with Generative BI tools such as Amazon QuickSight.
• Familiarity with AWS services (S3, Redshift, Athena, etc.).
• Knowledge of Airflow for workflow automation.
• Experience with DBT for data transformation.
• Background in HR analytics or working with people data.

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.
We offer different types of insurance, 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.
Salaried-exempt 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.
Pay Range
$115,500-$183,500 USD
Chewy is committed to equal opportunity. We value and embrace diversity and inclusion of all Team Members. 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 CAAR@chewy.com.
If you have a question regarding your application, please contact HR@chewy.com.
To access Chewy's Customer Privacy Policy, please click here. To access Chewy's California CPRA Job Applicant Privacy Policy, please click here.