Business Intelligence Engineer II

Our Opportunity:
Chewy is looking for a Business Intelligence Engineer II to join our Healthcare Analytics Team. In this role, you will be responsible for delivering scalable data infrastructure, developing self-serve analytics tools, and applying data visualizations to unlock insights. You will partner directly with business launch leaders, IT software and data engineers, business analysts, and product teams to anticipate the data infrastructure and tooling needs of the organization and proactively build solutions that fuel insights.
As part of a team that is constantly launching new businesses and features, you will be responsible for using technical solutions to transform raw data from various sources into actionable insights. The ideal candidate has proven experience integrating and scaling data applications plus exemplary data visualization and technical problem-solving skills. This individual is highly proficient in partnering across technology and business teams and has proven experience delivering high quality results with minimal direction from leadership. Strong written and verbal communication skills are required as this role will interface directly with multi-functional teams to roll out new tools, communicate data infrastructure changes, and share analytical findings with executive leaders. Does this sound like you? If so, we would love to hear from you! Come run with the Pack!
What you'll do:

• Design and implement data solutions best-suited to deliver business needs and use cases - from data lakes to analytics tools, across a progressively evolving technical stack.
• Design, develop, optimize, and maintain data architecture and pipelines that adhere to ETL principles and business goals.
• Own development of proof of concepts, QA data sources, and partner in delivering new data tables, metrics, and analytics products
• Partner in leading efforts to automate data extraction and distribution of reports to multiple customers
• Own and continually improve metrics documentation and data governance
• Contribute to analytics product roadmaps that deliver insightful and user-friendly dashboards for both internal and external customers
• Partner with IT teams to construct downstream impact analysis and own change management communication for Healthcare data 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 deliver actionable intelligence

What you'll need:

• 4-year Bachelor's degree in Computer Science, MIS, Business Analytics or a related field
• 3+ years automating data processes, developing dashboards, and building scalable analytics solutions in an ecommerce, omni-channel, or retail setting
• 3+ years of experience managing ETL or data transformation processes, technical architecture documents, and delivering net new or enhancing existing data warehouses
• 3+ years of experience working with data platforms such as: Snowflake, AWS, Vertica, or other RDB
• Strong working knowledge of SQL and proven ability to write, debug, and optimize SQL queries
• Programming expertise in Java, Python, Scala, or another modern programming language
• Demonstrable experience building self-serve BI solutions and automated reports that enable automated alerting and data quality monitoring
• Ability to tailor analytics products to meet the needs of end customers using tools ranging from Excel to Tableau
• Demonstrable experience with data modeling in large Data warehousing / data lake environments
• Strong written and verbal communication skills and experience leading change management processes
• Demonstrable experience delivering high quality and insightful data visualizations and translating complex data into actionable insights
• Exemplary customer management and prioritization skills using systems, processes, and scalable frameworks
• Thorough understanding of Financial KPIs and P&L statement
• Superior attention to detail and experience building processes to validate data integrity
• Proven experience leading teams and delivering results in ambiguous and resource constrained environments
• Ability to travel up to 10% of the time

Bonus:

• Advanced degree such as Masters or equivalent experience in Analytics or MBA
• Project Management Certification
• Experience partnering with Data Science teams to deliver machine learning models from scratch
• Proficiency analyzing clickstream data from Google Analytics or Segment

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 and benefits, 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.
Exempt salary 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.
Base Salary Range
$113,000-$180,500 USD
Chewy is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, ancestry, national origin, gender, citizenship, marital status, religion, age, disability, gender identity, results of genetic testing, veteran status, as well as any other legally-protected characteristic. 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.
To access Chewy's Customer Privacy Policy, please click here.
To access Chewy's California CPRA Job Applicant Privacy Policy, please click here.