Senior Data Engineer (DataStage)

TL;DR

Senior Data Engineer (DataStage): Designing and supporting scalable IBM DataStage ETL solutions and enterprise data pipelines with an accent on data integration, cloud migration, and high-volume processing. Focus on building reusable frameworks, optimizing Snowflake and data warehouse workloads, and solving complex production support and performance challenges.

Location: Cincinnati, Ohio, United States

Salary: $55–$70 per hour ($8,800–$11,200 per month equivalent)

Company

Provides information technology and workforce solutions through a large professional services organization operating across the United States and Canada.

What you will do

• Design, develop, test, deploy, and support complex ETL and ELT solutions using IBM DataStage.
• Build reusable, parameterized, and metadata-driven ETL frameworks and automated data processing workflows.
• Integrate Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet, and cloud storage sources.
• Develop cloud-native pipelines and migrate data from on-premises systems to Snowflake, data warehouses, data lakes, and lakehouses.
• Perform data validation, cleansing, reconciliation, performance tuning, root cause analysis, production support, and incident management.
• Collaborate with business and technology stakeholders to translate requirements into scalable data integration solutions.

Requirements

• Strong hands-on experience with IBM DataStage 11.7 or later, including Parallel Jobs, Sequencers, Parameter Sets, monitoring, administration, and performance tuning.
• Advanced SQL and PL/SQL skills with strong Oracle and DB2 experience.
• Strong Snowflake experience, including Streams and Tasks, Dynamic Tables, stages, Secure Views, Data Sharing, and query optimization.
• Strong Unix/Linux shell scripting skills for automation, batch scheduling, file handling, and production troubleshooting.
• Experience with high-performance batch, incremental, and CDC-based pipelines, ETL/ELT architecture, dimensional modeling, data lakes, and lakehouses.
• 8–10 years of engineering experience preferred, with a minimum of 6 years required, plus a bachelor's degree in computer engineering, computer science, or a related discipline.

Nice to have

• CI/CD experience and familiarity with Git, Agile, and DevOps practices.
• Snowflake performance optimization experience.
• Payments industry experience.

Culture & Benefits

• Contract engagement with opportunities to work on mission-critical enterprise data platforms.
• Full-time consultants may receive medical, dental, vision, 401(k) contributions, PTO, sick leave, and other applicable benefits.
• Work includes collaboration with business and technology stakeholders and independent delivery after training.

Hiring process

• Two rounds of panel-style interviews.
• Interviews are expected to begin the following week for qualified candidates.