Cloud Data Engineer

Senior Data Warehouse / ETL Technical Lead (Contract)

Location: Columbus, OH (Local Candidates Only)

Work Arrangement: Hybrid (Candidates must be flexible to work onsite as needed)

Duration: Long-Term Contract

We are seeking an experienced Senior Data Warehouse / ETL Technical Lead to support a large-scale enterprise data transformation initiative. This role is ideal for a seasoned data professional who combines strong technical expertise with the ability to coordinate, enable, and guide development teams across multiple workstreams.

The successful candidate will play a key role in supporting a data warehouse migration from an on-premises environment to the cloud while helping drive data integration, documentation, quality, and technical leadership efforts.

Responsibilities

• Create, update, and maintain data mapping documentation between legacy and target systems.
• Review code and provide technical feedback and guidance to development teams.
• Troubleshoot ETL failures, identify root causes, and recommend solutions.
• Support planning and coordination activities across multiple project workstreams.
• Assist with enterprise data warehouse migration efforts from on-premises platforms to cloud-based solutions.
• Collaborate with business and technical stakeholders to document requirements and ensure alignment with project objectives.
• Provide technical leadership and mentorship to data team members.
• Serve as a key resource for data integration, data quality, and data modeling initiatives.

Required Qualifications

• Proven experience with ETL development and support.
• Strong hands-on experience with Informatica.
• Advanced SQL Server experience.
• Strong background in data modeling.
• Experience documenting business and technical requirements.
• Demonstrated experience mapping data across multiple systems.
• Proven technical leadership experience within a data-focused team.
• Strong troubleshooting and problem-solving skills.
• Excellent written and verbal communication skills.
• Exceptional attention to detail.

Preferred Qualifications

• Experience with Informatica Intelligent Data Management Cloud (IDMC).
• Snowflake experience.
• Experience supporting financial services data environments.
• Experience within the automotive industry or automotive financial services sector.

Candidate Profile

This position is best suited for a senior-level data professional who enjoys working across teams, solving complex data challenges, and enabling project success through technical leadership. While this role involves less hands-on development than a traditional ETL developer position, candidates must possess a strong technical foundation and be comfortable providing guidance, coordination, and support across multiple stakeholders and workstreams.

Important: Candidates must currently reside in the Columbus, Ohio area and be local at the time of submission. Relocation candidates will not be considered.