ETL - Datastage Lead Developer

Cloud Hybrid Technologies, LLC; Columbus (OH); On-site; Full time

Job summary

A technology solutions provider is seeking a skilled DataStage Lead with Python for its IT Corporate Finance Regulatory Reporting team in Columbus, OH. This role focuses on IBM DataStage for ETL processes and transitions to Python development. The ideal candidate will lead ETL design and development, collaborate with cross-functional teams, and ensure compliance with regulatory requirements. Candidates should have a bachelor's degree, at least 5 years of relevant experience, and strong skills in SQL and Unix shell scripting.

Qualifications

• 5+ years of experience in ETL development with IBM DataStage and Python.
• Proficiency in Unix/Linux shell scripting.
• Solid understanding of relational databases and SQL.

Responsibilities

• Lead the design, development, and maintenance of ETL processes using IBM DataStage and Python.
• Collaborate with teams to create and maintain technical design documents.
• Develop and optimize SQL queries and scripts for Snowflake.

Skills

ETL development

Python

SQL

Unix/Linux shell scripting

Snowflake

Incident management

Change management

Analytical skills

Communication skills

Education

Bachelor's degree in Computer Science or related field

Tools

IBM DataStage

Snowflake

Job description

Position Summary

We are seeking a highly skilled DataStage Lead with Python to join our IT Corporate Finance Regulatory Reporting team. This role will initially focus on IBM DataStage for ETL processes but will transition to Python development over the next 1 2 years. The ideal candidate will have strong experience in both technologies and a passion for building efficient, compliant data solutions.

Key Responsibilities

• Lead the design, development, and maintenance of ETL processes using IBM DataStage and Python.
• Collaborate with data architects, business analysts, and compliance teams to create and maintain technical design documents.
• Develop and optimize SQL queries and scripts for Snowflake and other relational databases.
• Write and maintain Unix shell scripts to support automation and data processing tasks.
• Manage and resolve incidents promptly to minimize business impact.
• Participate in change management processes, including planning, documentation, and execution.
• Provide technical insights during project and team meetings.
• Ensure compliance with internal standards, security policies, and regulatory requirements.
• Mentor junior team members and provide technical leadership.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• 5+ years of experience in ETL development with IBM DataStage and Python.
• Strong experience with Snowflake or other cloud‑based data platforms.
• Proficiency in Unix/Linux shell scripting.
• Solid understanding of relational databases and SQL.
• Experience with incident and change management processes (ITIL framework preferred).
• Excellent problem‑solving, analytical, and communication skills.
• Ability to work onsite 4 days a week in Columbus, OH.

Preferred Qualifications

• Experience in banking or financial services industry.
• Familiarity with Agile methodologies and DevOps practices.
• Knowledge of data governance and data quality best practices.

Cloud Hybrid is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Hybrid will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Hybrid require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.