Business Intelligence Engineer II, TMAT Network Design Modeling

Amazon.com Services LLC; Santa Clara (CA); On-site; USD 110,000 - 160,000; Full time

Job summary

Amazon.com Services LLC is seeking a Business Intelligence Engineer II to design and build scalable data solutions that power performance insights and informed decision-making. You will own end-to-end analytics from data modeling to visualization and stakeholder communication.

You will lead network design modeling capabilities, collaborate across teams, and apply statistical methods to address strategic questions at scale.

Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. 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
• 3+ years of in the job offered 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 with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• Experience in Statistical Analysis packages such as R, SAS and Matlab
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

Responsibilities

• Run and Improve Network Design Models working with Technical Product Managers and Applied Scientists and analyze the modeled outputs
• Design, build, and maintain mid-to-large-scale BI solutions including data models, ETL pipelines, and curated datasets that serve as trusted sources of truth for business reporting and decision-making.
• Develop intuitive dashboards, reports, and visualizations using industry analytics tools to surface key metrics and enable stakeholders to self-serve insights where appropriate.
• Collaborate with cross-functional partners - including data engineers, data scientists, product managers, and business teams - to refine ambiguous problem statements into specific, measurable deliverables that address real business needs.
• Apply statistical methods and analytical techniques to complex business questions, clearly communicating findings, assumptions, and limitations to both technical and non-technical audiences.
• Improve data quality and operational excellence by documenting data lineage, maintaining clear design documentation, and mentoring peers on how your team's BI solutions are constructed and consumed.

Skills

SQL

ETL

Python

Data visualization

Statistical analysis

Big data processing

Data modeling

Education

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

Tools

Tableau

Quicksight

Redshift

Oracle

R

SAS

Matlab

Job description

Are you passionate about turning complex data into clear, actionable insights that drive meaningful business decisions? As a Business Intelligence Engineer II at Amazon, you will design and build scalable data solutions that power how teams understand performance, identify opportunities, and make informed choices.

At Amazon, we work every day to be the most Customer-centric company on earth. To deliver on this promise, the TMAT Network Design Modeling team continuously optimizes Amazon's transportation network to balance speed, cost, resilience, and sustainability. The TMAT Core Design Modeling team is seeking a BIE II who will own Amazon's core network design modeling capabilities and lead the transformation toward "always on" modeling that drives proactive network optimization and strategic decision-making.

In this role, you will own end-to-end analytics - from data modeling and pipeline development to visualization and stakeholder communication. You will tackle loosely defined problems, apply analytical rigor, and deliver high-quality data products that directly influence strategy. If you thrive on making sense of ambiguity and want your work to have real impact at scale, we want to hear from you.

Key job responsibilities

• Run and Improve Network Design Models working with Technical Product Managers and Applied Scientists and analyze the modeled outputs
• Design, build, and maintain mid-to-large-scale BI solutions including data models, ETL pipelines, and curated datasets that serve as trusted sources of truth for business reporting and decision-making.
• Develop intuitive dashboards, reports, and visualizations using industry analytics tools to surface key metrics and enable stakeholders to self-serve insights where appropriate.
• Collaborate with cross-functional partners - including data engineers, data scientists, product managers, and business teams - to refine ambiguous problem statements into specific, measurable deliverables that address real business needs.
• Apply statistical methods and analytical techniques to complex business questions, clearly communicating findings, assumptions, and limitations to both technical and non-technical audiences.
• Improve data quality and operational excellence by documenting data lineage, maintaining clear design documentation, and mentoring peers on how your team's BI solutions are constructed and consumed.

About the team

Our team is focused on enabling smarter, faster decisions through reliable data and thoughtful analytics. We build the foundational BI infrastructure that teams across our organization depend on to measure what matters and act with confidence. We value collaboration, intellectual curiosity, and a commitment to getting the details right. As we continue to grow, we are investing in new tools and approaches to expand the reach and impact of our data products - and you will play a key role in shaping that future.

Basic Qualifications:

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. 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
• 3+ years of in the job offered 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 with data visualization using Tableau, Quicksight, or similar tools
• Experience with data modeling, warehousing and building ETL pipelines
• Experience in Statistical Analysis packages such as R, SAS and Matlab
• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling

Preferred Qualifications:

• Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift
• Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets

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

Los Angeles County applicants:

Job duties for this position include: work safely and cooperatively with other employees, supervisors, and staff; adhere to standards of excellence despite stressful conditions; communicate effectively and respectfully with employees, supervisors, and staff to ensure exceptional customer service; and follow all federal, state, and local laws and Company policies. Criminal history may have a direct, adverse, and negative relationship with some of the material job duties of this position. These include the duties and responsibilities listed above, as well as the abilities to adhere to company policies, exercise sound judgment, effectively manage stress and