Data Engineer III

hudsonmanpower; Cincinnati (OH); On-site; USD 95,000 - 130,000; Full time

Job summary

Hudson Manpower seeks an experienced Data Engineer III in Cincinnati, OH to design, develop, and maintain enterprise data platforms for BI and analytics. The role emphasizes scalable data pipelines, Snowflake optimization, DBT modeling, and modernization of IBM DataStage ETL.

The ideal candidate has 5+ years in data engineering, cloud data skills, and experience migrating legacy ETL to modern architectures.

Qualifications

• Bachelor's degree or equivalent experience in relevant field.
• 5+ years of Data Engineering experience.
• 4+ years of Snowflake experience.
• Strong DBT experience.
• IBM DataStage experience.

Responsibilities

• Design, build, and maintain scalable enterprise data pipelines.
• Develop and optimize Snowflake data warehouse solutions.
• Create and maintain DBT models.
• Build reusable and modular data transformation pipelines.
• Design logical and physical data models.
• Maintain and modernize IBM DataStage ETL processes.
• Integrate data from multiple enterprise systems.
• Develop batch and near real-time data processing solutions.
• Build scalable data models for BI.
• Optimize SQL queries and warehouse performance.
• Monitor data quality and implement validation processes.
• Troubleshoot ETL failures and production issues.
• Collaborate with Data Architects, BI Developers, and stakeholders.
• Support disaster recovery and data resiliency initiatives.
• Participate in Agile ceremonies and sprint planning.
• Document metadata, data lineage, and technical specifications.
• Ensure compliance with data governance standards.

Skills

Snowflake

Data Engineering

Data Pipeline Development

ETL Development

Data Integration

Data Modeling

Data Warehouse Design

Business Intelligence

Performance Optimization

Data Quality

SQL Development

Relational Databases

Education

Bachelor's degree in Computer Science, Engineering, Information Systems, or related field

Tools

DBT (Data Build Tool)

IBM DataStage

Job description

Position Overview

We are seeking an experienced Data Engineer III to design, develop, and maintain modern enterprise data platforms supporting business intelligence and analytics initiatives.

This role focuses on building scalable data pipelines, developing and optimizing Snowflake data warehouse solutions, creating DBT models, and modernizing enterprise ETL environments using IBM DataStage.

The ideal candidate has strong cloud data engineering expertise, experience integrating legacy ETL platforms into modern architectures, and a passion for improving data quality, performance, and governance.

Candidates with Banking, Financial Services, or Mortgage Lending experience are highly preferred.

Location: Cincinnati, OH
Work Arrangement: Onsite (Business Requirements)
Employment Type: W2 – Full-Time
Duration: 6-Month Initial Contract (Extension Likely)
Work Authorization: No Sponsorship Available (F1, H4, and Green Card candidates eligible)
Experience Required: 5+ Years

Key Responsibilities

• Design, build, and maintain scalable enterprise data pipelines

• Develop and optimize Snowflake data warehouse solutions

• Create and maintain DBT models

• Build reusable and modular data transformation pipelines

• Design logical and physical data models

• Maintain and modernize IBM DataStage ETL processes

• Integrate data from multiple enterprise systems

• Develop batch and near real-time data processing solutions

• Build scalable data models for Business Intelligence

• Optimize SQL queries and warehouse performance

• Monitor data quality and implement validation processes

• Troubleshoot ETL failures and production issues

• Collaborate with Data Architects, BI Developers, and business stakeholders

• Support disaster recovery and data resiliency initiatives

• Participate in Agile ceremonies and sprint planning

• Document metadata, data lineage, and technical specifications

• Ensure compliance with enterprise data governance standards

Technical Environment

Data Platforms

• Snowflake

• DBT

• IBM DataStage

Databases

• SQL

• Relational Databases

• NoSQL

• MongoDB

Big Data

• Hadoop

Programming

• Java

• J2EE

Methodologies

• Agile / SAFe

• CI/CD

• Git

• DevOps

Required Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Systems, or related field (or equivalent experience)

• 5+ years of Data Engineering experience

• 4+ years of Snowflake experience

• Strong DBT experience

• IBM DataStage experience

• Advanced SQL development skills

• Enterprise data modeling experience

• Experience building scalable ETL pipelines

• Strong analytical and troubleshooting skills

• Excellent communication skills

• Ability to work independently

Ideal Candidate

The ideal candidate will have:

• Deep expertise in Snowflake

• Strong DBT development experience

• Modern cloud data engineering experience

• Enterprise ETL development expertise

• Legacy modernization experience

• Data warehouse architecture knowledge

• SQL performance tuning skills

• Banking or Financial Services experience

• Strong communication and collaboration skills

Required Skills

Data Engineering

• Snowflake (4+ years)

• Data Engineering

• Data Pipeline Development

• ETL Development

• Data Integration

• Data Modeling

• Data Warehouse Design

• Business Intelligence & Data Warehousing

• Performance Optimization

• Data Quality

• SQL Development

• Relational Databases

ETL & Cloud

• DBT (Data Build Tool)

• IBM DataStage

• Enterprise Data Warehousing

• Cloud Data Engineering

Preferred Skills

• Java

• J2EE

• NoSQL Databases

• Hadoop

• MongoDB

• Cloud Data Platforms

• Data Governance

• Metadata Management

• CI/CD

• Git

• DevOps Concepts

Preferred Industry Experience

• Banking

• Financial Services

• Mortgage Lending

• HELOC

• Encompass

• Regulatory Reporting

Nice-to-Have Skills

• SAFe Agile

• Mortgage Servicing

• Consumer Lending

• Enterprise Reporting

• Data Governance Frameworks

• Cloud Modernization Projects