Data Engineer II, Intelligence & Industrialization

Responsibilities

• Design, build, and own scalable data infrastructure on AWS (Redshift, S3, Glue, EMR) that delivers reliable access to large-scale transportation and customs datasets for cross-functional stakeholders
• Architect and implement end-to-end ETL pipelines that ingest, transform, and load data from diverse sources, ensuring timely delivery of critical business metrics with a focus on automation, efficiency, and fault tolerance
• Drive database performance optimization through workload management, query tuning, and monitoring strategies that maintain high availability and fast response times for analytical workloads
• Enable data-driven decision-making by partnering with BI Engineers and Data Scientists to deliver self-service analytics, data visualization, and machine learning solutions that reduce time-to-insight
• Establish and maintain data quality frameworks, data catalogs, and governance processes that protect data integrity and empower business users to discover and trust the data they rely on

Requirements

• Bachelor's degree in Computer Science, Engineering, or related fields
• 3+ years of data engineering experience
• Experience as a data engineer or related specialty (e.g., software engineer, business intelligence engineer, data scientist) with a track record of manipulating, processing, and extracting value from large datasets
• Experience with SQL
• Experience in at least one modern scripting or programming language, such as Python, Java, Scala, or NodeJS
• Experience architecting/operating solutions built on any cloud service provider like Azure, AWS, GCP, OCI, etc.

Technologies

• Python
• SQL
• Java
• Scala
• NodeJS
• Redshift
• S3
• Glue
• EMR
• Kinesis
• Firehose
• Lambda
• IAM
• AWS

Benefits

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

A Day in the Life

• You'll start mornings checking pipeline health and resolving data delivery issues.
• Deep-focus time is spent building new ETL pipelines, optimizing Redshift queries, or designing data models.
• Afternoons shift to collaborating with BI Engineers on visualization requirements, supporting Data Scientists with feature engineering, or translating business questions from transportation procurement stakeholders into technical solutions.
• You'll balance hands-on Python and SQL coding with design reviews an

About the Team

GSCTP is an organization under worldwide operations that develops and maintains strategic relationships with third party (3P) supply chain and transportation service providers. The team’s mission is to secure capacity from third-party providers, increase cost efficiencies of the business, expand supplier capabilities, and improve the overall quality of our products and services.

ACT is an expanding business unit under worldwide operations for Customs Brokerage operations. Customs brokerage involves the coordination of a complex network of sellers, shippers, logistics service providers, compliance, and government authorities to facilitate clearance of goods for cross-border transportation.