The Business Intelligence Engineer II role involves designing scalable BI solutions, performing statistical analyses, and developing data visualizations to support HR decision-making.
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.
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.
Top Skills
Airflow
Amazon Quicksight
Confluence
Dbt
Git
JIRA
Python
SQL
Tableau
Similar Jobs at Chewy
eCommerce • Healthtech • Pet • Retail • Pharmaceutical
As a Staff Data Scientist, you will develop AI and ML models for marketing applications, conduct evaluations, and communicate findings to various stakeholders.
Top Skills:
Azure)Cloud Services (AwsDatabricksGCPLangchainLlamaindexMl FrameworksPython
eCommerce • Healthtech • Pet • Retail • Pharmaceutical
The Senior Merchandising Operations Analyst will oversee catalog data analysis, enable process improvements, mentor junior team members, and collaborate with technical teams for system enhancements.
Top Skills:
Atlassian ToolsErp SystemsMS OfficePythonRSQLTableau
eCommerce • Healthtech • Pet • Retail • Pharmaceutical
The Machine Learning Engineer II will develop and deploy machine learning models, conduct exploratory data analysis, and collaborate across teams to enhance product discovery for Chewy customers.
Top Skills:
AWSGoogle Cloud PlatformMachine LearningPyTorchTensorFlow
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
