Business Intelligence Engineer, Automotive - job 2 of 2

DescriptionWe're on a journey to build something new! Come join our team and build new discovery and shopping products that connect customers with their vehicle of choice. We're looking for a talented Business Intelligence Engineer (BIE) to join the fast growing team.This high-visibility role will be responsible for supporting local data management, report creation, and strategic analytic needs for our day to day operation and decision making.A successful candidate will be a self-starter, comfortable with ambiguity, and be able to create and maintain automated processes efficiently. They will set the vision, define the roadmap, and work alongside stakeholders across organizations to deliver results. They know and love working with business intelligence tools, can model multidimensional datasets, and can collaborate effectively with business and tech leaders to answer key business questions in a fraction of the time that it takes their peers. This role will have an immediate and lasting impact on both internal and external customers, and provides a unique opportunity to impact Amazon’s Advertising and Retail business.Key job responsibilities• Interface with business customers, gathering requirements and delivering complete BI solutions.• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using SQL (Redshift, Oracle) and ability to use a major programming and/or scripting language to process data for modeling.• Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.• Investigate and implement new big data technologies to provide automatic resolutions to address business needs.A day in the life• This role supports the Ads Auto Store finance and business leadership teams to drive informed decision making.• You will support the Ads Auto Store with robust data needs that span various business domains which are all related to a new line of business for Amazon• Our team supports multiple reporting mechanisms, including development of systems on AWS, micro services, and pipelinesAbout The TeamThis is a critical role for a new team with a vision to create innovative automotive discovery and shopping experiences on Amazon, providing customers better convenience and more selection.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 modelingPreferred 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 datasetsAmazon 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.Company - Amazon.com Services LLCJob ID: A2697581