Business Intelligence Engineer II

Job Description:

Chewy Pharmacy Operations relies on timely trusted data to deliver safe efficient and world-class customer experiences across Vet Services and Rx Fulfillment teams. We are looking for a Business Intelligence Engineer II (C05) to help build scalable data foundations and deliver clear analytics reporting and visualizations that help operators understand performance and take action.

This role blends hands-on data model development repeatable reporting dashboard creation and deep-dive analysis in partnership with Operations Operations Support Data Science Analytics and Technology teams. The BIE II will own analytics solutions within defined Pharmacy Operations domains contribute to larger data initiatives and help translate operational questions into trusted scalable reporting and insights that support better decision-making.

What Youll Do

• Build and maintain complex multi-domain data models for Chewy Pharmacy Operations integrating data across Call Center Fulfillment and Operations datasets into trusted scalable structures that support analytics operational insights and downstream reporting.
• Develop reliable transformation logic using SQL and modern data tooling such as Snowflake dbt Airflow and related ETL/ELT frameworks with attention to accuracy performance reusability lineage and downstream consumption.
• Create curated datasets semantic layers and reusable data assets that standardize business logic improve metric consistency and enable teams to answer recurring and emerging operational questions.
• Partner with Operations Operations Support Data Science Analytics and Technology teams to understand workflows clarify business requirements evaluate source-system logic and translate operational needs into well-designed data solutions.
• Define and maintain clear metric definitions documentation validation logic and data quality checks to improve trust consistency and long-term maintainability across Pharmacy analytics products.
• Perform deep-dive analysis using large and complex datasets to explain performance trends identify root causes quantify impact and recommend actions that improve operational outcomes.
• Support reporting and visualization needs through tools such as Tableau or comparable BI platforms by ensuring business users have access to reliable well-modeled and clearly documented data foundations.

What Youll Need

• Bachelors degree in Computer Science Engineering Information Systems Analytics Mathematics Statistics Business or a related field or equivalent practical experience.
• 3 years of experience in Business Intelligence Analytics Engineering Data Analytics or related roles building data models curated datasets dashboards and analytics solutions for business or operations teams.
• Strong SQL proficiency including complex joins data transformation logic query optimization troubleshooting data issues and building reliable data models in Snowflake or a comparable cloud data warehouse.
• Experience working with large multi-source datasets and developing trusted reusable data assets that create a consistent view of business performance across domains such as Call Center Fulfillment Operations or similar operational datasets.
• Working knowledge of data warehouse concepts and data modeling practices including curated datasets data marts semantic layers metric definitions and downstream BI consumption patterns.

• Experience with modern data transformation and orchestration tools such as dbt Airflow or comparable ETL/ELT tooling including documentation validation testing and maintainability practices.
• Experience building reporting or visualization products in Tableau or comparable BI tools with a focus on enabling business users through reliable well-modeled data foundations.
• Ability to partner with Operations Analytics Data Science Technology and other stakeholders to clarify requirements understand source-system logic and translate operational needs into practical scalable data solutions.
• Strong analytical judgment with the ability to investigate complex data identify patterns and trends explain performance drivers and translate findings into actionable recommendations.
• Self-starter mindset with the ability to manage assigned work navigate problems of diverse scope ask good questions and collaborate effectively with peers managers and cross-functional partners.

Bonus

• Familiarity with dbt concepts and best practices or experience contributing to governed SQL transformation frameworks.
• Experience supporting data quality checks monitoring or alerting for important reporting datasets.
• Python experience for analysis automation or data validation.
• Experience in operations healthcare pharmacy fulfillment contact center supply chain or other process-heavy environments.

Chewy is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race color ancestry national origin gender citizenship marital status religion age disability gender identity results of genetic testing veteran status as well as any other legally-protected characteristic. 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 .

To access Chewys California CPRA Job Applicant Privacy Policy please click here.