ETL - Datastage Lead Developer

Ethereum Technologies LLC; Columbus (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology corporation is seeking a highly skilled DataStage Lead with Python to join their IT Corporate Finance Regulatory Reporting team. This role requires strong experience in ETL development using IBM DataStage and Python. The candidate will lead ETL design and collaborate with various teams while ensuring compliance with internal standards. The position necessitates onsite attendance in Columbus four days a week and offers an opportunity to mentor junior team members.

Qualifications

• 5+ years of experience in ETL development with IBM DataStage and Python.
• Strong experience with Snowflake or other cloud-based data platforms.
• Excellent problem-solving and communication skills.

Responsibilities

• Lead the design and maintenance of ETL processes using IBM DataStage and Python.
• Collaborate with data architects and compliance teams on technical designs.
• Develop and optimize SQL queries for Snowflake and other databases.

Skills

ETL development

Python

SQL

Unix/Linux scripting

Data governance

Data analysis

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.

ETHEREUM TECHNOLOGIES LLC 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. ETHEREUM TECHNOLOGIES LLC 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 ETHEREUM TECHNOLOGIES LLC 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.