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 III (C06) 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 [email protected].
To access Chewy's California CPRA Job Applicant Privacy Policy, please click here.
Skills Required
- Bachelor's degree in Computer Science, Engineering, Information Systems, Analytics, or a related field
- 5+ years of experience in Business Intelligence, Analytics Engineering, or Data Engineering roles
- Strong SQL proficiency
- Experience building governed BI solutions with Tableau or comparable tools
- Experience writing and reviewing version-controlled code in Git
What the Team is Saying
What We Do
Who We Are Chewy is where pet parents find everything they need for life with pets, from food to fun to pharmacy. We make pet care easier, more informed, and more joyful through fast, reliable delivery and award-winning 24/7 Customer Care, including access to pet health support when it’s needed. Founded in 2011, Chewy combines the convenience of online shopping with a high-touch, personalized experience built around the real moments of pet parenthood. Our Mission Chewy’s mission is to be the most trusted and convenient destination for pet parents and partners, everywhere. What We Do We support pet parents through the highs, lows, and everyday moments of the pet parenting journey with: • Pet food, treats, and daily essentials • Supplies for dogs, cats, fish, birds, reptiles, equine, and small pets • Pharmacy and veterinary services, including prescriptions and medications • Pet wellness and health products • Autoship for convenient recurring deliveries • Chewy+, our premium membership offering exclusive savings, faster delivery, and personalized pet care benefits • 24/7/365 customer support from knowledgeable, pet-loving experts What Makes Chewy Different Chewy is known for industry-leading service, deep personalization, and our customer-obsessed culture. We combine trust, convenience, and care, and pet parents come to us for: • Exceptional customer care • Human- and pet-centered product and experience design • Fast, dependable fulfillment across a nationwide operations network • A mission-driven culture built on empathy, trust, and passion for pets Our Culture Chewy’s culture is built for people who thrive on ownership, innovation, and impact. We value curiosity, creativity, and continuous improvement across all our teams. We empower Team Members—our Chewtopians—to learn, grow, and unleash their full potential in a collaborative, supportive, mission-driven environment. How We Work Chewy’s Operating Principles guide how we think, innovate, collaborate, and execute. These principles shape our character, decision-making, and approach to delivering results while connecting our people and culture in support of our mission. Where We Work Chewy headquarters: Plantation, FL, and Boston, MA Additional hubs: Bellevue, WA, and Minneapolis, MN
Why Work With Us
Why You Should Work at Chewy Chewy is a unique, fast-growing e-commerce and tech leader where builders, creators, and problem-solvers shape the future of pet care. Our teams drive innovation in a mission-driven culture that creates real impact for pets and the people who love them.
Gallery
Chewy Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
