We are seeking a Business Intelligence Engineer II to join the Product & E-commerce Analytics team supporting Whole Foods Market's digital presence. This role will provide insights into our digital products (Whole Foods Market on Amazon, Whole Foods Market web, and the Whole Foods Market app), the in-store and online checkout experience, foundational data quality, and new technical product initiatives. You'll deliver data-driven insights and analytics solutions across the product development lifecycle, partnering with Product and E-commerce teams to drive decision-making through data analysis, reporting, and insights generation.

Key job responsibilities
Analytics Development & Insights
• Establish and track engagement metrics for digital products and e-commerce platforms
• Analyze and extract relevant information from large and complicated data sets of structured and unstructured data to identify insights that influence business decisions and product roadmaps
• Develop deep knowledge of a variety of data sources, including customer, transaction, marketing, inventory, and digital data

Technical Execution & Automation
• Design, develop, and maintain scaled, automated, and user-friendly systems, reports, and dashboards using QuickSight or similar tools
• Collaborate with product and technical teams to consult, develop, and track KPIs and automate reporting/process solutions
• Perform data infrastructure improvements to meet team needs
• Design and implement data models and ETL/ELT processes using AWS services including S3 and Redshift
• Optimize performance and usability of analytics products with expert-level SQL skills
• Ensure data quality, integrity, and consistency across analytical outputs

Product Development Support
• Support product teams throughout the development lifecycle to define success metrics and measurement approaches
• Implement measurement frameworks for new products and features
• Lead requirements gathering sessions with product teams and business stakeholders
• Maintain analytics documentation and knowledge base for product initiatives

Collaboration & Communication
• Translate complex analytical findings into actionable business recommendations for stakeholders and senior management
• Partner with cross-functional teams including Product Management, E-commerce, Operations, Marketing Analytics, and Technology
• Lead projects independently with minimal supervision

Business Intelligence Engineer II, Product & E-commerce Analytics