Data Engineer II

Data Engineer II to build and scale the data infrastructure for Amazon's North American Surface Transportation Linehaul network, designing data pipelines, analytical platforms, and AI powered tools used by operations leaders to monitor performance and drive decisions.

Location

Salary

USD 132,100 - 178,800 per yearly

Responsibilities

• Design and maintain scalable data pipelines that ingest and transform operational metrics from sources like Andes, Datanet, and Redshift using SparkSQL, Cradle, and AWS services (Glue, Lambda, S3, Step Functions).
• Build and extend AI powered analytical applications using AWS Bedrock, DynamoDB, and Python that generate automated performance summaries and insights.
• Own data modeling for new metric onboarding, drive migration of legacy SQL workloads to modern platforms, manage infrastructure-as-code with AWS CDK across gamma and production environments, and implement monitoring, alerting, and validation frameworks to ensure pipeline reliability.
• Collaborate with operations leaders and data scientists to translate business needs into data solutions that scale.

Requirements

• Master's degree in computer science, engineering, analytics, mathematics, statistics, IT or equivalent
• 3+ years of data engineering experience
• Minimum experience: 1 year
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes experience
• 1+ years of developing and operating large-scale data structures for business intelligence analytics using OLAP technologies experience
• Experience with data modeling, warehousing and building ETL pipelines

Technologies

• Andes
• Datanet
• Redshift
• SparkSQL
• Cradle
• AWS Glue
• AWS Lambda
• Amazon S3
• AWS Step Functions
• AWS Bedrock
• DynamoDB
• Python
• AWS CDK
• SQL
• EMR
• Kinesis
• Firehose
• IAM (roles and permissions)

Benefits

• Health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage)
• 401(k) matching
• Paid time off
• Parental leave
• Sign-on payments
• Restricted stock units (RSUs)

About the Team

• NAST CX Tech sits within Amazon Transportation Services and builds the data and analytics platforms that power operational decision-making for North American Surface Transportation. Our flagship product, Cortex Scribe, is an AI-powered platform that automatically generates performance summaries, deep-dive analyses, and weekly flash reports used by operations leaders across the network. We operate at the intersection of data engineering, applied AI, and operational analytics building tools that t