Business Intelligence Engineer, Amazon Transportation

The Supply Chain Optimization Technologies (SCOT) organization, has an immediate need for a creative business intelligence engineer (BIE) with apassion for building systems that have a measurable impact. The right candidate will be innovative andtechnically versatile. You will have the opportunity to work with one of the largest and most complexwarehouses in the world to gather insights using from across Amazon.As a BIE, you should be an expert in the architecture of data warehouse solutions for the enterpriseusing multiple platforms. You should excel in the design, creation, management, and business use ofextremely large datasets. Excellent business and communication skills are required to work withbusiness analysts and data engineers to understand how best to design reporting and analytics datasystems.Key job responsibilitiesApply mining, quantitative analysis, and statistical models to understand how our customers interactwith us and identify ways to improve the customer experience and meet our goals• Build scalable solutions and self-serve platforms that will provide insights to inform business decisionmaking• Optimizing the performance of business-critical queries and dealing with ETL job-related issues• Gathering and understanding data requirements, working with the team to achieve high quality dataingestion and building systems that can process, transform, and store the data in various relational and non-relational stores• Dive deeply into technical details (e.g., key dependencies, design choices, operability, etc.) withengineering teams and drive constructive technical discussions. Extracting and combining data fromvarious heterogeneous data sources• Build and evaluate end-to-end designs for strengths and weaknesses (quality, scalability, latency,security, performance, data integrity, etc.)• Create interactive visual dashboards with Tableau and QuickSight• Write clear documentation, architecture documents and create an engineering roadmap• Exploring and learning the latest AWS technologies to provide new capabilities and increase efficiency.Members of this team will be challenged to innovate use the latest big data techniques. We are lookingfor people who are motivated by thinking big, moving fast, and exploring business insights. If you love to implement solutions to complex problems while working hard, having fun, and making history, this may be the opportunity for youA day in the lifeAmazon offers a full range of benefits that support you and eligible family members, including domestic partners and their children. Benefits can vary by location, the number of regularly scheduled hours you work, length of employment, and job status such as seasonal or temporary employment. The benefits that generally apply to regular, full-time employees include:1. Medical, Dental, and Vision Coverage2. Maternity and Parental Leave Options3. Paid Time Off (PTO)4. RRSPBASIC QUALIFICATIONS- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience- Experience with data modeling, warehousing and building ETL pipelines- Experience with data visualization using Tableau, Quicksight, or similar tools- 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 an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.Our inclusive culture empowers Amazonians to deliver the best results for our customers.