Lead ETL Developer

Role: Lead ETL Developer             

Location: Columbus, Ohio , Hybrid 

Send profiles to

Job Description: 

  Isoft is Seeking lead ETL developer, who will be leading the design, development, and optimization of scalable data pipelines. As a technical leader, this person partners across engineering, architecture, QA, and business teams, drives SDLC best practices, mentors team members, and helps shape the future-state data ecosystem on AWS, Snowflake, and Python-based frameworks.

Key Responsibilities:

• Technical Leadership & Delivery: Lead design, development, and maintenance of ETL/ELT pipelines in the EDW; ensure alignment to enterprise data architecture and standards; drive solution design from requirements and data mapping documents.

• Development & Engineering: Build and optimize pipelines using AWS Glue, Snowflake, Python/PySpark, and IBM DataStage; implement reusable, metadata-driven, performance-optimized integration patterns; enforce coding standards, version control, and CI/CD.

• Data Quality, Testing & Observability: Define unit, regression, and data validation strategies; partner with QA on system and integration testing; troubleshoot data and pipeline issues across environments.

• Collaboration: Work with Product Owners, BSAs, architects, and upstream/downstream teams; communicate progress, risks, and blockers; support production incident triage and root cause analysis.

• Continuous Improvement: Improve pipeline performance, reliability, and scalability; contribute to cloud migration, Snowflake optimization, and automation.

Basic Qualifications:

• Bachelor's degree (or an additional 4 years of related work experience in lieu of degree)

• 5+ years of ETL/Data Engineering experience in enterprise data warehouse environments

• 5+ years of SQL and database development

• 5+ years of hands-on Python/PySpark and ETL tools

• 3+ years with cloud-based data platforms

Preferred Qualifications:

• Strong data warehousing concepts, data modeling, and SDLC methodologies

• Proven experience leading development teams or acting as technical lead on large-scale data initiatives

• AWS services (Glue, S3, EC2) and Snowflake architecture optimization

• Data pipeline observability, monitoring, and automated testing frameworks

• Defining future-state data architecture or modernization roadmaps

• CI/CD, DevOps practices, and version control

• Data governance, security, and regulatory considerations in financial services

• AWS certifications (Solutions Architect, DevOps Engineer)

• Banking or financial services industry experience