Senior AWS ETL Engineer | Lead Data Pipelines

Blue Ribbon Global Technologies; Chicago (IL); On-site; USD 140,000 - 180,000; Full time

Job summary

Blue Ribbon Global Technologies is seeking a Senior ETL Developer IV to lead the design and optimization of massive-scale enterprise backend ETL and data analytics services within an AWS cloud ecosystem. You will build robust, highly automated data pipelines to support enterprise reporting and analytics initiatives.

The role requires 6+ years in ETL, strong SQL and Python/PySpark skills, extensive AWS experience (Glue, S3, Redshift), and a track record of leading data engineering efforts in a

Qualifications

• 6+ years of ETL experience using data cleansing, data profiling, transforming, and scheduling diverse workflows.
• 6+ years of expert-level SQL writing, debugging, and optimizing complex queries.
• 3–4 years of programming in Python or PySpark/Glue for large-scale data sets.
• 3–4 years of hands-on use of core AWS services: Glue, S3, Redshift, Lambda, Step Functions, RDS Aurora/MySQL, CloudWatch, SNS, SQS, EventBridge.
• 3+ years of Big Data processing with scalable architectures.
• Demonstrated capability debugging database internals (e.g., AWS RDS MySQL).
• Hands-on experience with CI/CD and IaC, specifically Harness and CloudFormation scripts.

Responsibilities

• 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 maintain an effective project lifecycle across all 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, conduct routine database monitoring, and provide operational support to ETL environments.
• Help create functional specifications and technical designs while partnering with business process area owners.
• Implement industry best practice code and configurations for production and non-production environments in a highly automated environment.
• Provide technical advice, effort estimates, and architectural impact analyses.
• Provide timely project status and incident/issue reporting to management.
• Support and troubleshoot critical production pipeline issues during odd hours in the event of major incidents.

Skills

ETL tools

SQL proficiency

Python / PySpark

AWS services

Big Data processing

CI/CD / IaC

Technical leadership

Tools

Harness

CloudFormation

YAML

Job description

Blue Ribbon Global Technologies is seeking a Senior ETL Developer IV to lead the design and optimization of massive-scale enterprise backend ETL and data analytics services within an AWS cloud ecosystem. You will build robust, highly automated data pipelines to support enterprise reporting and analytics initiatives.

The role requires 6+ years in ETL, strong SQL and Python/PySpark skills, extensive AWS experience (Glue, S3, Redshift), and a track record of leading data engineering efforts in a