Business Intelligence Engineer, Supply Chain Business Insights

Amazon Inc.; México; Hybrid; MXN 900.000 - 1.300.000; Vollzeit

Zusammenfassung

Amazon is seeking a Business Intelligence Engineer for the MX Supply Chain BI team in Mexico City. You will build scalable data pipelines, analytics, and cloud-native solutions to turn raw data into trusted insights for daily operations across the Supply Chain.

You will work with large datasets on AWS, write production-grade Python code, and collaborate with stakeholders across multiple functional areas to deliver actionable metrics and AI-ready data lakehouse capabilities.

Qualifikationen

• 3+ years analyzing data with data warehouses and big data tools.
• Proficient in Python for data processing and modeling.
• Strong SQL skills to pull data from databases and warehouses.
• Experience building ETL pipelines and data models.
• Bachelor's degree or equivalent Amazon experience in data/tech fields.
• Experience with visualization tools (Tableau/Quicksight).
• Experience with AI/ML technologies and cloud-based architectures.

Aufgaben

• Design, develop, and maintain scalable ETL/big-data pipelines on AWS.
• Write production-grade Python for data transformation and ML workflows.
• Create high-quality datasets with metadata for stakeholders.
• Deploy cloud-native data solutions using infrastructure-as-code.
• Collaborate with cross-functional teams to translate business questions into analytics.
• Contribute to an AI-ready data lakehouse platform with governance.
• Write and optimize SQL/Spark queries for reporting and metrics.
• Follow engineering best practices including reviews, tests, monitoring, and docs.
• Identify opportunities to improve data availability and automate reporting.
• Support GenAI/ML initiatives by preparing governed data for AI workflows.

Kenntnisse

Python

SQL

Data modeling

ETL pipelines

Big data

AWS

Ausbildung

Bachelor's degree or higher

Tools

Redshift

Oracle

NoSQL

Tableau

Quicksight

Jobbeschreibung

Business Intelligence Engineer, Supply Chain Business Insights

Help shape the data foundation behind one of Amazon's fastest-growing supply chain networks — and put AI in the hands of the people who move millions of packages across Mexico every day. This is your chance to build the pipelines, analytics, and cloud-native solutions that turn raw data into trusted, accurate intelligence for an organization at the forefront of GenAI adoption.

As a Business Intelligence Engineer on the MX Supply Chain BI team, you will design, build, and maintain scalable data pipelines, reporting solutions, and analytical tools that power decisions across Mexico's Supply Chain — from network planning and capacity to last mile operations. You will work with large-scale datasets on AWS, write production-grade Python code, deploy cloud-based solutions, and partner with stakeholders across 10 functional areas to deliver insights that drive operational performance. You will contribute to the team's AI-ready data lakehouse platform and help embed GenAI and ML capabilities into the analytics portfolio.

Key job responsibilities

• Design, develop, and maintain scalable ETL/big-data pipelines using AWS services following medallion-architecture best practices


• Write production-grade Python code for data transformation, automation, statistical analysis, and integration with AI/ML workflows


• Build high quality datasets with robust metadata for agents to consume and give insights to our stakeholders.


• Deploy and manage cloud-native data solutions on AWS through infrastructure-as-code based deployments.


• Collaborate with stakeholders across Supply Chain functional areas (Topology, S&OP, Network Planning, Middle Mile, Last Mile, Sort Centers, Operations) to translate business questions into analytical solutions


• Contribute to the team's AI-ready data lakehouse platform (Apache Iceberg on serverless AWS), ensuring data quality, governance, and single-source-of-truth standards


• Write and optimize complex queries on SQL, Spark SQL and PySpark across large-scale datasets to support reporting, ad-hoc analysis, and metric development


• Establish and follow engineering best practices including code reviews, testing, monitoring, documentation, and logging best practices.


• Proactively identify opportunities to improve data availability, reduce time-to-insight, and automate manual reporting processes


• Support the team's GenAI/ML initiatives by preparing governed, high-quality datasets and contributing to data products that enable agentic and self-service AI workflows

A day in the life

You start your morning reviewing pipeline health dashboards and resolving any data quality alerts from overnight ETL runs. By mid-morning, you're deep in Python — building a new data transformation module. After a quick stand-up with your peers, you jump into a working session with a Last Mile stakeholder who needs a new metric added to their operational dashboard; you scope the requirement, write the code and push for your peers to review before lunch.

You wrap up the day by prototyping a data integration that will expose a new dataset to the team's GenAI agent through the MCP — a small step that will let operations leaders ask natural-language questions about network speed and compliance. No two days are the same, but every day your work makes Supply Chain decisions faster, smarter, and more trusted.

About the team

MX Supply Chain Business Insights owns the data, insights, and analytics that power how Amazon's Mexico Supply Chain organization understands its business, measures its customer experience, and makes decisions. The team serves 10 functional areas with growing cross-LATAM collaboration with Brazil.

Our team works together to deliver the data infrastructure, pipelines, semantic layers, and reporting that underpin MX Supply Chain's most critical business metrics, while also developing full stack applications to gather and process data. We are at an inflection point: as we embed GenAI across the portfolio and scale an AI-ready data lakehouse across LATAM, the decisions our stakeholders make depend on data they can trust, access quickly, and act on confidently.

Basic Qualifications

• 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience


• Experience using Python scripting to process data for modeling


• 3+ years of processing large, multi-dimensional datasets from multiple sources experience


• Experience using SQL (Structured Query Language) to pull data from a database or data warehouse


• Experience with data modeling, warehousing and building ETL pipelines


• Bachelor's degree or above in business administration, finance, economics, computer science, data science, engineering, or other related field, or 2+ years of Amazon RME (BB/3P) Full Time Exempt experience


• Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling


• Experience with data visualization using Tableau, Quicksight, or similar tools


• Experience with AI/ML technologies


• Experience building and operating a cloud-based architecture

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


• Experience developing and presenting recommendations of new metrics allowing better understanding of the performance of the business


• Experience with forecasting and statistical analysis

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.

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.