Contract Senior DataStage Data Engineer

CSS Staffing

Omaha (NE)

On-site

USD 120,000 - 170,000

Full time

7 days ago

Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Our client in Omaha, Nebraska is seeking a Senior Data Engineering Consultant to support a critical enterprise data modernization initiative onsite. The role requires hands-on expertise to optimize legacy data pipelines, enable cloud-based data platforms, and deliver scalable data delivery capabilities.

Collaboration with business and technical teams is essential. The ideal candidate will troubleshoot performance challenges, design scalable ingestion and transformation processes, and drive

Qualifications

8+ years of data engineering, ETL, or enterprise data integration experience.
Strong IBM InfoSphere DataStage expertise or comparable ETL platforms.
Experience with large-scale relational databases.
Strong SQL development, query optimization, and database performance tuning.
Experience supporting cloud data warehouses 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 in complex environments.

Responsibilities

Data Pipeline Optimization: analyze, troubleshoot, and optimize complex enterprise ETL/ELT workflows.
Legacy-to-Cloud Data Integration: design and implement data movement between legacy databases and cloud platforms.
Performance Engineering: identify bottlenecks and optimize SQL code, indexing, and processing logic.
Stakeholder Engagement: collaborate with architects, developers, analysts, and business leaders; provide technical recommendations.
Data Quality & Governance: develop monitoring, logging, validation, and reconciliation processes.

Skills

ETL/ELT design

SQL optimization

DataStage

Cloud DW

Data integration

Tools

IBM DB2

Snowflake

Control-M

Unix/Linux shell

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