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
Show the full description
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