Are you passionate about solving business challenges at a global scale? Amazon Employee Services is looking for an experienced Business Analyst to join Retail Business Services team and help unlock insights which take our business to the next level. The candidate will be excited about understanding and implementing new and repeatable processes to improve our employee global work authorization experiences. They will do this by partnering with key stakeholders to be curious and comfortable digging deep into the business challenges to understand and identify insights that will enable us to figure out standards to improve our ability to globally scale this program. They will be comfortable delivering/presenting these recommended solutions by retrieving and integrating artifacts in a format that is immediately useful to improve the business decision-making process. This role requires an individual with excellent analytical abilities as well as an outstanding business acumen. The candidate knows and values our customers (internal and external) and will work back from the customer to create structured processes for global expansions of work authorization, and help integrate new countries/new acquisitions into the existing program. They are experts in partnering and earning trust with operations/business leaders to drive these key business decisions.
Responsibilities:
- Own the development and maintenance of new and existing artifacts focused on analysis of requirements, metrics, and reporting dashboards.
- Partner with operations/business teams to consult, develop and implement KPI’s, automated reporting/process solutions, and process improvements to meet business needs.
- Enable effective decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format.
- Prepare and deliver business requirements reviews to the senior management team regarding progress and roadblocks.
- Participate in strategic and tactical planning discussions.
- Design, develop and maintain scaled, automated, user-friendly systems, reports, dashboards, etc. that will support our business needs.
- Excellent writing skills, to create artifacts easily digestible by business and tech partners.
Key job responsibilities
• Design and develop highly available dashboards and metrics using SQL and Excel/Tableau/QuickSight
• Understand the requirements of stakeholders and map them with the data sources/data warehouse
• Own the delivery and backup of periodic metrics, dashboards to the leadership team
• Draw inferences and conclusions, and create dashboards and visualizations of processed data, identify trends, anomalies
• Execute high priority (i.e. cross functional, high impact) projects to improve operations performance with the help of Operations Analytics managers
• Perform business analysis and data queries using appropriate tools
• Work closely with internal stakeholders such as business teams, engineering teams, and partner teams and align them with respect to your focus area
- 3+ years of Excel or Tableau (data manipulation, macros, charts and pivot tables) experience
- Experience defining requirements and using data and metrics to draw business insights
- Experience with SQL or ETL
- Knowledge of data visualization tools such as Quick Sight, Tableau, Power BI or other BI packages
- 1+ years of tax, finance or a related analytical field experience
- Experience in Amazon Redshift and other AWS technologies
- Experience creating complex SQL queries joining multiple datasets, ETL DW concepts
- Experience in SCALA and Pyspark