Business Intelligence Engineer II

Chewy Chewy · Retail · Bellevue, WA

This Business Intelligence Engineer II role focuses on designing, developing, and maintaining data pipelines, data models, and reporting solutions. The role involves analyzing complex data sets, building dashboards, partnering with stakeholders, and utilizing SQL, data warehousing technologies, and Python. It also includes researching opportunities for innovation in data analysis and BI solutions.

What you'd actually do

  1. Design, develop, and maintain end-to-end data pipelines, data models, and reporting solutions, ensuring data quality and integrity.
  2. Analyze complex data sets, develop statistical models, and build interactive dashboards and reports to surface trends, identify risks, and surface opportunities for process optimization.
  3. Partner with business stakeholders to gather reporting and analytical requirements and translate business needs into data-driven solutions.
  4. Develop complex SQL queries, utilize data warehousing technologies, and apply scripting languages like Python to automate processes and analyze data.
  5. Deliver actionable insights to business and product teams, providing training on self-service reporting tools to democratize data across the organization.

Skills

Required

  • SQL
  • data warehousing concepts
  • BI tools (e.g., Tableau, Power BI, AWS QuickSight)
  • statistical analysis
  • Python
  • data normalization
  • dataset modeling
  • retail/e-commerce or clickstream data analysis

Nice to have

  • Bachelor's degree in Computer Science, Analytics, Information Management, Data Science, or related field of study
  • Master's degree in Computer Science, Analytics, Information Management, Data Science, or related field of study

What the JD emphasized

  • Bachelor’s degree in Computer Science, Analytics, Information Management, Data Science, or related field of study and 3 years of experience required
  • Master’s degree in Computer Science, Analytics, Information Management, Data Science, or related field of study and 1 year of experience required
  • SQL, data warehousing concepts, and experience with BI tools (e.g., Tableau, Power BI, AWS QuickSight)
  • Ability to analyze, interpret, and model complex data, including experience with statistical analysis
  • Scripting languages like Python for automation and data manipulation
  • Data normalization and dataset modeling in large data warehouse environments
  • Analyzing retail/e-commerce or clickstream data, and Python