Business Intelligence Engineer II

Our Opportunity:

Chewy is looking for a Business Intelligence Engineer II to join our Healthcare Analytics Team. In this role, you will drive analytics efforts for our CarePlus and Content businesses (PetMD and BeChewy). These are high-growth areas that rely on clickstream and customer behavior data to advise strategic decisions, improve features, support product launches, and new programs.

You will contribute to building scalable data infrastructure, develop self-serve analytics tools, and create intuitive data visualizations to uncover insights. You’ll partner directly with General Managers, Product Managers, IT Software and Data Engineers, and Business Analysts to understand ongoing needs and proactively build solutions that solve problems.

As part of a team that is constantly launching new businesses and features, you will be responsible for leveraging technical solutions to transform raw data from multiple sources into actionable insights.

The ideal candidate has experience working with clickstream and customer engagement data in a digital context and is comfortable building analytics tools and performing deep-dive analysis. Strong attention to detail, data visualization skills, and technical problem-solving abilities are important for success in this role. Excellent written and verbal communication skills are also required, as you will work cross-functionally to support tool rollouts, document data infrastructure changes, and contribute to analytical deliverables shared with business customers. Does this sound like you? If so, we would love to hear from you! Come run with the Pack!

What You’ll Do:

• Develop analytics frameworks and own analyses that quantify the impact of digital assets on key customer and financial indicators
• Partner with Product, Tech, and Business teams to assist in experiment design and generate insights from product launches and feature updates
• Help build and maintain analytics dashboards and reporting tools that are intuitive and effective for both internal and external users
• Design, develop, optimize, and maintain data architecture and pipelines that adhere to ETL principles and business goals.
• Proactively assess the data needs of Healthcare and related functions, and partner with technical teams to deliver proof of concepts, QA data sources, and deliver new data tables, metrics, and analytics products 
• Contribute to automation efforts for data integration, extraction, and distribution of reports to multiple customers
• Maintain and improve documentation for key metrics and contribute to data governance processes
• Document technical details of your work using Jira, Confluence, Git, etc.
• Monitor existing metrics, propose refinements, and collaborate across functions to help deliver data-driven insights

What you'll need:

• Demonstrable experience analyzing and delivering insights from clickstream data from sources such as Segment, Google Analytics, Adobe or comparable platform
• Understanding and experience with experiment design, A/B testing, and other frameworks for evaluating effectiveness of feature and product changes
• Demonstrable experience developing self-serve BI solutions and automated reports, including tools that enable defect alerting and data quality monitoring
• 4-year Bachelor’s degree in Computer Science, MIS, Business Analytics, Mathematics, Industrial Engineering or a related field
• 3+ years automating data processes, developing dashboards, and building scalable analytics solutions in an ecommerce, omni-channel, or retail setting (Tableau strongly preferred)
• 2+ years of experience managing ETL or data transformation processes, technical architecture documents, and delivering net new or enhancing existing data warehouses
• 3+ years of experience working with data platforms such as: Snowflake, AWS, Vertica, or comparable data pipelines
• Strong working knowledge of SQL and proven ability to write, debug, and optimize SQL queries
• Programming expertise in Python, Java, Scala, or another modern programming language
• Proven experience with data modeling in large, cloud-based Data warehousing / data lake environments (Snowflake strongly preferred)
• Strong written and verbal communication skills and experience leading change management processes
• Proven experience delivering high quality and insightful data visualizations and translating complex data into actionable insights
• Exemplary customer management and prioritization skills using systems, processes, and scalable frameworks
• Superior attention to detail and experience building processes to validate data integrity
• Proven experience leading teams and delivering results in ambiguous and resource constrained environments 
• Ability to travel up to 10% of the time

Bonus:

• Experience with statistical models and building predictive models from scratch
• Experience in gathering requirements and formulating business metrics for reporting
• Project Management Certification