ETL Developer

We are seeking an ETL Developer for a 6-month contract position based in Chicago, Illinois, working in a hybrid arrangement. You will design, build, test, and maintain systems that extract, load, and transform data from multiple systems in a large-scale enterprise environment.

Responsibilities

• Lead, design, implement, deploy, and optimize backend ETL services
• Support a massive-scale enterprise data solution using AWS data and analytics services
• Analyze and interpret complex data and related systems to provide efficient technical solutions
• Provide support to ETL scheduling and maintain compliance to established schedules
• Develop and maintain standards for ETL code and maintain an effective project lifecycle on all ETL processes
• Coordinate with cross-functional teams including architects, platform engineers, developers, and product owners to build data processing procedures
• Perform root cause analysis on production issues and conduct routine monitoring on databases
• Provide support to ETL environments
• Help create functional specifications and technical designs in collaboration with business process area owners
• Implement industry best practices for code and configuration in production and non-production environments in a highly automated environment
• Provide technical advice, effort estimates, and impact analysis
• Deliver timely project status and issue reporting to management

Qualifications

• Required

• Extensive hands-on experience building ETL jobs and processing large datasets in an enterprise setup

• Complex coding experience in Python or PySpark development

• SQL development, debugging, and optimization

• AWS services including Glue, Step Functions, and Event Bridges

• Knowledge of database inner workings, such as AWS RDS MySQL

• Big Data processing experience

• Preferred

• Leadership experience with a reasonably sized ETL team

• Experience with Apache Iceberg

• Familiarity with observability tools such as Dynatrace or DataDog