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 Data Stage.

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

• 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 Data Stage 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

Data Platforms

• Snowflake

• DBT

• IBM Data Stage

Databases

• SQL

• Relational Databases

• No
  
  SQL

• MongoDB

Big Data

• Hadoop

Programming

• Java

• J2EE

Methodologies

• Agile / SAFe

• CI/CD

• Git

• Dev Ops

• 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 Data Stage 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

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

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 Data Stage

• Enterprise Data Warehousing

• Cloud Data Engineering

Preferred Skills

• Java

• J2EE

• No
  
  SQL Databases

• Hadoop

• MongoDB

• Cloud Data Platforms

• Data Governance

• Metadata Management

• CI/CD

• Git

• Dev Ops 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