ETL - Datastage Lead Developer

Robotics Prcocess Automation, LLC; Columbus (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology solutions provider is seeking a skilled DataStage Lead in Columbus, OH, focused on IBM DataStage and transitioning to Python development. The role requires leading ETL process design, collaborating with architects and analysts, and mentoring junior team members. Candidates should possess a Bachelor's degree in Computer Science and 5+ years of ETL experience. This position demands onsite presence 4 days a week, with a strong emphasis on strong communication and technical skills.

Qualifications

• 5+ years of experience in ETL development with IBM DataStage and Python.
• Strong experience with cloud-based data platforms like Snowflake.
• Proficient in Unix/Linux shell scripting.

Responsibilities

• Lead ETL processes using IBM DataStage and Python.
• Collaborate with teams for technical documentation.
• Optimize SQL queries for Snowflake and other databases.
• Write Unix shell scripts for automation.
• Manage incidents to minimize business impact.
• Participate in change management processes.

Skills

ETL development

Python

IBM DataStage

SQL

Unix/Linux shell scripting

Snowflake

Incident management

Change management

Analytical skills

Communication skills

Education

Bachelor's degree in Computer Science

Tools

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.

Employment Statement

ROBOTIC PROCESS AUTOMATION 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. ROBOTIC PROCESS AUTOMATION 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 ROBOTIC PROCESS AUTOMATION 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.