Senior Data Engineer – Snowflake, DBT & DataStage (Onsite)

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

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.