Business Intelligence Engineer II, Intelligence & Industrialization

Business Intelligence Engineer II, Intelligence & Industrialization

Job ID: 2784164 | Amazon.com Services LLC

If you are passionate about creating solutions and solving tomorrow’s problems today, using data to uncover actionable insights, and are a self-starter who is comfortable collaborating with internal & external stakeholders, you are the person we are looking for!

Intelligence & Industrialization (I&I) is a functional team that provides data analytics, business intelligence, and software configuration support to business users within Global Supply Chain and Transportation Procurement (GSCTP) and Amazon Customs & Trade (ACT).

GSCTP is an organization under worldwide operations that develops and maintains strategic relationships with third party (3P) supply chain and transportation service providers. GSCTP is working towards Amazon's Climate Pledge goal of being net carbon zero by 2040. For this, we are seeking a Business Intelligence Engineer to lead the foundational work to collect, measure, manage, and reduce carbon emissions from third party transport suppliers. The BIE will partner with other Data teams on setting up Amazon's first automated and scalable solution to ingest sustainability data (emissions) from external vendors. Along with that, the person will play a key role in developing end-to-end BI solutions to support contract negotiations, business reviews, performance management, and process improvements.

Key job responsibilities

1. Develop robust data pipelines to ingest sustainability data (emissions, fuel usage, etc.) from third-party carrier APIs, SFTP connections, and other external sources. Leverage AWS' Sustainability Services to accelerate integration.
2. Collaborate cross-functionally to define data models, transformation requirements, and end-to-end carbon intensity metrics, ensuring data accuracy, completeness, and reliability.
3. Ensure data accuracy and business logic robustness for key business metrics.
4. Use BI tools with data visualizations to articulate compelling business cases with actionable insights and enhance BI self-service support for customers.
5. Automate repetitive data processing and reporting tasks to improve efficiency and enable scalable, self-service BI capabilities for business users.
6. Present well-researched, data-driven proposals and recommendations to senior leaders, outlining strategic opportunities to reduce the carbon footprint of Amazon's third-party transportation network.

BASIC QUALIFICATIONS

1. 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience.
2. Experience with data visualization using Tableau, Quicksight, or similar tools.
3. Experience with data modeling, warehousing and building ETL pipelines.
4. Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling.

PREFERRED QUALIFICATIONS

1. 5+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience.
2. Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets.
3. Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift.
4. If you are not sure that every qualification on the list above describes you exactly, we'd still love to hear from you! At Amazon, we value people with unique backgrounds, experiences, and skillsets. If you’re passionate about this role and want to make an impact on a global scale, please apply!

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.