Sr. ETL Lead with AWS & SQL

Shrive Technologies LLC; Town of Texas (WI); On-site; USD 120,000 - 160,000; Full time

Job summary

Shrive Technologies LLC is seeking an experienced ETL Lead to design, develop, and manage enterprise-scale data integration solutions. You will lead ETL initiatives, mentor the team, and collaborate with business and data stakeholders to ensure high-quality data movement across source and target systems.

The role focuses on data modernization, data warehousing, reporting, analytics, and cloud transformation initiatives within a fast-paced environment.

Qualifications

• Strong experience in ETL development and leadership.
• Experience with relational databases: Oracle, SQL Server, PostgreSQL, MySQL.
• Knowledge of Data Warehousing and Dimensional Modeling concepts.
• Experience with scheduling and orchestration tools such as Control-M, Airflow, or Autosys.
• Familiarity with source control tools like Git, Azure DevOps, or Bitbucket.

Responsibilities

• Lead the design, development, testing, deployment, and support of ETL/ELT solutions.
• Analyze business requirements and translate them into scalable data integration architectures.
• Develop and optimize ETL workflows, mappings, transformations, and data pipelines.
• Ensure data quality, integrity, governance, and compliance across data platforms.
• Collaborate with business analysts, data architects, data engineers, and application teams.
• Perform root cause analysis and resolve complex production issues.
• Drive ETL performance tuning and optimization initiatives.
• Establish coding standards, best practices, and development guidelines.
• Lead code reviews and mentor junior ETL developers.
• Support data migration, modernization, and cloud transformation projects.
• Manage project deliverables, timelines, and stakeholder communications.
• Implement CI/CD and DevOps practices for ETL deployment and monitoring.
• Create and maintain technical documentation, data flow diagrams, and operational procedures.

Skills

ETL leadership

ETL design & development

SQL

Data governance

CI/CD for ETL

Tools

Informatica PowerCenter / IICS

Talend

SSIS

IBM DataStage

Ab Initio

AWS Glue

Matillion

Job description

Job Summary

We are seeking an experienced
ETL Lead to design, develop, and manage enterprise-scale data integration solutions. The ideal candidate will lead ETL development initiatives, mentor team members, collaborate with business and data stakeholders, and ensure high-quality data movement across multiple source and target systems. The ETL Lead will play a critical role in driving data modernization, data warehousing, reporting, analytics, and cloud migration initiatives.

Key Responsibilities

Lead the design, development, testing, deployment, and support of ETL/ELT solutions. Analyze business requirements and translate them into scalable data integration architectures. Develop and optimize ETL workflows, mappings, transformations, and data pipelines. Ensure data quality, integrity, governance, and compliance across data platforms. Collaborate with business analysts, data architects, data engineers, and application teams. Perform root cause analysis and resolve complex production issues. Drive ETL performance tuning and optimization initiatives. Establish coding standards, best practices, and development guidelines. Lead code reviews and mentor junior ETL developers. Support data migration, modernization, and cloud transformation projects. Manage project deliverables, timelines, and stakeholder communications. Implement CI/CD and DevOps practices for ETL deployment and monitoring. Create and maintain technical documentation, data flow diagrams, and operational procedures.

Skill Requirements

Strong experience in ETL development and leadership. Expertise in one or more ETL tools:

• Informatica PowerCenter / IICS
• Talend
• SSIS
• IBM DataStage
• Ab Initio
• AWS Glue
• Matillion

Strong SQL and database programming skills. Experience with relational databases:

• Oracle
• SQL Server
• PostgreSQL
• MySQL

Knowledge of Data Warehousing and Dimensional Modeling concepts. Experience working with large-scale data integration and migration projects. Strong understanding of data quality and data governance principles. Experience with scheduling and orchestration tools such as Control-M, Airflow, or Autosys. Familiarity with source control tools like Git, Azure DevOps, or Bitbucket.

Knowledge of cloud platforms:

• Azure
• AWS
• Google Cloud Platform