Business Intelligence Engineer II

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

The specific salary offered to a candidate may be influenced by a variety of factors including but not limited to the candidate’s relevant experience, education, and work location. In addition, this position is eligible for 401k and a new hire and annual equity grant.
 
We offer different types of insurance, such as medical/Rx, vision, dental, life, disability, hospital indemnity, critical illness, and accident. We offer parental leave, family services benefits, backup dependent care, flexible spending accounts, telemedicine, pet adoption reimbursement, employee assistance program, and many discounts including 10% off pet insurance and 20% off at Chewy.com.
 
Salaried-exempt team members have unlimited PTO, subject to manager approval. Team members will receive six paid holidays per year. Team members may be eligible for paid sick and family leave in compliance with applicable state and local regulations.

Pay Range$91,000—$168,500 USD

Chewy is committed to equal opportunity. We value and embrace diversity and inclusion of all Team Members. If you have a disability under the Americans with Disabilities Act or similar law, and you need an accommodation during the application process or to perform these job requirements, or if you need a religious accommodation, please contact CAAR@chewy.com.

 

If you have a question regarding your application, please contact HR@chewy.com.

 

To access Chewy’s Customer Privacy Policy, please click here. To access Chewy’s California CPRA Job Applicant Privacy Policy, please click here.