The Business Intelligence Engineer will play a critical role in the Last Mile division, focusing on strategic initiatives and continuous improvement. This role involves collaborating closely with stakeholders and program managers to develop metrics, reports, dashboards, and automated systems that provide actionable insights. A key responsibility is to establish global consistency in metric definitions, ensuring standardized reporting across all site types and building a robust data infrastructure to support process enhancements. Working within Amazon's vast and complex data warehouse environment, the ideal candidate should possess strong skills in managing large datasets and excel in communicating with business owners to identify and address key business questions through data-driven solutions. The role requires expertise in designing, implementing, and maintaining scalable, cost-effective systems that efficiently transfer data from production environments to the data warehouse and end-user applications. Additionally, the position offers opportunities to explore and implement innovative solutions using generative BI and machine learning technologies to tackle complex business challenges effectively.

Key job responsibilities
* Partner with internal stakeholders and program managers across multiple teams, gathering requirements and delivering end to end business intelligence solutions.
* Provide timely and actionable insights into current business performance. This will require data gathering and manipulation, synthesis and modeling, problem solving, and communication of insights and recommendations.
* Analyze and visualize process adherence and performance data to articulate user behavior or process problems to support successful execution of the programs.
* Partner with data engineers to identify the source of data and create a data pipeline to collect necessary business inputs to deliver the analytical product.
* Support pilot studies by building robust pilot analyses plan, data collection processes, and analyzing the output to deliver final recommendations.
* Utilize predictive analytics, machine learning and generative BI tools to continuously improve the quality of the analytics products and effectiveness of the business insights
* Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.

A day in the life
You will be working on Redshift, Quicksight, Python to pull, manipulate and present data in dashboards. You will be working with stakeholders to understand analytic business requirements and build metrics and dashboards for use in the AMZL network. You will have the opportunity to do basic machine learning models like Clustering, regression required for benchmarking products.

About the team
The Global Benchmarking, Standards and Audit (GBSA) team within AMZL (list mile) performs benchmarking analysis to identify best-in-class performances and highlight areas for further analysis. Findings from these analysis feed our Standards Improvement activities on a global scale. Adoption of the standards we create will be measured through a global audit program that creates additional data points for benchmarking analysis, and provides a mechanism for local operators to address gaps to proven standard work.