Lead ETL Developer - AWS Data Pipelines & Analytics

SOMERSET STAFFING; Chicago (IL); Presencial; USD 120.000 - 180.000; Jornada completa

Descripción de la vacante

SOMERSET STAFFING is seeking a Senior ETL Developer IV to lead the design, implementation, and optimization of massive-scale enterprise backend ETL and data analytics services within an AWS cloud ecosystem in the Chicago area. You will build robust, highly automated data pipelines that extract, transform, and load data from disparate systems to support enterprise reporting and analytics initiatives.

You will mentor teams, enforce coding standards, and collaborate with product owners to deliver

Formación

• 6+ years of ETL experience with data cleansing, profiling, transformation, and scheduling.
• 6+ years of expert SQL writing, debugging, and optimization.
• 3-4 years of Python or PySpark/Glue for large datasets.
• 3-4 years with core AWS services including Glue, S3, Redshift, Lambda, Step Functions, RDS, CloudWatch, SNS, SQS, and EventBridge.
• 3+ years Big Data processing with scalable architectures.

Responsabilidades

• Lead, design, implement, deploy, and optimize backend ETL services and data processing procedures.
• Support a massive-scale enterprise data solution using AWS data and analytics services.
• Analyze and interpret complex data and related systems, providing efficient technical solutions.
• Provide support to ETL schedules and maintain strict compliance with schedule execution.
• Develop and maintain standards for ETL code and lifecycle across ETL processes.
• Coordinate with cross-functional teams including architects, platform engineers, other developers, and product owners to build data processing workflows.
• Perform root cause analysis on production issues and provide operational support to ETL environments.
• Help create functional specifications and technical designs with business owners.
• Implement industry best practice code and configurations for production and non-production environments.
• Provide timely project status and incident reporting to management.
• Support production incidents during odd hours in major outages.

Conocimientos

ETL tools

SQL queries

Python / PySpark

AWS cloud services

Big Data

CI/CD / IaC

Herramientas

AWS Glue

S3

Redshift

Lambda

Step Functions

RDS Aurora/MySQL

CloudWatch

SNS

SQS

EventBridge

Descripción del empleo

SOMERSET STAFFING is seeking a Senior ETL Developer IV to lead the design, implementation, and optimization of massive-scale enterprise backend ETL and data analytics services within an AWS cloud ecosystem in the Chicago area. You will build robust, highly automated data pipelines that extract, transform, and load data from disparate systems to support enterprise reporting and analytics initiatives.

You will mentor teams, enforce coding standards, and collaborate with product owners to deliver