Get the app Chrome extension Freelance ideasGigsSign inFind my gigs

ProfilePush / H1B jobs / ETL Developer IV

ETL Developer IV

Randstad · Chicago, IL · contract · posted 19 days ago

$60.55–$70.55 an hourpay
Chicago, ILlocation
contractjob type
6+ yearsexperience

Apply on Randstad's siteCheck my AI Match score

Skills

About the job

We are seeking a Senior ETL Developer IV to lead the design, development, and operational optimization of high-volume, cloud-native data pipelines within our enterprise AWS environment. In this role, you will collaborate with cross-functional architecture and platform teams at our corporate Willis Tower location, developing scalable data ingestion, cleansing, and transformation solutions that power strategic enterprise analytics.

KEY RESPONSIBILITIES

Lead the architectural design, implementation, deployment, and optimization of backend ETL data services.

Develop complex data transformation workflows and automation scripts using Python, PySpark, and AWS Glue.

Author, debug, and fine-tune advanced SQL queries and analyze database performance across AWS RDS Aurora/MySQL.

Build resilient, event-driven workflows utilizing AWS Step Functions, EventBridge, Lambda, SQS, and SNS.

Manage CI/CD deployment automation and Infrastructure as Code using Harness, YAML, and AWS CloudFormation.

Perform root cause analysis on production data incidents, monitor pipeline telemetry, and participate in incident support during critical outages.

Establish development standards, technical documentation, and quality best practices across all ETL lifecycles.

REQUIRED QUALIFICATIONS

6+ years of experience in data engineering and ETL development, including data cleansing, transformation, profiling, and scheduling.

6+ years of advanced, expert-level SQL development and performance optimization experience.

3-4 years of hands-on programming experience using Python or PySpark/Glue for large-scale data processing.

3-4 years of production experience across AWS services, including AWS Glue, S3, Redshift, Lambda, Step Functions, EventBridge, and RDS MySQL.

Strong background in Big Data architecture, design patterns, and distributed computing models.

Practical experience implementing CI/CD pipelines and Infrastructure as Code (IaC) with Harness, CloudFormation, or YAML.

Ability to work on-site at the Chicago office on alternating Tuesdays and Wednesdays, with flexibility for off-hours incident troubleshooting.

PREFERRED QUALIFICATIONS

Prior leadership experience guiding technical ETL or data engineering teams.

Hands-on implementation experience with Apache Iceberg table formats.

Familiarity with modern observability and monitoring suites such as Dynatrace or DataDog.

AWS data,AWS Glue,Redshift,RDS,AWS RDS,S3,SNS,SQS,AWS cloud,AWS services,Apache,application performance,backend,large-scale data,Big Data processing,CloudFormation,CloudWatch,programming experience,CI/CD,data analytics,data cleansing,data pipelines,data processing workflows,data processing,data profiling,database monitoring,database,DataDog,Dynatrace,ETL,extract, transform, and load,ETL processes,ETL tools,complex SQL queries,Lambda,data engineering,Infrastructure as Code (IaC),monitoring tools,MySQL,PySpark,Python,EventBridge,debugging,common design patterns,Step Functions,YAML,analytic,Coordinate,troubleshoot,analytics initiatives,automated,business process,data models,functional specifications,impact analyses,operational support,project lifecycle,root cause analysis,scalable architectures,schedules,scheduling,technical advice,workflows

More Randstad jobs this week

Food Science Analytical Laboratory AssociateRandstad · Greenwich, CT · contract · today
View
Warehouse Loader Unloader - Now HiringRandstad · Fontana, CA · contract · today
View
Stand up forklift operator - Now HiringRandstad · Buckeye, AZ · contract · today
View
Forklift Operator - Sit Down - Now HiringRandstad · Milwaukee, WI · contract · today
View
Warehouse Loader Unloader - Now HiringRandstad · Fontana, CA · contract · today
View
Production Associate - Now HiringRandstad · Frankfort, KY · contract · today
View

Questions

Does Randstad sponsor H1B for this job?

Randstad is on record as an H1B sponsor. The posting doesn't say it won't sponsor. A past filing doesn't guarantee sponsorship for a particular role, so confirm with Randstad.

How do I apply for this ETL Developer IV job?

Apply on Randstad's own careers page with the Apply button. To see how well your resume fits first, ProfilePush's AI Match scores it 0 to 100 for free.

How well do you fit this job?

Upload your resume and AI scores this job, and every sponsor job like it, 0 to 100. Free to start.

Get my match score