Business Analyst, Amazon Video Advertising

At Amazon Ads, we sit at the intersection of Advertising, Media and eCommerce. With millions of customers visiting us every day to find, discover, and buy products, we believe that advertising, when done well, can enhance the value of the customer experience and generate a positive ROI for our advertising partners. We strive to make advertising relevant so that customers welcome it - across Amazon’s ecosystem of mobile and desktop websites, proprietary devices, and the Amazon Advertising business. If you’re interested in innovative advertising solutions with a relentless focus on the customer, you’ve come to the right place

As a Business Analyst in the Amazon Ads team, you will be responsible for analyzing advertising performance data, providing insights to drive business decisions, and supporting the growth of Amazon's advertising business in India. We are seeking an experienced and highly skilled Reporting & Automation Specialist to lead our data analytics and reporting efforts. This role will be responsible for overseeing complex data flows, developing advanced reporting solutions, and driving data-driven decision-making across Business, Finance, and Leadership teams. The ideal candidate will have a deep understanding of business intelligence tools, advanced SQL skills, and the ability to translate complex data into actionable insights.

Key job responsibilities
• Lead the development and implementation of sophisticated reporting solutions, integrating advertising data from MADS, Hercules, Spektr with retail platform datasets to provide comprehensive business intelligence.
• Design and deliver high-impact reports and dashboards for Business, Finance, and Leadership teams, ensuring data accuracy, relevance, and alignment with strategic objectives.
• Serve as the senior point of contact for complex reporting-related queries, providing expert guidance and insights to stakeholders across the organization.
• Drive continuous improvement initiatives to optimize reporting processes, including the implementation of advanced automation techniques and cutting-edge BI tools. L
• Lead the development of complex SQL queries and data models to support in-depth analysis and insight generation for business teams.
• Architect and implement sophisticated reporting and analytics solutions using Amazon QuickSight, Excel macros, and other advanced BI tools.
• Collaborate with cross-functional teams to elevate the overall data analytics capabilities of the organization.

BASIC QUALIFICATIONS

- 5+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau experience
- Bachelor's degree or equivalent
- Experience defining requirements and using data and metrics to draw business insights
- Experience with Excel
- Experience with SQL
- Proven track record of implementing large-scale process improvements through automation and advanced analytics
- Expert-level proficiency in SQL, including experience with complex queries and data modeling
- Demonstrated ability to manage multiple high-priority reporting cycles and projects simultaneously
- Exceptional attention to detail and ability to maintain accuracy when working with large, complex datasets

PREFERRED QUALIFICATIONS

- Advanced certifications in relevant BI tools (e.g., Amazon QuickSight, Tableau, Power BI)
- Experience with cloud-based data warehousing solutions (e.g., Amazon Redshift, Snowflake)
- Proficiency in programming languages such as Python or R for data analysis and automation
- Knowledge of machine learning and predictive analytics techniques
- Experience working in e-commerce or digital advertising industries
- Strong presentation skills with the ability to communicate complex data insights to both technical and non-technical audiences
- Track record of driving data-driven decision-making at senior leadership levels

Our inclusive culture empowers Amazonians to deliver the best results for our customers.

---