Business Intelligence Engineer
Amazon
Business Intelligence Engineer
Amazon
Sells products online and rents cloud computing
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.
- 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
- 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 runs the largest online store in the United States and rents cloud computing to businesses and governments through Amazon Web Services. AWS pioneered renting computing power over the internet, and Amazon built its own delivery network to get orders to customers quickly. Shoppers buy from Amazon and from independent sellers on its store, and Prime members pay a subscription for fast free shipping, streaming video and music, and other perks. AWS rents out computing power, storage, databases, and AI tools so companies can run software without owning servers, and Amazon also makes Kindle e-readers and Echo speakers with the Alexa assistant. Jeff Bezos founded Amazon in 1994, and it is based in Seattle, Washington.
Explore more opportunities at Amazon