Lead ETL Developer

Cloud Hybrid Technologies, LLC; Columbus (OH); On-site; USD 120,000 - 150,000; Full time

Job summary

A technology solutions firm is seeking a Lead ETL Developer to work onsite in Columbus, OH. The role involves developing data solutions for the enterprise data warehouse and leading teams in ETL processes. Candidates should have over 10 years of experience, with at least 3 years in a lead capacity, and strong knowledge in data warehousing, DataStage ETL, and cloud infrastructure. This position emphasizes the importance of data as a strategic asset and supports continuous improvement initiatives.

Qualifications

• 10+ years of total experience in ETL development.
• 3+ years in a lead role for ETL development.
• 5 years of experience in a Data Warehouse.

Responsibilities

• Translate requirements to a technical design.
• Develop and maintain code following standards.
• Create and execute unit test plans.

Skills

ETL - Datawarehouse concepts

Datastage ETL

Python/PySpark

SQL development

Cloud infrastructure management

Communication skills

Interpersonal skills

Education

Bachelor's degree in Computer Science or related field

Job description

Overview

Position: Lead ETL Developer with Snowflake

Location: Columbus, OH (Day 1 Onsite)

Duration: Long Term

Looking for a Lead ETL Developer Lead in our Enterprise Data Warehouse. In this role you will be part of a team working to develop solutions enabling the business to leverage data as an asset at the bank. As a Lead ETL Developer, you will be leading teams to develop, maintain and enhance code ensuring all IT SDLC processes are documented and practiced, working closely with multiple technologies teams across the enterprise. The Lead ETL Developer should have extensive knowledge of data warehousing cloud technologies.

If you consider data as a strategic asset, evangelize the value of good data and insights, have a passion for learning and continuous improvement, this role is for you.

Key Responsibilities

• Translate requirements and data mapping documents to a technical design.
• Develop, enhance and maintain code following best practices and standards.
• Create and execute unit test plans. Support regression and system testing efforts.
• Debug and problem solve issues found during testing and/or production.
• Communicate status, issues and blockers with project team.
• Support continuous improvement by identifying and solving opportunities.

Experience & Qualifications

• Total Experience: 10+ years
• Should have played the role of Lead for a minimum of 3+ years
• 5 years of experience in ETL development within a Data Warehouse
• As a Lead Developer at Onsite, candidate needs to coordinate with Offshore team at India and Client and drive/lead the team for smooth deliverables.

Basic Qualifications

• Bachelor degree or military experience in related field (preferably computer science) and 5 years of experience in ETL development within a Data Warehouse.
• Deep understanding of enterprise data warehousing best practices and standards.
• Strong experience in software engineering comprising of designing, developing and operating robust and highly-scalable cloud infrastructure services.
• Strong experience with Python/PySpark, DataStage ETL and SQL development
• Proven experience in cloud infrastructure projects with hands on migration expertise on public clouds such as AWS and Azure, preferably Snowflake.
• Knowledge of Cybersecurity organization practices, operations, risk management processes, principles, architectural requirements, engineering and threats and vulnerabilities, including incident response methodologies.
• Strong communication and interpersonal skills.
• Strong organization skills and the ability to work independently as well as with a team.

Preferred Qualifications

• AWS Certified Solutions Architect Associate, AWS Certified DevOps Engineer Professional and/or AWS Certified Solutions Architect Professional
• Experience defining future state roadmaps for data warehouse applications.
• Experience leading teams of developers within a project.
• Experience in financial services (banking) industry.

Mandatory Skills

• ETL - Datawarehouse concepts, Datastage ETL

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