Business Intelligence Engineer

• 3+ years of experience.
• Bachelor's degree in Engineering, Statistics, Computer Science, Operations Research, Business Analytics, Information Systems or related field.
• Experience with high-volume OLTP & OLAP database systems.
• Advanced knowledge of SQL and ETL processes.
• Recent experience applying visualization tools such as Cognos, PowerBI and Tableau.
• Proven ability in understanding business processes, logical data models and relational database implementations.
• Proven track record of working on complex modular projects, and assuming a leading role in such projects.
• Highly motivated, self-driven, capable of defining own design and test scenarios.
• An ability and interest in working in a fast-paced and rapidly-changing environment.
• An excellent work ethic based on a strong desire to exceed expectations.
• Excellent interpersonal skills, including written and oral communication skills.

It’s no secret that Amazon relies on its technology to deliver millions of packages every day to its customers – on time, with low cost. The Middle Mile Transportation Technology organization builds complex software solutions that work across our vendors, warehouses and carriers to optimize both time & cost of getting the packages delivered. Our services already handle thousands of requests per second, make business decisions impacting billions of dollars a year, integrate with a network of small and large carriers, owner operators and drivers worldwide, manage business rules for millions of unique products, and improve ordering and delivery experience for millions of online shoppers. That said, this remains a fast growing business and our technical journey has only started. Our mission is to build the most efficient and optimal transportation solution on the planet, using our technology and engineering muscle as our biggest advantage. We aim to leverage cutting edge technologies in big data, machine learning, and optimization techniques, and operate high volume, low latency, and high availability services.

As a member of this collaborative team, you will have an opportunity to make an impact in Amazon Logistics and work with a group of talented program managers, product managers, research scientists, software developers, and business stakeholders to design the Amazon network of the future.

As a Business Intelligence Engineer, you will operate at the crossroads of multiple complex Amazon systems, getting global visibility of how Amazon moves inventory across our network and serves our customers. You will enable the creation of products that drive ever-greater automation, scalability and optimization of every aspect of transportation, removing cost and delivering speed of execution for our customers. The impact of your work will be global, material and remarkable. The successful candidate will be voraciously curious about Amazon’s transportation operations and how data consumed and produced by our systems can be used to improve outcomes and lower costs. You will be working in one of the world's largest and most complex data warehouse environments. You should have deep expertise in the design, creation, management, and business use of extremely large datasets. You should have excellent business and communication skills to be able to work with business owners to develop and define key business questions, and to build data sets that answer those questions. You should be expert at designing, implementing, and operating stable, scalable, low cost solutions to flow data from production systems into the data warehouse and into end-user facing applications. You should be able to work with business customers in understanding the business requirements and implementing reporting solutions. Above all you should be passionate about bringing large datasets together to answer business questions and drive change.

Responsibilities:

• Build business intelligence (BI) solutions – data sets, queries, reports, dashboards, analyses – or components of larger solutions to answer business questions with data
• Learn, publish, analyze and improve management information dashboards, operational business metrics decks and key performance indicators.
• Improve tools, processes, scale existing solutions, create new solutions as required based on stakeholder needs.
• Design, develop and establish KPIs to provide strategic insights to drive growth and performance
• Troubleshoot data, analyses, and code, research root causes, propose solutions, and take ownership in next steps for their resolutions
• Ability to perform/own reoccurring and ad-hoc business intelligence projects
• Pull and report data from numerous databases (using Excel, SQL and/or other data management systems) and proven capability to dive deep and utilize known research and problem solving techniques
• Communicate complex insights to stakeholders, both verbally and in writing
• Master’s Degree in Computer Science, Analytics or related field.
• Experience leading cross-functional projects with business and technical teams.
• Experience with unstructure data manipulation, processing, and storage.
• Experience with AWS services (Redshift, S3, EC2, Lambda, SNS/SQS, RDS, Aurora) preferred.
• Experience with forecasting and statistical analysis.
• High attention to detail and proven ability to manage multiple, competing priorities simultaneously.
• Experience with Microsoft BI technologies, e.g. SQL Server, SSIS, SSRS.
• Experience with at least one scripting language, i.e. Python, C#, Java etc.
• Ability to work in a supportive and diverse team.

Amazon is an Equal Opportunity-Affirmative Action Employer – Minority / Female / Disability / Veteran / Gender Identity / Sexual Orientation.

We believe passionately that employing a diverse workforce is central to our success and we make recruiting decisions based on your experience and skills. We welcome applications from all members of society irrespective of age, gender, disability, sexual orientation, race, religion or belief.