Business Intelligence Engineer, Ad Sales Finance Analytics

Amazon.com, Inc.
Seattle, WA, United States
2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience required
1 year minimum
Compensation
$99,500.0 - $185,000.0
Working hours
Regular working hours
Job source

Tech stack

Amazon Elastic Compute Cloud Amazon S3 Data Analysis Databases Extract Transform Load (ETL) Data Mining Data Structures Data Visualization Data Warehousing Amazon DynamoDB R (Programming Language) Python (Programming Language)
+9 more
MATLAB NoSQL Oracle (Applications) SAS (Software) SQL Databases Tableau (Software) Data Processing Scripting Amazon Redshift

Job description

Amazon seeks a business intelligence engineer to be a key partner for the Amazon IX Advertising Sales business, with a range of products offerings for advertisers. We’re looking for a top technical and analytical mind capable of extracting value out of our large and disparate data sets. You will influence the direction of the business by leveraging our data to deliver insights that drive decisions, evolution of our products and the way they fit into Amazon’s ecosystem. Additionally, you’ll help streamline and simplify the metric reporting needs for our operating cadences such as daily, weekly and monthly business reviews. Our ideal candidate is a self-starter, comfortable working through ambiguity, conceptualizing and leading complex initiatives from end to end, and has an entrepreneurial spirit. In addition to working with many stakeholders internally and externally, this role requires working through ambiguity, demonstrating good judgment under pressure and the ability to thrive in a fast-paced, dynamic environment., Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions - Own the forecasting model for IX countries and enhance the existing model to align with sales calls while minimizing forecasting errors. - Make recommendations for new metrics, techniques, and strategies to improve team performance and measurement in the future - Define the data elements and data structure that our team should leverage to enable analytical and reporting capabilities for our business development team - Design and influence operational best practices for reporting and analytics to enable the team to scale - Prepare and deliver business reviews to the senior management team regarding progress and roadblocks - Work with engineering and the data warehouse to enable the appropriate capture and storage of key data points - Enable effective decision making by retrieving and aggregating data from multiple sources and compiling it into a digestible and actionable format - Participate in strategic & tactical planning discussions

A day in the life Your day will be a dynamic blend of data exploration, strategic problem-solving, and cross-functional collaboration. You’ll dive deep into complex data landscapes, crafting visualizations and models that reveal hidden patterns and opportunities for Amazon’s advertising platforms.

Requirements

Do you have experience in Statistics?, * 4+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience

  • 1+ years of SQL, ETL or Oracle experience
  • 4+ 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
  • Experience with data visualization using Tableau, Quicksight, or similar tools
  • Experience with data modeling, warehousing and building ETL pipelines
  • Experience in Statistical Analysis packages such as R, SAS and Matlab
  • Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

PREFERRED QUALIFICATIONS

  • 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

Benefits & conditions

3.53.5 out of 5 stars Seattle, WA $99,500 - $185,000 a year - Full-time, Pulled from the full job description

  • AD&D insurance
  • Parental leave
  • Health insurance
  • 401(k) matching
  • Paid time off
  • Vision insurance
  • Dental insurance, 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, NY, New York - 109,500.00 - 185,000.00 USD annually USA, WA, SEATTLE - 99,500.00 - 160,000.00 USD annually

About the company

The Ads Sales Finance team is a global group of 30+ Data and BI engineers who partner with finance managers, sales, and product stakeholders to build the forecasting, reporting, and analytics backbone for Amazon Ads. Our mission is to deliver scalable datamarts, models, and dashboards that standardize reporting across regions, minimize forecasting error, and provide leadership with the insights needed to make confident, data-driven decisions. As part of the team, you will collaborate across functions to solve complex problems such as handling massive data volumes, evolving product hierarchies, and aligning multiple upstream and downstream systems-directly impacting how Ads revenue is tracked, forecasted, and managed at scale.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:42 min

Combining technical skills with strong business communication

Lukas Kölbl · LIVE

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

2:40 min

Motivations for transitioning legacy MATLAB repositories to Python

Michael Niebisch Michael Niebisch · WWC 2024

3:43 min

The enduring legacy of the amazon S3 storage API

Chris Heilmann +3 · LIVE

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

3:16 min

Terminology differences between relational and NoSQL databases

Tim Faulkes · LIVE

Videos

See all

Related articles

See all