Business Intelligence Engineer II, World Wide Grocery Innovations

The ideal candidate will be responsible for spearheading complex analytical initiatives that drive enterprise-wide transformation and strategic decision-making. This role partners directly with senior leadership to identify, develop, and implement critical business solutions while fostering innovation in data management and financial practices, with a strong focus on data architecture and data engineering solutions. This role requires a proven track record of translating complex business challenges into actionable insights, leading transformational initiatives at an enterprise level, and deep expertise in data engineering and AWS technologies.

Key job responsibilities
• Lead high-impact analytical projects and deliver data-driven insights that shape organizational strategy and business outcomes
• Deliver comprehensive and proactive support across Finance Operations, Accounting, Tax and Indirect Procurement teams
• Develop comprehensive project plans, including resource allocation, milestone tracking, and performance metrics
• Design innovative business analysis frameworks to uncover market trends and drive process optimization
• Build and maintain data lakes and warehouses using AWS technologies while establishing governance frameworks, particularly QuickSight, Andes and Redshift
• Develop and maintain ETL pipelines to integrate multiple data source systems while ensuring data quality
• Create and optimize complex Alteryx and SQL queries, stored procedures, and data models for efficient transformation
• Lead the implementation of QuickSight dashboards and end-to-end analytics solutions
• Architect and optimize database performance and query efficiency across enterprise systems
• Develop comprehensive data validation, testing frameworks, and security measures
• Create technical documentation and mentor team members on data engineering best practices
• Evaluate and implement new data technologies while driving adoption of modern engineering practices
• Identify and execute opportunities for process automation and optimization
• Contribute to data strategy development and maintain alignment with industry best practices


A day in the life
Daily activities for this role will include meeting with business partners to clearly define objectives and requirements and then translating that into actionable technical solutions. It will also include the design, development, and deployment of those solutions.

About the team
The Innovations Team provides analytics and data architecture support to the Finance and Accounting organization within the World Wide Grocery Stores (WWGS) organization at Amazon. The organizational and technical landscape within WWGS is changing rapidly and this team plays an integral part in helping facilitate change.

Basic Qualifications

- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- 1+ years of SQL, ETL or Oracle experience
- 1+ years of processing large, multi-dimensional datasets from multiple sources experience
- 1+ years of performing statistical analysis experience
- 1+ years of developing automated reporting experience
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience with data modeling, warehousing and building ETL pipelines
- Experience in Statistical Analysis packages such as R, SAS and Matlab
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

Preferred Qualifications

- 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 with complex Alteryx environments and use cases
- Retail and/or grocery industry 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 https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on jo