ETL Developer

IntoneCCM; Chicago (IL); Híbrido; USD 83.000 - 117.000; Jornada completa

Descripción de la vacante

Intone Inc. is seeking an ETL Developer for a 6-month contract based in Chicago, IL. The role involves designing, building, testing, and maintaining ETL pipelines across multiple systems in a large-scale enterprise environment.

The position is hybrid, offering collaboration with cross-functional teams to deliver robust data processing solutions. Responsibilities include leading backend ETL services, AWS data tooling, and ensuring production readiness with monitoring and documentation.

Formación

• Extensive hands-on experience building ETL jobs in an enterprise setup.
• Complex coding experience in Python or PySpark development.
• SQL development, debugging, and optimization.
• Experience with AWS data and analytics services.

Responsabilidades

• Lead, design, implement, deploy, and optimize backend ETL services.
• Support a massive-scale enterprise data solution using AWS data services.
• Analyze and interpret complex data to provide efficient technical solutions.
• Coordinate with cross-functional teams to build data processing procedures.
• Perform root cause analysis on production issues and monitor databases.
• Deliver timely project status and issue reporting to management.

Conocimientos

Python / PySpark

SQL development

AWS data services

AWS RDS MySQL

Big Data processing

Herramientas

AWS Glue

AWS Step Functions

AWS EventBridge

Apache Iceberg

Dynatrace

DataDog

Descripción del empleo

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