Our Opportunity:

Chewy is looking for a Business Intelligence Engineer II to join our Marketing Science and Operations team. This person can be based in Boston, MA, Seattle, WA, Minneapolis, MN, or Plantation, FL. The ideal candidate should have experience in digital marketing and e-commerce and be passionate about business intelligence and analytics. You will get to work side by side with thoughtful, hardworking, and highly motivated marketing leaders. We are looking for someone who has the personality, passion, excitement, and aim to succeed!

What You'll Do:

• Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key decisions and process improvements
• Work closely with the Marketing teams in areas including Performance Marketing, Brand Marketing, Healthcare, and CRM to provide online reporting and analysis using business intelligence tools and a logical abstraction layer against large, multidimensional datasets and multiple sources and drive business insights.
• Gather business and functional requirements and translate these requirements into robust, scalable, operable solutions that work well within the overall data architecture.
• Produce comprehensive, usable data set documentation, metadata, BI reports, Dashboards, and insights.
• Collaborate with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL and various technological platforms.
• Recognize and embrace best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.
• Respond to high-priority requests from senior business leaders.
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for secondary data sets.

What You'll Need:

• BA/BS  or equivalent in Computer Science, Engineering, Mathematics, or a related field.
• Advanced knowledge of SQL and data modeling
• Intermediate Knowledge in Python and advanced data visualization tools such as Plotly/Dash/React/D3Js etc.
• 3+ years of experience building automated data warehousing environments for production reports or tables. Familiarity with Redshift, Snowflake DWH, and S3 or similar data lakes preferred
• 3+ years’ experience with data visualization tools like Tableau, Looker, Quicksight, or similar (familiarity with Tableau preferred).
• 3+ years of experience with data modeling in large Data warehousing, data lake environment
• Advanced ability to draw insights from data and communicate them to the collaborators and senior management as required.
• Be dedicated and show the ability to deliver on ambiguous projects with incomplete or ‘dirty’ data.
• Knowledge of data management fundamentals and data storage principles.
• Ability and interest in working in a fast-paced and rapidly changing environment.
• Excellent communication skills, both written and verbal

Bonus:

• Experience with AI/ML, specially using LLM/Agents/Bots in Data Engineering/Visualization/Analysis
• Experience in gathering requirements and formulating business metrics for reporting
• Experience building on AWS Platform services
• Experience with statistical models and building predictive models from scratch