Business Analyst II, Central Analytics, AET Planning & Analytics

Amazon; Seattle (WA); On-site; USD 83,000 - 130,000; Full time

Job summary

Amazon is hiring a Business Analyst for the Amazonian Experience and Technology (AET) team in Seattle to drive data-driven decisions for workforce planning and operational efficiency.

The role focuses on forecasting headcount demand, building Redshift pipelines, and delivering insights across Finance, HR, Operations, Data Science, and BI Engineering. You will explore AI tools to automate processes and improve output quality.

Qualifications

• 5+ years of Excel experience (including VBA, pivot tables, array functions, power pivots)
• 3+ years in tax, finance or related analytical field
• 3+ years in business or financial analysis
• Bachelor's degree or equivalent
• Experience defining requirements and using data to draw insights
• Experience with Excel
• Experience with data visualization using Tableau or similar tools
• Experience with SQL
• 3+ years of SQL experience

Responsibilities

• Own and maintain Redshift SQL pipelines, data models, and reporting dashboards that support headcount demand planning and capacity forecasting across PXT's variable workforce
• Partner with the Capacity Planning team to translate contact volume forecasts and staffing assumptions into accurate headcount plans
• Support Operational Planning, Quarterly Guidance, and Monthly R&O cycles by producing the data inputs, analysis, and reporting that shape headcount targets across PXT's variable workforce
• Identify, validate, and resolve data quality issues across source systems, ensuring analytical outputs are accurate and trustworthy
• Partner with Finance, HR, Operations, Data Scientists, Applied Scientists, and Business Intelligence Engineers to deliver analytical solutions that drive operational decisions
• Actively explore and integrate AI tools to automate repeatable analytical processes, improve efficiency, and enhance the quality of outputs
• Document methodology, data logic, and business rules to ensure analytical solutions are reproducible, scalable, and transferable

Skills

Excel

VBA

Pivot tables

Power Pivot

Data visualization

Tableau

SQL

Data analysis

Stakeholder influence

Education

Bachelor's degree

Tools

ETL

Data warehouse

Job description

Description

The Amazonian Experience and Technology (AET) team is looking for a passionate Business Analyst with strong analytical and communication skills to support our mission of being the most scientific, technically proficient, and inclusive organization in the world. The team is responsible for developing data-driven analytical solutions that increase the efficiency and quality of services provided to Amazon's growing global employee base. This includes workforce planning and headcount demand modeling, customer experience measurement, centralized metrics reporting for AET leadership, and forecasting analytics, all designed to translate complex operational data into actionable decisions.

We are looking for a motivated Business Analyst with strong technical skills who desires to work at the intersection of workforce planning, business intelligence, and data engineering. PXT (People eXperience and Technology) is responsible for the employee experience and HR technology serving all Amazonians worldwide. In this role, you will own PXT FORCE (Forecasting & Resource Capacity Engine), our system for forecasting headcount demand and managing variable workforce capacity across PXT. You will build and maintain Redshift SQL pipelines and develop Amazon Quick reporting. You will work closely with our Capacity Planning team and partners across Finance, HR, Operations, Data Science, and Business Intelligence Engineering to ensure our headcount plans are accurate and decision-ready. You will actively explore and integrate AI tools into your work, identifying opportunities to automate repeatable processes and enhance the speed and quality of analytical outputs.

Key job responsibilities

• Own and maintain Redshift SQL pipelines, data models, and Amazon Quick reporting dashboards that support headcount demand planning and capacity forecasting across PXT's variable workforce
• Partner with the Capacity Planning team to translate contact volume forecasts and staffing assumptions into accurate, decision-ready headcount plans
• Support Operational Planning, Quarterly Guidance, and Monthly R&O cycles by producing the data inputs, analysis, and reporting that shape headcount targets across PXT's variable workforce
• Identify, validate, and resolve data quality issues across source systems, ensuring analytical outputs are accurate and trustworthy
• Partner with Finance, HR, Operations, Data Scientists, Applied Scientists, and Business Intelligence Engineers to deliver analytical solutions that drive operational decisions
• Actively explore and integrate AI tools to automate repeatable analytical processes, improve efficiency, and enhance the quality of outputs
• Document methodology, data logic, and business rules to ensure analytical solutions are reproducible, scalable, and transferable

Basic Qualifications

• 5+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau experience
• 3+ years of tax, finance or a related analytical field experience
• 3+ years of business or financial analysis experience
• Bachelor's degree or equivalent
• Experience defining requirements and using data and metrics to draw business insights
• Experience with Excel
• Experience making business recommendations and influencing stakeholders
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with SQL
• 3+ years of SQL experience

Preferred Qualifications

• Experience in data mining (SQL, ETL, data warehouse, etc.) and using databases in a business environment with large-scale, complex datasets
• Experience with data scripting languages (e.g., SQL, Python, R, or equivalent) or statistical/mathematical software (e.g., R, SAS, Matlab, or equivalent)

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

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.

Salary and benefits

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits.

USA, WA, Seattle - 82,700.00 - 130,100.00 USD annually

Company

Amazon.com Services LLC

Job ID: A10467438