Amazon.com Services LLC is seeking a Business Intelligence Engineer II to provide insights into Whole Foods Market's digital presence, including digital products, checkout experience, data quality, and new technical product initiatives. The goal is to drive decision-making through data analysis, reporting, and insights generation across the product development lifecycle.
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
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
- 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
- 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
Other
- Partnering with Product and E-commerce teams to drive decision-making through data analysis, reporting, and insights generation.
- Support product teams throughout the development lifecycle to define success metrics and measurement approaches
- Lead requirements gathering sessions with product teams and business stakeholders
- 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
