Business Intelligence Engineer, Amazon Ads Product and Technology - Creative X

- 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 using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Excellent written and verbal communication with technical and non-technical stakeholders
- 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 https://www.amazon.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 https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.
Amazon Advertising operates at the intersection of eCommerce and advertising, offering a rich array of advertising solutions with the goal of helping our customers find and discover anything they want to buy. We help advertisers reach Amazon customers on Amazon owned and operated sites, other high quality sites across the web, and on millions of Fire TVs, tablets, and mobile devices. We start with the customer and work backwards in everything we do, including advertising. If you’re interested in joining a world-class advertising team with a relentless focus on the customer, you’ve come to the right place!
Smart TVs and Streaming Media Players are everywhere. Our goal at Video Advertising is to create a better user experience on these devices while helping advertisers reach their target audience at scale. Our services have differentiated assets in our consumer & audience insights and exclusive content which position us well for the future. We are looking for or a motivated Data Engineer with strong database, analytical skills and big data technology experience to to help foster nascent ideas into scalable products and launch them on a variety of streaming platforms.
A successful candidate will have a passion for data and analytics, knows and loves working with BI tools, is comfortable accessing and working with Big data from multiple sources, and can partner with internal stakeholders to help drive the business. They will have a deep knowledge of business intelligence solutions, possess excellent statistical and analytical abilities, and have the ability to work with technology, product development, and business teams. They will be a self-starter comfortable with ambiguity, with strong attention to detail, an ability to work in a fast-paced and ever-changing environment, and driven by a desire to innovate.

Key job responsibilities
* Partner with Product team to understand the business requirements and implement solutions to support product plans.
* Design, develop and maintain scalable, automated, user-friendly systems, reports, and dashboards enabling stakeholders to manage the business and make effective decisions.
* Implement training and documentation solutions that enables stakeholders to get the most out of our self-serve analytics tools.
* Develop and support the analytical technologies that give our customers timely, flexible and structured access to their data.
* Defining, developing and maintaining critical business and operational reports reviewed on a weekly, monthly, quarterly, and annual basis
* Analysis of historical data to extract meaningful insights from large and complex data sets to identify trends and support decision making, including written and verbal presentation of results and recommendations
* Collaborating with software development teams to implement analytics systems and data structures to support large-scale data analysis and delivery of machine learning models
* Understanding of Amazon’s data resources, which to use, how, and when
* Conduct ad hoc data analysis and data quality investigations.
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 using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Excellent written and verbal communication with technical and non-technical stakeholders;
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