Description

Advertising Trust Data is looking for a Senior Business Analyst to help build out actionable and insightful metrics for both internal and external stakeholders. The goal of these actionable insights is to give our internal stakeholders a holistic view of how policies connect to our customers and to help our customers better understand their advertising on Amazon. We are looking for customer obsessed, data driven professionals to join our growing team and solve some of the hardest problems for our customers. To succeed in this role, you will have strong technical acumen and extensive experience in developing reporting, BI, and data warehouse solutions. The ideal candidate will be a self-starter, comfortable diving deep, and making data driven decisions with a strong customer focus. You will work closely with program managers, operations managers, and product owners to analyze massive data sets, identify areas to improve, define metrics to measure and monitor key programs.

Key job responsibilities

• Identify and interpret data sources, manage large amounts of data, ensure consistency of data-sets, create visualizations to aid in understanding data.

• Own the design, development, and maintenance of existing and new reports, analyses, dashboards, etc.

• Define business metrics and KPIs to measure the success of strategic initiatives and build data visualization and analytical solutions.

• Establish self-service automated reporting processes for tracking and diving deep into the data.

• Drive continuous improvement in the automation and standardization of data requirements

• Partnering with product, business and finance teams to create key performance indicators and new methodologies for measuring progress in various initiatives.

• Lead efforts to research and resolve data and analytics challenges raised by business partners. Conduct deep dive analysis to identify and address issues.

About the team

Customer trust is everything at Amazon. Our Advertising Trust organization develops policies, and builds the systems, which ensure customer trust in advertising. With a growing advertising technology business, and hundreds of thousands of active self-service advertisers across the globe, this organization is vital to ensuring we can scale while maintaining and ensuring strong customer trust. Leveraging AI, we build systemic solutions that ensure advertising adherence to the complex regulatory, legal, regional, cultural and customer expectations in over 30 countries.

Basic Qualifications

• Bachelor's degree in engineering, commerce, business administration or equivalent

• 4+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau experience

• 3+ years of business analyst, data analyst or similar role experience

• Experience with data visualization using Tableau, Quicksight, or similar tools

• Experience with SQL

• Experience writing complex SQL queries to pull data from database or data warehouse (Redshift, Oracle, NoSQL etc.) and scripting experience (Python) to process data for modeling.

Preferred Qualifications

• Experience with AWS solutions such as S3, Quicksight and Redshift

• Experience in ETL, data modeling etc. and using databases in a business environment with large-scale, complex datasets