Business Analyst, Integrated Demand Center, AWS Marketing, IDC Analytics, IDC Analytics
Seattle, OR - USA
Job Summary
Key job responsibilities
Execute analytical requests from marketing stakeholders delivering accurate data pulls ad-hoc analyses and structured summaries
Build maintain and enhance dashboards and reports in QuickSight to support campaign performance tracking and operational visibility
Write SQL queries against Redshift to extract and transform marketing data for reporting and analysis
Perform data quality checks and validation to ensure accuracy and consistency across reporting pipelines
Support senior analysts in developing measurement frameworks attribution analyses and funnel reporting
Collaborate with data engineering to troubleshoot ETL pipeline issues and improve data reliability
Use AI tools (such as Kiro IDE Amazon Quick and MCP-based assistants) to accelerate data exploration query generation and reporting workflows
Support the development of AI-powered automations for data validation and report generation reducing manual turnaround times
Assist in gathering and documenting business requirements from marketing stakeholders translating them into Business Requirement Documents (BRDs) used by D:SE (Data Science & Engineering) and S&O (Strategy & Operations) teams to build and enhance performance dashboards
Document analytical methodologies query logic and reporting processes in team knowledge bases
Prepare data summaries and visualizations for weekly and monthly business reviews
A day in the life
Your focus is turning marketing data into clear answers. Most mornings youll check dashboards to see how campaigns perform dig into anomalies and share findings with the marketers running those campaigns before they even ask. Youll write SQL against large datasets to deep dive and do root cause analysis - connecting top of funnel metrics to revenue impact. Youll partner with teams to translate their questions into structured analytical plans and use AI tools to automate reporting validate data and speed up your workflows. When something interesting surfaces you wont wait to be asked - youll bring it to the table.
About the team
The Integrated Demand Center (IDC) is AWS Marketings unified function for planning delivering and measuring demand generation at scale. The IDC Analytics team sits within Demand Services the shared services arm powering campaign execution and innovation. We generate actionable insights across the IDC delivering analytics custom reporting and clear recommendations that help teams optimize performance strengthen adoption and accelerate revenue impact. Our work spans configuring dashboards defining and monitoring delivery KPIs translating business requirements into technical specifications supporting steering reviews and QBRs and partnering with marketers to transform complex data into data-driven decisions at strategic tactical and operational levels.
- Bachelors degree in mathematics engineering statistics computer science or a related field
- 2 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
- Experience with reporting and Data Visualization tools such as Quick Sight / Tableau / Power BI or other BI packages
- Experience using very large datasets
- Experience in Online Advertising/Marketing/Sales/Digital Media
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 for more information. If the country/region youre applying in isnt listed please contact your Recruiting Partner.
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 WA Seattle - 80200.00 - 97600.00 USD annually
Required Experience:
IC
About Company
Free shipping on millions of items. Get the best of Shopping and Entertainment with Prime. Enjoy low prices and great deals on the largest selection of everyday essentials and other products, including fashion, home, beauty, electronics, Alexa Devices, sporting goods, toys, automotive ... View more