Business Intelligence Engineer II, WW Ops Finance S&A

DESCRIPTION

Would you like to be part of a team driving data strategies for one of the largest delivery services in the world and helping improve the delivery experience for billions of Amazon customers worldwide? Come join us!

Key job responsibilities

1. 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.
2. Build ETL, data pipeline jobs, appropriate aggregations, and automated delivery in SQL, Python/R, shell script.
3. Design data models on varied database platforms like Redshift, MySQL or object based data stores.
4. Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.
5. Apply your deep analytic and business intelligence skill to extract meaningful insight and learning from large and complicated data sets. 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 data lake. 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 the 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 the impact of new program rollouts, and 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 (e.g., regionalization) and improve end-to-end Cost to Serve, which were both mentioned in Andy Jassy's 2023 Letter to Shareholder.

BASIC QUALIFICATIONS

1. Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field.
2. Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business.
3. 3+ years experience with data visualization using Tableau, Quicksight, or similar tools.
4. 3+ years experience with data modeling, warehousing, and building ETL pipelines.
5. 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

1. Master's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field.
2. Experience with AWS solutions such as EC2, EMR, Glue, S3, Lambda, and Redshift.
3. 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 to know more about how we collect, use and transfer the personal data of our candidates.

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 our accommodations page.