Business Intelligence Engineer Ii

Our Opportunity

Millions of pet parents with unique needs visit Chewy.com looking for products for their beloved pets. We have the task to decide what products features should be build, how to measure the new product functionality and was the newly released product feature performing as expected.

Meet Product and Customer Analytics team @ Chewy. We apply the best of data engineering and business intelligence tools to answer these questions. The mission of our team is to deliver data-driven insights that help us make the best product decisions for Chewy customers. We accomplish this by governing customer event instrumentation, creating analytics that are accessible and actionable by business partners, and running A/B experiments to measure the success of our product features. We aim to be an organization that identifies, validates, and prioritizes key product decisions at scale across Chewy. Our program vision revolves around correctness, consistency, completeness, and accessibility of our data.

We are hiring a BI Engineer II, based in either Boston, MA or Bellevue, WA. In this position, you will help us build scalable analytics solutions, supported by robust data infrastructure and models. You will demonstrate a passion for delivering outstanding customer experience, experience of building web analytics solutions and will bring communication skills that allow you to instill trust in the team that you are working with.

What You’ll Do

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

What You’ll Need

• Advanced ability to draw insights from data and clearly communicate them to the stakeholders and senior management as required.
• Knowledge of data management fundamentals and data storage principles.
• 4+ years of industry experience in a role requiring application of analytic skills to integrate data into operational/business planning or advanced degree.
• Be self-driven, and show ability to deliver on ambiguous projects with incomplete or ‘dirty’ data.
• 4+ years of experience building automated data warehousing environments for production reports or tables. Familiarity with Redshift, Snowflake DWH’s and S3 or similar data lakes preferred
• Excellent communication skills, both written and verbal
• 3+ years’ experience with data visualization tools like Tableau, Looker, Quicksight or similar (familiarity with Tableau preferred).
• Ability and interest in working in a fast-paced and rapidly-changing environment.
• Advanced knowledge of SQL and data modeling
• 2+ years of experience on Python/ R or similar coding languages
• BA/BS in Computer Science, Engineering, Mathematics or related field.

Bonus

• Experience building on AWS QuickSight, ElasticCache etc
• Experience in gathering requirements and formulating business metrics for reporting
• Experience with statistical models and building predictive models from scratch

Compensation & Benefits

The salary range for this position is $78,500-$159,000. 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.

Non-exempt hourly team members accrue paid time off (PTO) while salaried-exempt team members have unlimited PTO, subject to manager approval. Non-exempt hourly team members in Fulfillment Centers and Customer Service are also eligible for additional unplanned unpaid time off (UTO). 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.

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 [email protected].

If you have a question regarding your application, please contact [email protected].

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