Data Engineer III

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