Business Intelligence Engineer, WWGS Retail BI
Seattle, OR - USA
Job Summary
Were seeking an experienced Business Intelligence Engineer to own Online Marketing and Customer Lifecycle analyticsa high-impact role supporting Amazons ambitious grocery growth goals. Youll be the technical leader enabling data-driven decisions that optimize how millions of customers discover engage with and return to Amazons online grocery offerings.
What makes this role exciting:
- Strategic impact: Your work directly influences multi-million dollar marketing investments and customer acquisition strategies across Online and Sub Same Day (SSD)-Grocery supporting an S-Team goal to grow active perishables customers
- AI innovation opportunity: Build and deploy business-facing AI solutions that transform how grocery stakeholders interact with datafrom automated insights generation to self-service analytics agents that answer complex questions in minutes instead of days
- Complex problem-solving: Build analytics solutions for ambiguous challenges like marketing attribution customer funnel optimization and lifecycle segmentation where measurement standards dont yet exist
- Cross-functional influence: Partner with Marketing Product Tech and Data teams across organizations to establish unified measurement frameworks and drive alignment on strategic initiatives
- Technical breadth: Design scalable ETL pipelines build multi-touch attribution models create automated reporting infrastructure implement experimentation frameworks and develop AI agents using AWS technologies (Bedrock Redshift Athena QuickSight S3)
Youll tackle challenges like:
- Reducing customer ingress attribution gaps from 12% to <3% through AI-powered data quality improvements
- Building end-to-end customer funnel visibility across fragmented data sources spanning multiple teams
- Creating self-service AI agents and dashboards that save thousands of hours annually while enabling real-time business decisions
- Developing lifecycle segmentation frameworks that identify high-value customer cohorts for targeted engagement
- Pioneering conversational analytics tools that let business users query complex data through natural language
Our team (Worldwide Grocery Stores Retail BI) increases the speed and quality of decision-making through advanced analytics robust data infrastructure and AI-powered automation. We balance immediate tactical needs with long-term strategic initiatives making pragmatic trade-offs between analytical sophistication and actionability. Youll have the opportunity to learn AI techniques while applying them to real business problems that impact millions of customers.
What youll bring:
Strong SQL and data modeling skills experience with BI visualization tools (Tableau/QuickSight) ability to translate ambiguous business requirements into technical solutions and excellent communication skills for both technical and non-technical audiences. Youll work independently with limited guidance while knowing when to collaborate and seek direction.
Ready to shape the future of grocery analytics This role offers the unique opportunity to combine traditional BI excellence with emerging AI capabilities positioning you at the forefront of how data teams serve business stakeholders.
Key job responsibilities
- Build scalable analytics infrastructure: Design and implement automated ETL pipelines data models and reporting solutions using AWS technologies (Redshift Athena QuickSight S3) that transform raw data into actionable insights for marketing and customer lifecycle teams
- Drive marketing measurement excellence: Own end-to-end attribution analysis customer funnel instrumentation and lifecycle segmentation frameworks that enable data-driven investment decisions across multi-million dollar marketing budgets
- Develop AI-powered analytics solutions: Create conversational AI agents and automated insight generation tools that enable business stakeholders to self-serve complex analyses reducing time-to-insight from days to minutes
- Partner cross-functionally: Collaborate with Marketing Product Tech and Data teams to translate ambiguous business requirements into technical solutions establish unified measurement standards and drive alignment on strategic initiatives
- Deliver actionable insights: Conduct deep-dive analyses on customer behavior campaign performance and funnel optimization opportunities that directly inform business strategy and tactical execution
- Ensure data quality and reliability: Implement monitoring validation and documentation practices that maintain trust in analytics outputs and enable confident decision-making
- Mentor and influence: Share best practices contribute to team technical standards and elevate the analytical capabilities of both technical and non-technical stakeholders
A day in the life
Youll start most days reviewing overnight metricsdid marketing campaigns perform as expected Any funnel drop-offs requiring investigation Youll partner closely with Marketing PMs and Online Growth teams to translate their questions into analyses often jumping into SQL to pull data or building QuickSight dashboards for self-service access.
Mid-morning might involve a working session with Tech teams to instrument new customer touchpoints or debug attribution gaps. Afternoons could mean presenting findings to leadership prototyping an AI agent that answers common stakeholder questions or collaborating with Data Engineering on pipeline improvements.
Youll balance planned projects (building attribution frameworks lifecycle segmentation models) with urgent requests (explaining yesterdays order spike validating experiment results). Some days youre deep in code; others youre whiteboarding measurement strategies with cross-functional partners. The variety keeps it interestingyoure never just pulling reports; youre solving puzzles that directly impact how Amazon invests millions in customer acquisition.
About the team
Youll join a six-person Online analytics teampart of the broader Retail Business Intelligence (RBI) organization supporting Amazons grocery business. Working alongside three engineers two product managers and your manager youll collaborate daily with Marketing Product Tech and Data Engineering teams.
RBIs mission is to deliver transformational insights that grow the number of satisfied customers shopping groceries across Amazon. This supportive team values knowledge sharing and learning from each other. Youll develop expertise across the broader RBI organization while contributing to our AI transformation building solutions that drive real customer impact.
- Bachelors degree in sciences engineering finance or equivalent
- 3 years of analyzing and interpreting data with Redshift Oracle NoSQL etc. experience
- Knowledge of SQL and data warehousing concepts
- Experience with data modeling warehousing and building ETL pipelines
- Experience with data visualization using Tableau Quicksight or similar tools
- Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
- Masters degree in sciences engineering finance or equivalent
- 5 years of analyzing and interpreting data with Redshift Oracle NoSQL etc. experience
- Experience in data mining ETL etc. and using databases in a business environment with large-scale complex datasets
- Experience with AWS solutions such as EC2 DynamoDB S3 and Redshift
- Knowledge of advanced skills in Excel as well as any data visualization tools like Tableau or similar BI tools (familiarity with Tableau preferred)
- 5 years of retail grocery or customer-facing or 2 years of retail or operations experience
Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status disability or other legally protected status.
Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process including support for the interview or onboarding process please visit for more information. If the country/region youre applying in isnt listed please contact your Recruiting Partner.
The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience qualifications and location. Amazon also offers comprehensive benefits including health insurance (medical dental vision prescription Basic Life & AD&D insurance and option for Supplemental life plans EAP Mental Health Support Medical Advice Line Flexible Spending Accounts Adoption and Surrogacy Reimbursement coverage) 401(k) matching paid time off and parental leave. Learn more about our benefits at WA Seattle - 99500.00 - 160000.00 USD annually
Required Experience:
IC
About Company
Free shipping on millions of items. Get the best of Shopping and Entertainment with Prime. Enjoy low prices and great deals on the largest selection of everyday essentials and other products, including fashion, home, beauty, electronics, Alexa Devices, sporting goods, toys, automotive ... View more