About the team
The Last Mile Data Engineering Team (LMDET) is a specialized data engineering organization focused on delivering seamless, secure, and governed access to Last Mile datasets at scale. The team designs and owns large-scale data lake and data warehouse infrastructures, including the Last Mile Data Repository (LMDR) and Campus data platforms, housing 10,000+ datasets across domains such as maps, geocoding, routing, and transportation. Leveraging AWS and industry-leading big data technologies, the team builds complex ETL pipelines, near-real-time data ingestion systems, and reusable datasets that power analytics, business reviews, and machine learning model development. LMDET also drives innovation through Generative AI-powered solutions for natural language querying, auto-insight generation, geocoding orchestration, and unified workflow automation, partnering closely with business, science, product, and technology teams to enable intelligent, data-driven decision-making across the Last Mile organization.
3+ years of data engineering experience
4+ years of SQL experience
Experience with data modeling, warehousing and building ETL pipelines
2+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes experience
Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets
Experience in at least one modern scripting or programming language, such as Python, Java, Scala, or NodeJS
Experience with AWS technologies like Redshift, S3, AWS Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions
Experience with non-relational databases / data stores (object storage, document or key-value stores, graph databases, column-family databases)
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.