Description Amazon Transportation Services (ATS) is looking for an innovative, results-oriented and strategic Business Intelligence Engineer (BIE) individual who is comfortable diving into complex problems and can develop solutions to recommend business decisions. • You have a department-wide view of the analytical solutions that you build, and you consistently think in terms of automating or expanding the results company-wide. • You should be skilled in database design, conduct analytics using SQL and Python, and build lightweight tools and methods for others to replicate and scale their work. • You are comfortable dealing with large and complex data sets, and have experience building self-service dashboards and using visualization tools especially Quicksight. • You should have strong analytical and communication skills, and ability to work through ambiguous problems in a fast paced environment to develop and define key business questions and requirements. Key job responsibilities • Design, build, and maintain automated reporting, Quicksight dashboards, and analyses to enable self-service of data needs, allowing you to focus on answering hard and ambiguous problems. • Write high-quality SQL queries to retrieve and analyze data from database tables (ex. Redshift, MySQL, Oracle). • Ability to break down and solve complex problems while actively engaging with internal partners throughout the organization to meet and exceed customer service levels & transport-related KPI’s • Recognize and adopt best practices in reporting/analysis: data integrity, test design, analysis, validation, and documentation while driving scalable solutions. • Understand data resources and know how, when, and which to use (and which not to use) • Continue to move forward in the face of ambiguity and imperfect data. Find a solution around the problem that still maintains a high analytical bar. You do not suffer from “analysis paralysis”. • Ability to manage through conflict with a positive, flexible and professional attitude • Communicate analysis results and techniques, both verbally and in writing, clearly and confidently to peers and business partners. • Explain analysis results to the stakeholders through verbal and written communications. 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 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 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.