Business Intelligence Engineer II

Chewy; Louisville (KY); On-site; USD 100,000 - 130,000; Full time

Job summary

Chewy is seeking a Business Intelligence Engineer II to design scalable data models and analytics for Pharmacy Operations across Vet Services and Rx Fulfillment. This role blends data pipeline ownership with reporting and deep-dive analysis in partnership with Operations, Operations Support, and Technology teams.

You will build and maintain batch and near real-time data ingestion, deliver self-serve reporting through BI tools, and create robust semantic layers to ensure consistent metrics across

Qualifications

• Bachelor’s degree in CS/Engineering/Information Systems/Analytics or equivalent practical experience.
• 5+ years delivering BI analytics solutions (dashboards, reporting, curated datasets) for business teams.
• Proven experience designing and owning enterprise-grade data pipelines and data models across multiple source systems.

Responsibilities

• Design, develop, implement, test, document, and operate large-scale data models and BI solutions.
• Build and maintain data ingestion and transformation routines (batch and near real-time).
• Deliver self-serve reporting and semantic layers for consistent metrics across source systems.
• Gather requirements and translate them into robust, scalable analytics solutions.
• Produce metadata and documentation to improve trust and maintainability.
• Perform deep-dive analysis to explain performance trends and quantify impact.
• Mentor analysts on data modeling, visualization, and stakeholder communication.

Skills

SQL proficiency

Data modeling

ETL/ELT

Tableau

Git

Python

dbt

Education

Bachelor’s degree in CS/Engineering/IS/Analytics or equivalent

Tools

Snowflake

Tableau

Git

dbt

Job description

Job Description:

Our Opportunity:

Chewy Pharmacy Operations relies on timely, trusted data to deliver safe, efficient, and world class customer experienceacross 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 [e-mail].