BI Engineer II: Data Pipelines & Analytics

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

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