Lead ETL Developer

Reliable Software Resources - Stamford, CT

Full-time - Mid Level

Stamford, CT

Professional, Scientific, and Technical Services

About the position

The Lead ETL Developer is responsible for developing and maintaining ETL data workflows and code for new data integrations, as well as enhancing existing workflows. This role requires deep knowledge of ETL processes, advanced SQL skills, and experience with data warehousing, particularly with Redshift. The position involves participating in multiple technical projects using Agile methodology and delivering IT/BI solutions.

Responsibilities

• Develop ETL data workflows and code for new data integrations.
• Maintain and enhance existing workflows and code.
• Write documentation that describes installation and operating procedures.
• Participate in multiple technical projects using Agile methodology.

Requirements

• 8-10 years of experience with SQL Query Design in large-scale data warehouse environments.
• 5 years of experience in data collection, database design, and report development.
• Deep knowledge of data extraction, transformation & loading (ETL).
• Advanced SQL skills.
• Advanced hands-on experience with Data Warehousing.
• Migration experience with Redshift.
• Expertise in Query optimization and Performance-tuning techniques.
• Good analytical skills.
• Good knowledge of UNIX programming.
• Good communication skills.