BI Engineer II

Full Time
Boston, MA, USA
2 months ago

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.

The Chewy Site Analytics team is looking for an experienced BIE II to support our product team(s) in Boston, MA. In this role, you will work closely with the Site Experience team to:

  • Develop keen understanding of customer onsite/in-app behavior
  • Build dashboards and reports, provide ad-hoc analyses and insights for improving customer experience and conversion rate
  • Use analysis and insights to inform the customer experience roadmap

We’re looking for a self-professed data geek who cares deeply about the customer experience and thrives in a fast-paced environment. You are comfortable blazing your own path and operating in a highly ambiguous environment. You’ll have the ability to make a significant contribution to Chewy’s success and the satisfaction of directly seeing the results of your work. 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:

  • Design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data aggregate tables and reports/dashboards/BI solutions for analytics and deep business insights
  • Implement data ingestion routines both for 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, and Dashboards
  • Closely examine customer traffic, browsing and purchase behaviors by developing the deepest understanding of business metrics
  • Conduct deep dive analysis on customer pathing and other website and mobile app interactions to optimize site experience
  • Use available tools and data (Snowflake, Python, Google Analytics, Tableau, etc.) to construct, maintain, distribute and enhance dashboards and reporting
  • Ensure analytics implementation provides crystal-clear visibility into the impact and the value of new features and functionality
  • Build insights and create recommendations via written and verbal communications that can be understood by a broad audience
  • Establish & maintain strong relationships with key stakeholders

What You’ll Need:

  • BA/BS in Computer Science, Engineering, Mathematics or related field.
  • Advanced knowledge of SQL and data modeling
  • 3+ 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
  • 4+ years of industry experience in a role requiring application of analytic skills to integrate data into operational/business planning or advanced degree.
  • 3+ years’ experience with data visualization tools like Tableau, Looker, Quicksight or similar (familiarity with Tableau preferred).
  • 2+ years of experience on Python/ R or similar coding languages
  • Advanced ability to draw insights from data and clearly communicate them to the stakeholders and senior management as required.
  • Be self-driven, and show 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 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

 

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.