Business Intelligence Engineer III, ORBIT - Capacity Planning BI

Amazon.com; Austin (TX); On-site; USD 130,000 - 176,000; Full time

Job summary

Amazon Inc. is seeking a highly analytical Business Intelligence Engineer III for the ORBIT Capacity Planning BI team in Austin, TX.

You will retrieve, integrate, visualize and present critical data to improve the efficiency of the delivery network and enable scalable, data-driven decisions across the Last Mile operations. You will partner with data engineers, software engineers and business stakeholders to prioritize BI development, lead end-to-end solutions, and drive insights that optimize

Qualifications

• 10+ years of professional or military experience.
• 5+ years of SQL experience.
• 1+ years of SQL, ETL or Oracle experience.
• 1+ years of processing large, multi-dimensional datasets from multiple sources experience.
• 1+ years of performing statistical analysis experience.
• 1+ years of developing automated reporting experience.
• 5+ years of as a Data Analyst, Data Engineer, Business Intelligence Analyst, or a related occupation experience.
• 1+ years of using SQL, ETL (Extract, Transform, Load), or Oracle experience.
• Experience programming to extract, transform and clean large (multi-TB) data sets.
• Experience with theory and practice of design of experiments and statistical analysis of results.
• Experience with AWS technologies.
• Experience in scripting for automation (e.g. Python) and advanced SQL skills.
• Experience with theory and practice of information retrieval, data science, machine learning and data mining

Responsibilities

• Partner with internal stakeholders across multiple teams, gathering requirements and delivering end to end solutions.
• Partner with Data Engineering and Software Development Engineers to prioritize and define AMZL data and BI development needs.
• Work with in-house scientists, global supply chain, transportation and logistics teams to identify new BI capabilities and projects.
• Lead and develop a team of Business Intelligence Engineers and Business Analysts.
• Conduct deep dive investigations into operations execution and business problems, identify opportunities, and lead or support implementation (role varies by opportunity).
• Analyze and visualize large scale geo-spatial logistics and transaction data to articulate user behavior or delivery process problems, and output solid analysis report with recommendation.
• Serve as liaison between the WW Planning and Analytics team and the operations business teams to achieve the goal of providing actionable insights into current delivery performance, and ad hoc investigations into future improvements or innovations. This will require data gathering and manipulation, synthesis and modelling, problem solving, and communication of insights and recommendations.
• Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting

Skills

SQL

Python

Statistical analysis

Automation scripting

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, Statistics, Economics, or related field

Tools

AWS

Oracle

ETL

SQL

Job description

Business Intelligence Engineer III, ORBIT - Capacity Planning BI

Job ID: 10581270 | Amazon.com Services LLC

Business Intelligence - Amazon Logistics:

Have you ever ordered a product on Amazon and when that box with the smile arrived you wondered how it got to you so fast? Have you wondered where it came from and how much it cost Amazon to deliver it to you? If so, the WW Amazon Logistics, Last Mile team is for you. We manage the delivery of tens of millions of products every week to Amazon’s customers, achieving on‑time delivery in a cost-effective manner to deliver a smile for our customers.

Amazon Logistics is looking for a customer focused, analytically and technically skilled Business Intelligence Engineer to drive effective performance measurement and management, innovation and execution in last mile delivery.

The successful candidate will be able to effectively retrieve, integrate, visualize and present critical data to improve the efficiency of the package delivery network, and enable efficient management of a large global logistics system. This individual will work with technical and business teams to optimize planning, execution, process improvement and track progress against goals. This role requires an individual with excellent analytical abilities as well as outstanding business acumen and comfort with technical teams and systems. The successful candidate will be a self‑starter comfortable with ambiguity, with strong attention to detail, and enjoy working with large scale of data.

Core Job Responsibilities include:

• Partner with internal stakeholders across multiple teams, gathering requirements and delivering complete solutions
• Partner with Data Engineering and Software Development Engineers to prioritize and define AMZL data and BI development needs
• Work with in‑house scientists, global supply chain, transportation and logistics teams to identify new BI capabilities and projects
• Conduct deep dive investigations into operations execution and business problems, identify opportunities, and lead or support implementation (role varies by opportunity).
• Analyse and visualize large scale geo‑spatial logistics and transaction data to determine user behavior or delivery process problems, and output solid analysis report with recommendation.
• Serve as liaison between the WW Planning and Analytics team and the operations business teams to achieve the goal of providing actionable insights into current delivery performance, and ad hoc investigations into future improvements or innovations. This will require data gathering and manipulation, synthesis and modeling, problem solving, and communication of insights and recommendations.
• Develop queries and visualizations for ad‑hoc requests and projects, as well as ongoing reporting.

Key job responsibilities

• Partner with internal stakeholders across multiple teams, gathering requirements and delivering end to end solutions
• Partner with Data Engineering and Software Development Engineers to prioritize and define AMZL data and BI development needs
• Work with in‑house scientists, global supply chain, transportation and logistics teams to identify new BI capabilities and projects
• Lead and develop a team of Business Intelligence Engineers and Business Analysts
• Conduct deep dive investigations into operations execution and business problems, identify opportunities, and lead or support implementation (role varies by opportunity)
• Analyze and visualize large scale geo‑spatial logistics and transaction data to articulate user behavior or delivery process problems, and output solid analysis report with recommendation.
• Serve as liaison between the WW Planning and Analytics team and the operations business teams to achieve the goal of providing actionable insights into current delivery performance, and ad hoc investigations into future improvements or innovations. This will require data gathering and manipulation, synthesis and modelling, problem solving, and communication of insights and recommendations
• Develop queries and visualizations for ad‑hoc requests and projects, as well as ongoing reporting

About the team

This role is within broader Amazon Logistics (AMZL) ORBIT (Operations Reporting, Business Intelligence, and Technology) team working under the WW Capacity Planning BIA team.

The WW Capacity Planning BI & Analytics team partners with the business and BI teams across AMZL Business to build analytical products and generate business insights that help these planning teams produce accurate and optimal capacity within the intra‑week, short‑term, and mid‑term planning horizons.

Basic Qualifications

• 10+ years of professional or military experience
• 5+ years of SQL experience
• 1+ years of SQL, ETL or Oracle experience
• 1+ years of processing large, multi‑dimensional datasets from multiple sources experience
• 1+ years of performing statistical analysis experience
• 1+ years of developing automated reporting experience
• 5+ years of as a Data Analyst, Data Engineer, Business Intelligence Analyst, or a related occupation experience
• 1+ years of using SQL, ETL (Extract, Transform, Load), or Oracle experience
• Bachelor's degree or foreign equivalent in Computer Science, Engineering, Mathematics, Statistics, Economics, or a related field
• Experience programming to extract, transform and clean large (multi‑TB) data sets
• Experience with theory and practice of design of experiments and statistical analysis of results
• Experience with AWS technologies
• Experience in scripting for automation (e.g. Python) and advanced SQL skills.
• Experience with theory and practice of information retrieval, data science, machine learning and data mining

Preferred Qualifications

• Experience working directly with business stakeholders to translate between data and business needs
• Experience managing, analyzing and communicating results to senior leadership

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 .

USA, TX, Austin - 130,400.00 - 176,300.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. Veterans, military spouses, and people with disabilities are encouraged to apply.