Business Intelligence Engineer II, Product & E-commerce Analytics

Amazon•Austin, TX

About The Position

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.

Requirements

Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
3+ years of developing automated reporting experience
3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
1+ years of processing large, multi-dimensional datasets from multiple sources experience
1+ years of performing statistical analysis experience
Experience with data visualization using Tableau, Quicksight, or similar tools
Experience with data modeling, warehousing and building ETL pipelines
Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field

Nice To Haves

Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
Experience working as a BIE in a technology company
Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
Master's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field

Responsibilities

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
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
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
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