Business Intelligence Engineer III

Key Skills

Apache Hadoop, Apache Hive, AWS, Data Warehousing, Elasticsearch, ETL frameworks, MapReduce, Natural Language Processing (NLP), PowerBI, SQL, Tableau

Job Description

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 would be most useful to them and help them discover those products. How do we do this?

Meet Personalization team @ Chewy. We use best of machine learning techniques and continuously test the outcomes to simplify product discovery for pet parents looking for their pet needs on Chewy.com. Our exceptional multi-disciplinary team of data scientists, data engineers, software engineers and product managers work together to power personalized recommendations and product discovery for pet parents. Our team has single threaded ownership of the space allowing us to decide impactful products that we can experiment, measure with metrics and deliver at a fast pace.

We are hiring a Lead BI for our Personalization team in Boston, MA. In this position, you will help us build scalable, robust analytics solutions for Personalization at Chewy. You will demonstrate a passion for delivering outstanding customer experience, experience of building scalable solutions and will bring communication skills that allow you to instill trust in the team that you are working with.

What You’ll Do:

• Design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data models, reports/dashboards/BI solutions for analytics and deep learning
• 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
• 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

What You’ll Need:

• Candidate must possess a Bachelor’s degree in Computer Science, or related field, or equivalent experience
• 7+ years of experience with detailed knowledge of BI data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools
• 5+ years of experience with BI/visualization tools like Tableau/BO/OBIEE etc.
• 3+ years of work experience in building self-serve BI solutions, canned reports and enterprise level BI solutions
• 3+ years of experience with data modeling in large Data warehousing, data lake environment
• 3+ years of medium to advanced object-oriented programing on Python or Java skills on industry projects
• 2+ years of data science experience with building regression, classification models
• Exposure to Big Data stack environments (EMR, Hadoop, MapReduce, Hive)
• Good analytical skills with excellent knowledge of SQL and advance SQL
• Excellent communication skills, both written and verbal
• Experience with A/B Testing & Optimization techniques

Bonus:

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

Compensation & Benefits:

Our salary range for a Business Intelligence Engineer III position is $134,500.00 - $215,000.00. 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.