Business Intelligence Engineer Ii

Our Opportunity:

Chewy is looking for a Business Intelligence Engineer to serve as a hands-on technical subject matter expert who will contribute to our rapidly growing and continued success. This is a crucial role leading our journey to establish and mature capabilities across the pillars of insights and analytics, data science, Business Intelligence, and data enablement for the Operations Planning and Strategy Organization.

The ideal candidate has proven experience integrating and scaling data applications, strong technical problem-solving skills, and success in developing scalable data infrastructure to support business and analytics teams. Chewy has a culture of data-driven decision-making, and demands Business Intelligence that is timely, accurate, and actionable. The Operations Planning and Strategy team operates in a fast-paced environment where every day brings new challenges and new opportunities.

You will be responsible for designing and implementing solutions and technologies which will handle the growing business needs of our organization across all business functions. Along the way you will gain a broad knowledge of how all of the many pieces of Chewy work together to provide the level of service our customers have come to know and expect.

What You'll Do:

• Design and implement data solutions best-suited to deliver on our needs and use cases - from data lakes to analytics, and beyond across a progressively evolving technical stack.
• Design, develop, optimize, and maintain data architecture and pipelines that adhere to ETL principles and business goals.
• Solve complex data problems to deliver insights that helps our business to achieve their goals.
• Create Proof of Concepts and advise, consult, mentor and coach other data and analytic professionals on data standards and practices.
• Lead the evaluation, implementation and deployment of emerging tools and process for analytic data engineering to improve the value of the solutions we build.
• Create data products by working with analytics and data scientist team members to speed to market and to enrich data and model options.
• Develop and deliver communication and education plans on analytic data engineering capabilities, standards, and processes.
• Code, test, and document new or modified data systems to create robust and scalable applications for data analytics.
• Partner with Business Analysts and Solutions Architects to develop technical architectures for strategic enterprise projects and initiatives.
• Provide on-line reporting and analysis using Business Intelligence tools and a logical abstraction layer against large, multi-dimensional datasets and multiple sources
• Document technical details of your work using industry standard protocols like Jira, Confluence etc.
• Proactively monitor existing metrics, propose new metrics, and work across the organization to make actionable intelligence
• Produce comprehensive, usable data set documentation, metadata, BI reports, Dashboards, and insights.

What You'll Need:

• Deep expertise of core data platforms: Snowflake, AWS, Vertica, other RDB.
• Knowledge of integration technologies such as AWS Data Migration Services, Azure DataFactory, Google DataProc or other data integration technologies.
• Programming expertise in Java, Python, Scala, or another modern programming language.
• Experience in mathematical modeling and linear programming, technical analysis and reporting, computer program design/development/testing preferred.
• Strong working knowledge of SQL and the ability to write, debug, and optimize SQL queries.
• Strong written and verbal communication skills and experience.
• 4+ years of experience with detailed knowledge of BI data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools.
• 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
• 4-year bachelor's degree in Computer Science or a related field.
• Knowledge of Business Intelligence technologies such as Tableau and Power BI.

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.