Business Intelligence Engineer, Ad Product Finance_

Seattle

Description

Amazon Advertising is looking for a motivated Business Intelligence Engineer with strong technological, analytical, and business intelligence skill sets and experience to join the Advertising Product Finance team supporting the Audio and Devices advertising businesses.

This position will be responsible to develop and managing large, complex datasets that are both scalable and easily accessible. This candidate will be comfortable with ambiguity and a self-starter who seeks requirements for major business initiatives, and will be an essential team member that can articulate insights using the data.

The candidate should enjoy diving into data, automating or building new data-driven reporting mechanisms, and recommending or implementing solutions to facilitate financial and business metrics reporting.

As you further your career as a Business Intelligence Engineer at Amazon, you will focus on improving corporate reporting frameworks and data visualization. You will analyze performance data, discover and solve real-world problems and build metrics and business cases to improve decision making. You can expect to leverage your analytical skills and have full ownership of your projects.

Key job responsibilities

As a Business Intelligence Engineer, you create insightful recommendations by applying your data science, analytical and business skills to complex problems. You use will use insights to challenge, guide and illuminate our product strategy, which directly influences what we build for customers. Data-driven decision-making is at the core of Amazon’s culture and this role will have a direct impact on the decisions and strategy of the Finance Data Analytics team.

- Design, implement, and support a platform providing secured access to large datasets

- Interface with Business, Finance and Accounting customers, gathering requirements and delivering end-to-end BI solutions

- Model data and metadata to support ad hoc and pre-built reporting

- Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions

- Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation

- Tune application and query performance using profiling tools and SQL

- Analyze and solve problems at their root, stepping back to understand the broader context

- Learn and understand a broad range of Amazon’s data resources and know when, how, and which to use

- Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for datasets

- Triage many courses of action in a high-ambiguity environment, making use of both quantitative analysis and business judgment

A day in the life

- Work with stakeholders to understand and design solutions on major projects

- Seek opportunities to streamline existing Finance manual process and automate using BI technology

- Attend team standup to go over existing development, blockers and help troubleshoot issues

- Continue to adopt new technologies that benefits business. Examples: linear regression model, serverless automation, big data processing and system integrations.

About the team

The APM advertising product finance team directly supports Amazon Device, Audio, and Video advertising demand-side platform (DSP) product teams. We also act as internal partners to support and drive our ad sales and supply teams. Our focus is to accelerate top-line revenue and improve profitability by evaluating overall ad supply monetization and utilization, product feature or sales package adoption, campaign performance, and other various product drivers of growth.

Basic Qualifications

- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience

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

- Experience with data modeling, warehousing and building ETL pipelines

- Experience writing complex SQL queries

- 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

Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit mazon.jobs/en/disability/us.

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 boutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.