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