The Business Analyst role family focuses on using data analysis and business knowledge to solve problems and drive decisions.
Key job responsibilities You use data and your understanding of business objectives to solve straightforward problems to drive decision(s) and action(s) within a workflow. You analyze straightforward or previously-defined business and/or data processes to drive improvement. Your work is tactical, where you take actions to achieve a defined goal. Those actions require you to set success measurements and priorities and engage with others in a team as necessary to deliver. The problems you solve are well-defined by a combination of stakeholder requests, business requirements, and direction from your manager and your team. The tasks you work on involve well-defined subject areas with clear requirements, deliverables, and timelines. You use your knowledge and skills to build, implement, and/or meet assigned goals. Your work is reviewed periodically. As your solutions may need refinement, you solicit guidance from your manager or your team to deliver results that meet relevant requirements and timelines. You know your team’s business objectives and use your domain knowledge to provide analytics solutions. You understand how the domain you support relates to the broader business. You extract readily available data and apply basic transformations (e.g., applying if-then logic, aggregating data at different intervals, calculating metric ratios) and analysis in spreadsheets, SQL, and other relevant tools to solve problems. You use descriptive analysis (e.g., pivots, groupings of metrics by attributes, creation of process flows) to understand impact and identify drivers. You ask questions to clarify requirements and determine if and when a new solution is required. You make tradeoffs between time and resources. You recognize similar problems and apply existing solutions to solve them faster. When a problem requires building a net-new solution, you use existing assets and knowledge of what exists within your team to avoid duplication. You assess your work for quality and accuracy, validating against existing sources of truth. Your analytics solutions generate findings that are inputs to your team or stakeholders and help solve straightforward problems. You provide descriptive analyses to support team metrics. Your work informs decisions by providing visibility to business performance, highlighting anomalies and systemic outliers, or revealing new opportunities. You help to improve scalability in your team through documentation, accessibility, and replicability. You automate manual, repetitive work. You document your analytical approach including metric definitions, applied logic, assumptions, and sources. You make data and findings easily accessible to your team through documentation highlighting analytical approach (e.g., business problem, metric definitions, applied logic, assumptions, data sources). Your analytics solutions are consumable by your customers and replicable by other analysts and engineers, helping to make similar work simpler in the future. You help train new peers. You share findings with your team or stakeholders through written and verbal communication channels. You are learning to be clear and concise in your communication. When communicating, you consider the business context and audience and tailor appropriately. Your work may also be shared through mechanisms owned by others, such as WBR callouts, email flashes, and/or documents. While you may not own these communications end-to-end, you are an important part of their creation. You manage meetings effectively. You are learning to put the right people in the room. You are trusted to present decisions to leaders up to three tiers above your level (L7). You are learning to communicate across an increasing diversity of locales and roles. You seek and/or support representation and equity for marginalized voices within organizational systems, assessing barriers to authentic contribution or participation. You demonstrate a willingness to challenge the status quo. You are learning to build products and services to benefit those on the margins and minimizing the ways products and services may perpetuate inequity.
Basic Qualifications
- 2+ years of complex Excel VBA macros writing experience
- 1+ 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
Preferred Qualifications
- Experience working with Tableau
- Experience using very large datasets
- Bachelor's degree in Business, Computer Engineering, Computer Science, Data Engineering, Economics, Finance, Engineering, Mathematics, Machine Learning, Science, Statistics, or Symbolic Systems
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.