Business Intelligence Engineer II
About The Position
Chewy, Inc. is seeking a Business Intelligence Engineer II in Boston, MA. This full-time role is part of the Marketing Operations team. The position involves developing and implementing analytical frameworks to measure the impact of digital assets on customer behavior, operational performance, and financial outcomes. Responsibilities include supporting experiment design, analyzing results from product launches and feature enhancements, and translating findings into actionable insights. The role also requires designing, building, and maintaining scalable analytics dashboards and reporting solutions, as well as designing, developing, optimizing, and maintaining data architectures and data pipelines using SQL. The engineer will assess data requirements for Healthcare and related business functions, collaborate with technical teams, perform data quality validation, and develop new data tables, metrics, and analytical products. Automation of data ingestion, transformation, and distribution of recurring reports and datasets is also a key aspect, along with maintaining documentation and participating in data governance processes. Technical documentation using tools like Jira, Confluence, and Git, monitoring metrics, proposing refinements, and collaborating cross-functionally to deliver data-driven insights are also expected. The role requires 5% domestic travel and permits telecommuting up to 2 days per week.
Requirements
- Bachelors degree in Data Analytics, Computer Science, Management Information Systems, Engineering, or related field, and 5 years of experience as a Business Intelligence Analyst, or related position/occupation.
- Automating data processes, developing dashboards, and building scalable analytics solutions in an ecommerce, omni-channel, or retail setting.
- Managing ETL or data transformation processes, technical architecture documents, and deliver net new or enhancing existing data warehouses.
- Experience with data platforms such as: Snowflake, AWS, Vertica, or comparable data pipelines.
- SQL.
- Writing, debugging, and optimizing SQL queries.
- Data modeling in large, cloud-based data warehousing/data lake environments.
Nice To Haves
- Masters in Data Analytics, Computer Science, Management Information Systems, Engineering, or related field, and 2 years of experience as a Business Intelligence Analyst, or related position/occupation.
Responsibilities
- Develop and implement analytical frameworks to measure the impact of digital assets on customer behavior, operational performance, and financial outcomes.
- Support experiment design, analyze results from product launches and feature enhancements, and translate findings into actionable insights.
- Design, build, and maintain scalable analytics dashboards and reporting solutions that provide accurate, timely, and intuitive insights for internal and external stakeholders.
- Design, develop, optimize, and maintain data architectures and data pipelines using SQL to support analytical and reporting needs in alignment with business requirements and data engineering best practices.
- Assess data requirements for Healthcare and related business functions, collaborate with technical teams to deliver proof-of-concept analyses, perform data quality validation, and develop new data tables, metrics, and analytical products.
- Contribute to automation initiatives for data ingestion, transformation, and distribution of recurring reports and datasets to multiple stakeholder groups.
- Maintain and enhance documentation for key metrics and datasets, and participate in data governance and quality assurance processes.
- Document technical designs and analytical work using tools such as Jira, Confluence, and Git.
- Monitor existing metrics and report outputs, propose refinements and optimizations.
- Collaborate cross-functionally to deliver data-driven insights that support business decision-making.
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
- 20% off at Chewy.com
- 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)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
