Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Bachelor's degree in sciences, engineering, finance or equivalent
- +3 years of experience in business intelligence or related role
- Fluent in Spanish and English (b2+)
- 2+ years of experience with AWS ETL or similar.
Are you a data enthusiast? Does the world's most complex logistic systems inspire your curiosity? Is your passion to navigate through hundreds of systems, processes, and data sources to solve the puzzles and identify the next big opportunity? Are you a creative big thinker who is passionate about using data and optimization tools to direct decision making and solve complex and large-scale challenges? Do you feel like your skills uniquely qualify you to bridge communication between teams with competing priorities? If so, then this position is for you! We are looking for a motivated individual with strong analytic and communication skills to join the effort in evolving the network we have today into the network we need tomorrow.
Amazon's extensive logistics system is comprised of thousands of fixed infrastructure nodes, with millions of possible connections between them. Billions of packages flow through this network on a yearly basis, making the impact of optimal improvements unparalleled. This magnificent challenge is a terrific opportunity to analyze Amazon's data and generate actionable recommendations using optimization and simulation. Come build with us!
This role will collaborate with diverse set of stakeholder including product managers, program managers, data scientists, software development engineers and other partner teams to analyze large data sets, prove and disprove hypothesis, automate existing solutions and build self-service dashboards and reports.
Key job responsibilities
E2E design and creation of data pipelines including harmonization of different data sources (Data base, API, user inputs and manual files) using SQL and other scripting language (R,Python,Rust), reporting and automation using Quicksight tableu or similar. Design of automations to send push out information of alerts, business insights etc. Project and stakeholder management
Write high quality SQL code to retrieve and analyze data from database tables, and learn and understand a broad range of Amazon's data resources and know how, when, and which to use and which not to use.
Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.
Mexico City, DIF, MEX
- Previous experience working with supply chain or logistics data
- AWS Certification