DataStage Modernization Consultant

CSS Staffing; Omaha (NE); On-site; USD 96,000 - 152,000; Full time

Job summary

CSS (United States) seeks a Senior Data Engineering Consultant for an onsite 6-12+ month contract in Omaha, Nebraska. You will optimize legacy ETL/ELT workflows, design cloud data integration, and deliver scalable data pipelines for a major modernization initiative.

The ideal candidate has 8+ years of experience, deep expertise with IBM InfoSphere DataStage, Snowflake, and large relational databases, and strong communication to work with architects, analysts, and business stakeholders.

Qualifications

• 8+ years of data engineering or enterprise data integration experience.
• Strong expertise with IBM InfoSphere DataStage or comparable ETL platforms.
• Experience with large-scale relational database environments.
• Strong SQL development and performance tuning experience.
• Experience with Snowflake data warehouse.
• Experience building enterprise-scale data pipelines.
• Excellent communication and stakeholder management.

Responsibilities

• Analyze, optimize, and troubleshoot enterprise ETL/ELT workflows.
• Design and implement legacy-to-cloud data integration solutions.
• Develop scalable data ingestion, transformation, and delivery processes.
• Identify bottlenecks and optimize SQL and indexing for performance.
• Collaborate with architects, developers, analysts, and business leaders.
• Ensure data quality, governance, and compliance throughout migration.

Skills

SQL development

Data pipeline design

ETL/ELT

Cloud data warehousing

Stakeholder management

Problem solving

Unix/Linux scripting

Tools

IBM InfoSphere DataStage

Snowflake

IBM DB2

Control-M

Job description

Senior Data Engineering Consultant (Contract)

Location: Omaha, Nebraska (Onsite) Duration: 6-12+ Month Contract (Potential Extension) Project: Enterprise Data Modernization Initiative

About the Opportunity

Our client, a well-established organization headquartered in Omaha, is seeking a highly experienced Senior Data Engineering Consultant to support a critical enterprise data modernization initiative. This consultant will play a key role in optimizing legacy data integration environments while helping advance modern cloud-based data platforms and data delivery capabilities. The ideal candidate is a hands-on technical expert who can quickly assess complex data ecosystems, troubleshoot performance challenges, and deliver scalable solutions with minimal ramp-up time. This is an onsite position in Omaha, Nebraska. Candidates should be comfortable working regularly from the client office and collaborating directly with business and technical teams.

Key Responsibilities

• Data Pipeline Optimization
  • Analyze, troubleshoot, and optimize complex enterprise ETL and ELT workflows.
  • Improve performance, scalability, and reliability of mission-critical data integration processes.
  • Reduce batch processing windows and eliminate recurring production issues.
• Legacy-to-Cloud Data Integration
  • Design and implement data movement and transformation solutions between legacy databases and cloud-based data platforms.
  • Develop scalable data ingestion, transformation, and delivery processes.
  • Support enterprise modernization and migration efforts.
• Performance Engineering
  • Identify systemic bottlenecks across data pipelines and database environments.
  • Optimize SQL code, stored procedures, indexing strategies, and data processing logic.
  • Improve overall platform stability and throughput.
• Stakeholder Engagement
  • Partner with architects, developers, analysts, and business leaders to drive project success.
  • Provide technical recommendations, risk assessments, and implementation strategies.
  • Communicate project progress and architectural considerations to stakeholders.
• Data Quality & Governance
  • Develop monitoring, validation, logging, and reconciliation processes.
  • Ensure data accuracy, reliability, and integrity throughout integration and migration efforts.
  • Support compliance, reporting, and audit requirements.

Required Qualifications

• 8+ years of data engineering, ETL, or enterprise data integration experience.
• Strong expertise with IBM InfoSphere DataStage or comparable enterprise ETL platforms.
• Significant experience working with large-scale relational database environments.
• Strong SQL development, query optimization, and database performance tuning experience.
• Experience supporting cloud data warehouse solutions such as Snowflake.
• Proven experience building and supporting enterprise-scale data pipelines.
• Experience troubleshooting complex production environments and resolving critical issues.
• Ability to quickly understand legacy systems and work independently within complex technical environments.
• Strong communication and stakeholder management skills.

Preferred Qualifications

• Experience within highly regulated industries such as insurance, financial services, healthcare, or banking.
• IBM DB2 experience.
• Unix/Linux shell scripting experience.
• Experience with enterprise scheduling tools such as Control-M.
• Experience supporting Cloud Data Warehouse initiatives and large-scale data migrations.
• Consulting or contractor experience in enterprise transformation projects.

Ideal Candidate Background

• IBM InfoSphere DataStage Developer or Architect
• Senior ETL Engineer
• Data Engineering Consultant
• Snowflake Data Engineer
• Data Warehouse Architect
• Enterprise Data Integration Engineer
• DB2 Data Engineer
• Data Migration Consultant

What Makes This Opportunity Attractive?

• High-visibility enterprise modernization initiative
• Opportunity to influence architecture and future-state data strategy
• Complex technical challenges involving both legacy and modern platforms
• Stable long-term contract potential
• Collaborative onsite environment with direct access to decision-makers