Senior Business Analyst

Benchmarking and Pricing Insights (BPI), part of Pricing (Pricing Shared Services, 3P Pricing, Retail Pricing) is seeking a self-driven Business Analyst with a good owner s mindset, relentless customer advocacy, and frontline obsession to build and manage data lakes and dashboards that measure and publish Price competitive metrics in collaboration with other CAT and DE team in Amazon. This role was created to provide a dedicated focus on executing core PC metric programs/projects in support of the BPI s vision and to drive transparency, partnership, and success through a programmatic approach. The Business Analyst will manage end to end change management processes from strategy definition, technology applications, to provide timely, meaningful, and consumable information. Good communication skills and teamwork are critical. Candidates must be able to demonstrate strong project management skills and have relentless commitment to ensure data quality and build scalable tools.

Key job responsibilities
- Drive the execution of all processes in the tool convergence lifecycle, including discovery, planning, requirements and roadmap development, onboarding and change management.
- Create a change management strategy and plan to support the adoption of key changes required through change execution and transition periods.
- Work with the internal teams of BPI to manage prioritization, execution and monitoring of project activities
- Partner with the Program/Product Managers in handling data related to PC metrics, analyzing data and developing strategies/proposals that impact the customer experience
- 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.
- Partner with the technology teams to groom, prioritize (through business impact) and execute the application roadmap, while managing the backlog
- 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.
- Generating complex queries to dive deep on process issues

A day in the life
Working with internal stakeholders to establish data structure and a dashboard that can be used by the business.
Will manage PC metric dashboard and collaborate with program managers to provide WBR/CMR/MBR deep dive data cuts.
Should build mechanisms and procedures to enable timely data deep dives to update to our stakeholders of WW pricing on HDTs/PR FAQs
Will build and report out productivity and other metrics to track and report program defects.
- 6+ years of tax, finance or a related analytical field experience
- 4+ years of writing SQL queries and creating business intelligence reports using Tableau, Power BI experience
- Experience defining requirements and using data and metrics to draw business insights
- Experience making business recommendations and influencing stakeholders
- Experience with Excel
- 6+ years of applying key Business performance indicators (KPIs) to analyses experience
- 6+ years of building financial and operational reports/data sets that inform business decision-making experience
- 6+ years of creating process improvements with automation and analysis experience
- 6+ years of participating in continuous improvement projects in your team to scale and improve controllership with measurable results experience
- Experience making business recommendations and influencing stakeholders
- Experience with QuickSight dashboard and visual creation