Business Intelligence Engineer II

Job Description:

Our Opportunity:

Chewy Pharmacy Operations relies on timely, trusted data to deliver safe, efficient, and world class customer experience across Vet Services and Rx Fulfillment teams. We are looking for a Business Intelligence Engineer II (C05) to build scalable data foundations and deliver clear analytics and visualizations that help operators understand performance and act. This role blends data pipeline ownership, building and maintaining repeatable reporting mechanisms, and deep-dive analysis in partnership with Operations, Operations Support, and Technology teams.

What You’ll Do:

• Design, develop, implement, test, document, and operate large-scale data models and BI solutions, including curated datasets, dashboards, and recurring reporting that support Pharmacy Operations.
• Build and maintain data ingestion and transformation routines (batch and, where needed, near real-time) using best practices in data modeling and ETL/ELT to ensure reliable, scalable pipelines.
• Deliver self-serve reporting and analysis through BI tools and well-structured semantic/abstraction layers that enable consistent metrics across multiple source systems.
• Gather business and functional requirements and translate them into robust, scalable, operable solutions that align with broader data architecture and downstream consumption patterns.
• Produce high-quality documentation, metadata, and clear metric definitions to improve trust, adoption, and long-term maintainability of Pharmacy Operations analytics products.
• Perform deep-dive analysis and root-cause investigations to explain performance trends, quantify impact, and recommend operational actions.
• Mentor and support other analysts by providing guidance on best practices, reviewing work for quality and consistency, and helping teammates strengthen skills in data modeling, visualization, and stakeholder communication.

What You’ll Need:

• Bachelor’s degree in Computer Science, Engineering, Information Systems, Analytics, or a related field, or equivalent practical experience.
• 5+ years of experience in Business Intelligence, Analytics Engineering, or Data Engineering roles delivering analytics solutions (for example dashboards, reporting, and curated datasets) for business teams.
• Proven experience designing and owning enterprise-grade data pipelines and data models spanning multiple business domains, including complex joins across multiple source systems, incremental processing, and handling late-arriving data.
• Strong SQL proficiency, including query optimization and building performant data models in a modern cloud data warehouse (Snowflake or equivalent).
• Solid knowledge of data warehouse concepts and methodologies, including dimensional modeling and designing curated data marts for downstream BI consumption.
• Experience building governed BI solutions and presenting insights clearly through visualizations (Tableau or comparable BI tool).
• Experience writing and reviewing version-controlled code (Git or equivalent) and following standards for documentation, testing/validation, and maintainability.
• Demonstrated ability to establish standards and influence best practices across an analytics team (for example code reviews, modeling conventions, metric governance), without requiring formal people management.
• Self-starter mindset with the ability to take initiative, drive ambiguous problems to clear solutions, and partner effectively across technical and business stakeholders.

Bonus

• Familiarity with dbt concepts and best practices, or experience migrating legacy SQL pipelines into a governed modeling framework.
• Experience implementing data quality monitoring, alerting, and incident response patterns for analytics datasets.
• Python for analysis and automation.

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 CAAR@chewy.com.

To access Chewy's California CPRA Job Applicant Privacy Policy, please click here.