Business Intelligence Engineer II

Chewy Chewy · Retail · Bellevue, WA

This role focuses on designing, developing, and implementing large-scale data aggregate tables and BI solutions for analytics and business insights. It involves data ingestion, ETL/ELT processes, and providing online reporting using BI tools. The engineer will analyze customer behavior, optimize site experience, and create recommendations based on data. Required skills include advanced SQL, data modeling, experience with data warehousing environments (Redshift, Snowflake), data lakes (S3), and programming languages like Python or R.

What you'd actually do

  1. Design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data aggregate tables and reports/dashboards/BI solutions for analytics and deep business insights.
  2. Implement data ingestion routines both for real time and batch using best practices in data modeling, ETL/ELT processes.
  3. Provide on-line reporting and analysis using business intelligence tools and a logical abstraction layer against large, multi-dimensional datasets and multiple sources.
  4. Gather business and functional requirements and translate these requirements into robust, scalable, operable solutions that work well within the overall data architecture.
  5. Produce comprehensive, usable data set documentation, metadata, BI reports, and Dashboards.

Skills

Required

  • Advanced knowledge of SQL
  • Data modeling
  • Building automated data warehousing environments for production reports or tables
  • Redshift
  • Snowflake DWH’s
  • S3 or similar data lakes
  • Python/ R or similar coding languages

Nice to have

  • Google Analytics
  • Tableau