Business Intelligence Engineer, Advertiser Experience

Amazon Advertising; New York (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

Amazon Advertising is seeking a Business Intelligence Engineer to join the analytics team supporting the Advertiser Experience organization. You will build dependable weekly reports and dashboards, deep dive into advertiser experiences, and translate questions into scalable data solutions.

You will collaborate with product managers, analysts, and stakeholders to define metrics, ensure data quality, and drive decisions with data while leveraging AI to improve speed and efficiency.

Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc.
• 1+ years of processing large, multi-dimensional datasets from multiple sources
• 1+ years of performing statistical analysis
• 1+ years of developing automated reporting
• 3+ years in the job offered or a related occupation
• 1+ years of using SQL, ETL/Oracle
• Experience with data visualization tools like Tableau, QuickSight
• Experience with data modeling, warehousing and ETL pipelines
• Experience with AWS services (EC2, DynamoDB, S3, Redshift)
• Experience in data mining and handling large-scale datasets

Responsibilities

• Build and maintain dependable WBR reports and self-service dashboards for leadership reviews.
• Deep dive into advertiser experience to surface actionable insights and trends.
• Design, develop, and optimize data pipelines, models, and datasets.
• Collaborate with product managers and analysts to define metrics and analytical solutions.
• Identify opportunities to apply AI and automation to speed insights and scale.

Skills

SQL

ETL

Python

Data Visualization

Tableau

QuickSight

Data Modeling

Data Warehousing

AWS

Redshift

Dashboards

AI/Automation

Education

Bachelor's degree in CS/Engineering/Math/Statistics/Economics

Tools

Redshift

Oracle

NoSQL

Job description

Amazon Advertising is one of the fastest-growing businesses at Amazon, helping advertisers of all sizes reach and engage customers across our properties. We are looking for a Business Intelligence Engineer to join the analytics team supporting our Advertiser Experience organization.

Our team is committed to delivering insights on the advertiser experience within the advertising console. We're looking for a teammate who can deep dive into multiple areas of the business, generate dependable Weekly Business Review (WBR) reporting, and build dashboards that power regular deep dives and business reviews. Just as important, we need someone who thrives in a fast-changing environment, especially as it relates to AI. Our team is invested in using AI to accelerate our speed to insight, and we're looking for someone who consistently seeks out opportunities to improve productivity, time to insight, and scalability across the org.

If you're passionate about turning ambiguous business questions into clear, trustworthy analytics, and excited to shape how a team adopts AI to work faster, we'd love to hear from you.

Key job responsibilities

• Build and maintain dependable WBR reports and self-service dashboards that leadership and partner teams rely on for regular reviews and deep dives.
• Deep dive into multiple areas of the advertiser experience to surface actionable insights, identify trends, and answer complex business questions.
• Design, develop, and optimize data pipelines, data models, and datasets that are accurate, scalable, and easy to consume.
• Partner with product managers, analysts, and business stakeholders to define metrics, translate requirements into analytical solutions, and drive decisions with data.
• Identify and implement opportunities to apply AI and automation to reduce time to insight and improve team productivity and scale.
• Establish and uphold data quality, documentation, and reporting standards so insights are trustworthy and repeatable.

A day in the life

You might start your day validating the numbers behind this week's WBR, then jump into a deep dive on a shift in an advertiser experience metric that leadership flagged. In the afternoon, you could be building a new dashboard for an upcoming business review, pairing with an analyst to define a new metric, or prototyping an AI-assisted workflow that cuts a recurring analysis from hours to minutes. You'll balance recurring reporting commitments with exploratory analysis, always looking for ways to make the team faster and more scalable.

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
• 1+ years of processing large, multi-dimensional datasets from multiple sources experience
• 1+ years of performing statistical analysis experience
• 1+ years of developing automated reporting experience
• 3+ years of in the job offered or a related occupation experience
• 1+ years of using SQL, ETL (Extract, Transform, Load), or Oracle experience
• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or a related field
• Experience with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
• Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
• Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets

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.

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 cove