Business Intelligence Engineer III - Fulfillment Network, Chewy, WA, US

Our Opportunity:

Chewy is looking for a Business Intelligence Engineer III to demonstrate a wide set of technical and analytical skills to help us advance our business and product analytics domain across the fulfillment network. In this role, you’ll be instrumental in scaling our data infrastructure, reporting capabilities, and analytical frameworks. You'll work with teams across the business, gaining exposure to diverse domains and influencing decision-making at the highest levels. Join a collaborative, fast-paced team where you'll tackle new challenges daily, contribute to meaningful outcomes, and grow alongside Chewy’s core business strategy. 

Duties of this position include but are not limited to setting up data pipelines, analyzing large data sets, investigating data anomalies, developing intuitive data visualizations, extracting actionable insights, communicating results with customers, developing solutions for complex business problems, and automating manual data processes.

What You’ll Do:

• Develop, build, and uphold scalable and efficient data pipelines for the intake, conversion, and storage of large datasets
• Implement data governance, quality checks, and standard processes around ETL/ELT pipelines and cloud data infrastructure
• Build and maintain data pipelines using AWS services such as Redshift, S3, Athena etc
• Build, schedule, and orchestrate scalable data pipelines using Apache Airflow on AWS MWAA to automate ETL/ELT processes
• Partner closely with Data Analysts, Data Scientists, and Engineers to support ongoing data initiatives and scalable architecture improvements
• Mentor junior BI engineers and contribute to setting engineering standards and practices
• Build interactive, scalable, and visually appealing dashboards to support complex business needs and executive decision-making primarily using Tableau, with potential use of Plotly Dash, Streamlit or equivalent
• Act as an internal advocate for adopting modern data visualization, reporting practices, and cloud technologies by showcasing their business impact through meaningful use cases
• Build automation scripts in Python to streamline data ingestion, transformation, and reporting processes and create interactive data visualizations using Python libraries like Plotly, Dash, Matplotlib etc
• Integrate new technologies into existing BI architectures to improve performance, reduce costs, or enhance user experience
• Stay abreast of innovations in AI-powered data tools to find opportunities for improved insights, automation and decision-making
• Communicate findings, results, and recommendations to cross-functional partners at all levels through clear presentations, reports, and visualizations

What You’ll Need:

• Bachelor’s degree in quantitative field (e.g., Statistics, Mathematics, Data Science, Economics, Computer Science) or equivalent experience. 
• 7+ years of experience with detailed knowledge of BI data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools
• 4+ years of experience with data modeling in large Data warehousing, data lake environment
• 4+ years of experience with visualization tools like Tableau, PowerBI or equivalent
• 3+ years of work experience in building self-serve and enterprise level BI solutions
• Experience working with data platforms such as: Snowflake, AWS, Vertica, or other RDB
• Advanced knowledge of SQL (complex querying and optimization)
• Advanced knowledge of Python
• Familiarity with using LLMs and AI Agents to automate data and analytical workflows
• Excellent written and verbal communication skills, with ability to convey complex ideas to non-technical partners and senior leaders

Bonus: (if applicable):

• Master's degree in Analytics, or equivalent advanced academic degree
• Experience with statistical models and building predictive models from scratch