Business Intelligence Engineer, Ad Sales Finance Analytics
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.Key job responsibilities- 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 discussionsA day in the lifeYour 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.About the teamThe 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.
Locations
- United States, WA, Seattle, Seattle, WA, United States
- United States, NY, New York, New York, NY, United States
Salary
Salary not disclosed
Estimated Salary Rangehigh confidence
150,000 - 220,000 USD / yearly
Source: ai estimated
* This is an estimated range based on market data and may vary based on experience and qualifications.
Skills Required
- - 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experienceintermediate
- - Experience with data visualization using Tableau, Quicksight, or similar toolsintermediate
- - Experience with data modeling, warehousing and building ETL pipelinesintermediate
- - Experience writing complex SQL queriesintermediate
- - Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modelingintermediate
Required Qualifications
- - 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience (experience, 3 years)
- - Experience with data visualization using Tableau, Quicksight, or similar tools (experience)
- - Experience with data modeling, warehousing and building ETL pipelines (experience)
- - Experience writing complex SQL queries (experience)
- - Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling (experience)
- - Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field (degree in bi)
Preferred Qualifications
- - Experience in Statistical Analysis packages such as R, SAS and Matlab (experience)
- - Experience with forecasting and statistical analysis (experience)
- - Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift (experience)
- Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site. (experience)
Responsibilities
- - 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
Documents
Tags & Categories
Business Intelligence Engineer, Ad Sales Finance Analytics
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.Key job responsibilities- 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 discussionsA day in the lifeYour 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.About the teamThe 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.
Locations
- United States, WA, Seattle, Seattle, WA, United States
- United States, NY, New York, New York, NY, United States
Salary
Salary not disclosed
Estimated Salary Rangehigh confidence
150,000 - 220,000 USD / yearly
Source: ai estimated
* This is an estimated range based on market data and may vary based on experience and qualifications.
Skills Required
- - 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experienceintermediate
- - Experience with data visualization using Tableau, Quicksight, or similar toolsintermediate
- - Experience with data modeling, warehousing and building ETL pipelinesintermediate
- - Experience writing complex SQL queriesintermediate
- - Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modelingintermediate
Required Qualifications
- - 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience (experience, 3 years)
- - Experience with data visualization using Tableau, Quicksight, or similar tools (experience)
- - Experience with data modeling, warehousing and building ETL pipelines (experience)
- - Experience writing complex SQL queries (experience)
- - Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling (experience)
- - Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field (degree in bi)
Preferred Qualifications
- - Experience in Statistical Analysis packages such as R, SAS and Matlab (experience)
- - Experience with forecasting and statistical analysis (experience)
- - Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift (experience)
- Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site. (experience)
Responsibilities
- - 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