Chewy

Business Intelligence Engineer II

Chewy$95K — $115K *
Healthcare
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science, Engineering, Information Systems, Analytics, or related field, or equivalent experience.
  • 5+ years in Business Intelligence, Analytics Engineering, or Data Engineering roles delivering analytics solutions.
  • Proven experience designing and owning enterprise-grade data pipelines and models across multiple domains.
  • Strong SQL skills for optimizing queries and building data models in modern cloud data warehouses (e.g., Snowflake).
  • Knowledge of data warehouse concepts, dimensional modeling, and designing curated data marts for BI consumption.
  • Experience with BI tools for presenting insights through visualizations (e.g., Tableau).
  • Ability to set standards and influence best practices across analytics teams.

Responsibilities

  • Design, develop, and operate scalable data models and BI solutions for Pharmacy Operations.
  • Build and maintain data ingestion and transformation routines using best practices.
  • Deliver self-serve reporting through BI tools and well-structured data layers.
  • Gather business and functional requirements for scalable, operable solutions.
  • Produce high-quality documentation and metric definitions to enhance analytics product trust.
  • Perform deep-dive analysis to explain performance trends and recommend actions.
  • Mentor and support analysts in data modeling, visualization, and stakeholder communication.

Benefits

  • Opportunity to work with innovative data solutions in a rapidly growing field.
  • Collaboration with cross-functional teams to drive impactful analytics initiatives.
  • Access to professional development and mentorship opportunities.
  • Participation in a dynamic, fast-paced work environment focused on operational excellence.
Full Job Description
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.


About Chewy

At Chewy, we view pets (and pet parents) as family and are obsessed with meeting their needs and exceeding customer expectations through every interaction. Customers love shopping our wide selection of products including more than 65,000 items (including our Private brands and Healthcare products), which we offer at competitive prices and fast 1-2 day shipping. Chewy’s commitment to customer service is the core of our brand, and our customers love us for it. We “WOW” pet parents through 24/7 assistance, advice and encouragement every day of the year. We make pet parenting easy with our convenient Autoship subscription program—which allows our customers to schedule their orders, so they never run out of their pet food, supplies and medication they need. Chewy is an experience company built on the back of product and technology. Innovation drives our operations and our team is constantly striving to find new and better ways to improve. From an easy-to-navigate website and highly-rated mobile apps, to detailed order tracking and personalized “Pet Profile” features, we are transforming the way pet parents shop.

Chewy Careers

Join the vibrant team at Chewy, where we offer exceptional job opportunities to advance your career in the dynamic world of e-commerce. As a leading company in the pet industry, Chewy is dedicated to making pet care easier and more enjoyable for pet parents everywhere. Work You’ll Do At Chewy, we are constantly on the lookout for passionate, driven professionals to join our diverse team. Whether you're seeking a position in IT, customer service, marketing, or logistics, Chewy provides a platform for professional growth and innovation in every career path. Our commitment to leadership and diversity training ensures that every team member is equipped with the skills to lead and innovate. By joining Chewy, you will work alongside a team of dedicated professionals who are always pushing the boundaries of what's possible in e-commerce and customer service. Internship and Employment Opportunities Chewy offers a variety of internship and employment opportunities that cater to a wide range of skills and interests. Our internships provide invaluable hands-on experience, helping you to enhance your resume and prepare for a full-time position within our company. Chewy is not just about hiring employees; it's about nurturing future leaders. Benefits and Culture At Chewy, we believe that the well-being of our team is paramount. We offer a comprehensive benefits package that supports the health, financial security, and work-life balance of our employees. Our culture is centered on open communication, respect, and a shared passion for our mission. We celebrate diversity and are committed to creating an inclusive environment for all team members. Innovation and Growth Chewy is at the forefront of innovation in the pet industry. We are constantly exploring new technologies and strategies to enhance our services and expand our market reach. This focus on innovation drives our company's growth and offers our team members numerous opportunities to get involved in exciting projects and advance their careers. Networking and Professional Development We encourage our employees to engage in networking and professional development activities that can enhance their career prospects. Chewy supports various initiatives, including workshops, seminars, and training sessions, to help our team members grow their professional network and develop new skills. Join Our Team Explore the job opportunities at Chewy by searching open positions that match your skills and interests. We are looking for curious, creative, and solution-driven team players who are ready to take their career to the next level. Stay Connected Keep up to date with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who work here at Chewy. Job Alert Emails Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities that await you at Chewy. Chewy is more than a company; it's a community where you can grow your career and make a difference. Join us in our mission to be the most trusted and convenient online destination for pet parents (and partners) everywhere.
Learn more about Chewy
Size
21,300 employees
Market Cap
$15.9 billion
Industry
Net Income
-$174.4 million
Founded
2011
5 Year Trend
+136.6%
Revenue
$6.4 billion
NASDAQ

Similar Jobs

More Jobs at Chewy

More Healthcare Jobs

Find similar Business Intelligence Engineer II jobs: