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.
Top Skills
What the Team is Saying
What We Do
We view pets and pet parents as family and are obsessed with meeting their needs and exceeding customer expectations through every interaction. Behind the scenes, our talented teams are made up of innovators, delighters, big-thinkers and of course, passionate pet people—creating a place where you'll be empowered to build, grow and unleash your fullest potential. We don’t just stand by our company mission—we’re obsessed with it. We seek to be the most trusted and convenient destination for pet parents and partners, everywhere. And we’re constantly finding new ways to do just that. At Chewy, we understand pet parenthood is full of joyful highs and anxious lows. That’s why we’re here, standing alongside pet parents, providing everything their pets need for a happy, healthy life. We’re a leading online source for pet products, supplies, and prescriptions. We offer a broad selection of high-quality products and services at competitive prices with an exceptional level of customer care and a personal touch. Since launching in 2011, we’ve combined the personalized service of your neighborhood pet store with the convenience and speed of e-commerce. We pride ourselves on being the only brand available 24/7/365 to support pet parents throughout their journey. We have a rich history of being recognized for our deep care and personalization while going above and beyond for our customers and their pets. We view pets and their people as more than just customers and look forward to meeting their needs and exceeding expectations through every interaction. With Chewy, no one pet-parents alone. Our culture is for those who thrive on delivering results and becoming your best—no matter your role or location. At Chewy, our Operating Principles serve as a common language, or framework, that connects two of Chewy's most valuable elements—our people and our culture. The Operating Principles guide our character, capabilities, imagination, and methods for execution in support of our company's mission.
Why Work With Us
We're proud to be one of the fastest growing e-commerce companies of all time. With growth comes the exciting opportunity to be a part of a world-class organization of engineering, product, and design team members, responsible for driving our latest innovations and designing "out-of-the Chewy box" experiences.
Gallery
Chewy Teams
Chewy Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
