Amazon LMAQ team is seeking an exemplary Business Analyst with broad technical skills to develop data visualizations and build automation solutions that drive business decision making and process improvement. The ideal candidate will draw upon advanced analytical, problem solving skills, and passion for delivering business insights and analytics. We look for candidates who are excellent communicators, self-motivated, flexible, hardworking, and who like to have fun.
It involves design and development of automated data pipelines, sophisticated analytical modeling and intuitive data visualization. This role will directly be responsible for maintaining front end code using Python, SQL, HTML, or other similar coding languages. Proficiency in the aforementioned languages is not required, but an ability to be a quick learner and gain proficiency is required for a successfully candidate. This role will have high level visibility due to the nature of the toolsets being maintained, built, and the network impact of analysis conducted. This role has great exposure to a broad scope that can really help shape the future of Last Mile and promotes career progression.

Key job responsibilities
- Provide data management processes such as accessing raw data feeds, building queries and macros, writing VBA code, organizing data and designing reports that present status-at-a-glance visualization for business performance.
- Retrieving and analyzing large sets of data using Excel, SQL, and other data management systems.
- Designing and implementing reporting solutions to enable stakeholders to manage the business and make effective decisions.
- Taking ownership of reporting processes to ensure that each report is accurate and timely with a high degree of customer focus in resolving data discrepancies.
- Building and managing related key performance indicators (KPIs) to measure, control, and benchmark reporting processes.
- Monitoring existent metrics, building new metrics, and partnering with internal teams to identify process and system improvement opportunities.
- Supporting cross-functional teams on the day-to-day execution of the existent program implementation.
- Generating complex queries to dive deep on process issues
- Innovating to improve customer experience

BASIC QUALIFICATIONS

- 1+ years of Excel or Tableau (data manipulation, macros, charts and pivot tables) experience
- 2+ years of complex Excel VBA macros writing experience
- Bachelor's degree or equivalent
- Experience defining requirements and using data and metrics to draw business insights
- Experience with SQL or ETL

PREFERRED QUALIFICATIONS

- Experience with reporting and Data Visualization tools such as Quick Sight / Tableau / Power BI or other BI packages
- Experience using statistical tools such as Minitab