Business Intelligence Engineer II, WW Ops Finance S&A
DESCRIPTION
Would you like to be part of team driving data strategies for the one of the largest delivery services in the world and helping improve delivery experience for billions of Amazon customers worldwide? Come join us!
Key job responsibilities
- Interact with business customers, gather requirements and deliver accurate, easy to use and scalable Business Intelligence solutions such as MAWS (Datanet, Cradle, EC2, etc), NAWS (Glue, Redshift Serverless, S3 etc), Quicksight/Quicksight Q, RStudio Connect Apps and other Amazon proprietary BI tools
- Build ETL, data pipeline jobs, appropriate aggregations, and automated delivery in SQL, Python/R, shell script.
- Design data models on varied database platforms like Redshift, MySQL or object based data stores.
- Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.
- Apply your deep analytic and business intelligence skill to extract meaningful insight and learning from large and complicated data set. Not afraid to deep dive in big data.
A day in the life
Our team is seeking an experienced Business Intelligence Engineer with excellent data engineering skills along with scripting and analytical abilities. Within this role you will have unique opportunities to work alongside engineers, product managers, data scientists, program managers and finance leaders to help build next gen analytics and data driven reporting supported via one of the largest finance data warehouses and/or datalake. You will be helping scale the supply chain cost allocation/analytics which spans across multiple geographies of North America and Europe with a focus in EU. You will work closely with product managers to design and implement new cost allocation strategies, work with engineers across the transportation network to assess impact of new program rollouts & help build operational and anomaly detection reporting solutions. Amazon has a culture of being builders and you will get to use the latest technology stack offered via AWS and internal amazon tools to help scale big and fast.
The ideal candidate is a motivated self-starter that can work independently in a fast paced, ambiguous environment with limited supervision. You must be a fast learner who can quickly absorb the nuances of Amazon's transportation services. You need to be analytical in your decision making, with a demonstrated ability to drive issues to completion. You need to be able to convey your ideas via clear and concise verbal and written communications.
About the team
WW Ops Finance S&A (Standardization and Automation) is the central Data and BI team serving the Amazon supply chain and transportation finance organization. Our BI team owns multiple data assets , such as Hydra, that are keys to initiatives to drive supply chain optimization (eg. regionalization) and improve end-to-end Cost to Serve, which were both mentioned in Andy Jassy’s 2023 Letter to Shareholder (https://www.aboutamazon.com/news/company-news/amazon-ceo-andy-jassy-2023-letter-to-shareholders).
BASIC QUALIFICATIONS
- Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field
- Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
- 3+ years experience with data visualization using Tableau, Quicksight, or similar tools
- 3+ years experience with data modeling, warehousing and building ETL pipelines
- 3+ years experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
PREFERRED QUALIFICATIONS
- Master's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field
- Experience with AWS solutions such as EC2, EMR, Glue, S3, Lambda and Redshift
- Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
Amazon is an equal opportunities employer. We believe passionately that employing a diverse workforce is central to our success. We make recruiting decisions based on your experience and skills. We value your passion to discover, invent, simplify and build. Protecting your privacy and the security of your data is a longstanding top priority for Amazon. Please consult our Privacy Notice (https://www.amazon.jobs/en/privacy_page) to know more about how we collect, use and transfer the personal data of our candidates.