Business Intelligence Engineer II, Intelligence & Industrialization

Amazon; Tennessee; On-site; USD 95,000 - 160,000; Full time

Benefits offered by this job

Health insurance

401(k) matching

Paid time off

Parental leave

Job summary

Amazon is seeking a Business Intelligence Engineer II to support ACT metrics and dashboards. You will design scalable ETL pipelines, build data sets, and deliver dashboards for stakeholders across Operations, Product, Finance, Technology, and Leadership.

Strong SQL, Python, data modeling, and visualization skills are required. The role involves collaborating with multiple teams globally, optimizing data flows, and presenting actionable insights to guide business decisions within the GSCTP and

Qualifications

• Experience writing complex SQL queries.
• SQL to pull data from data warehouses and Python for data processing.
• Experience with data modeling, warehousing and ETL pipelines.
• Ability to develop and present recommendations of new metrics.
• Experience with data visualization tools like Tableau or QuickSight.

Responsibilities

• Partner with internal stakeholders across multiple teams, gathering requirements and delivering complete solutions.
• Conduct deep dive investigations into operations execution and business problems, identify opportunities, and lead or support implementation.
• Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.
• Collaborate with team members on reporting datasets; review and raise code reviews (PL/SQL and Python).
• Work with technology and analytics teams to support tools, automation, and dashboards.
• Communicate with and support various internal stakeholders and external audiences.

Skills

SQL

Python

Data modeling

ETL pipelines

Data visualization

Education

Master's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field

Job description

Business Intelligence Engineer II, Intelligence & Industrialization

Job ID: 10502449 | Amazon.com Services LLC

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 Global Mile - Amazon Customs & Trade (ACT).

ACT is an expanding business unit under worldwide operations for Customs Brokerage operations. Customs brokerage involves the coordination of a complex network of sellers, shippers, logistics service providers (LSP), compliance, and government authorities to facilitate clearance of goods for cross-border transportation. Timely submission of documents and coordinating with customs agents to ensure hassle free clearance of shipments is a crucial step in the logistics process to ensure on-time delivery of product to our customers.

As a BIE II, you will support analysis, improvement and creation of metrics and dashboards for ACT stakeholders. You will join a team that insists on highest engineering standards and work with internal customers at all levels of the organization – Operations, Product, Finance, Technology, and Leadership – across multiple geo's (US, EU, CN).

A successful candidate should be able to communicate effectively in working with business owners to develop and define key business questions, and build data sets that answer those questions. You should be expert at designing and implementing stable, scalable, low cost ETL pipelines and support analysis, improvement, and creation of metrics and dashboards.

Key job responsibilities

• Partner with internal stakeholders across multiple teams, gathering requirements and delivering complete solutions
• Conduct deep dive investigations into operations execution and business problems, identify opportunities, and lead or support implementation (role varies by opportunity).
• Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.
• Collaborate with team members on reporting datasets; review and raise code reviews (PL/SQL and Python); successful candidate should have experience with Amazon's internal code repositories.
• Working with technology and analytics teams to support the development of tools, automation, and dashboards.
• Communicating with and supporting various internal stakeholders and external audiences.

Basic Qualifications

• Experience writing complex SQL queries
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
• Experience with data modeling, warehousing and building ETL pipelines
• Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business
• Experience with data visualization using Tableau, Quicksight, or similar tools
• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience

Preferred Qualifications

• Experience with forecasting and statistical analysis
• Master's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field
• Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions

Amazon 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. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors including experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits .

Preferred Qualifications

• Experience with forecasting and statistical analysis
• Master's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field
• Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions

Amazon 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. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

The base salary range for this position is listed below. Your Amazon package will include sign-on payments and restricted stock units (RSUs). Final compensation will be determined based on factors include experience, qualifications, and location. Amazon also offers comprehensive benefits including health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage), 401(k) matching, paid time off, and parental leave. Learn more about our benefits at https://amazon.jobs/en/benefits .

USA, TN, Nashville - 94,600.00 - 160,000.00 USD annually

USA, VA, Arlington - 99,500.00 - 160,000.00 USD annually

USA, WA, Bellevue - 99,500.00 - 160,000.00 USD annually

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.