Job Title:
Senior Data Engineer – ETL and Data Modernization
Senior Data Engineer – ETL and Data Modernization
Location: Omaha, NE (Onsite - 5 days a week)
We’re looking for a highly analytical Data Engineer to help modernize and migrate business-critical data assets from SQL Server and SSIS-based environments to Teradata and/or Snowflake. In this role, you will trace complex legacy ETL and reporting dependencies, document end-to-end data lineage, and deliver accurate, validated migrations that preserve existing business logic and reporting behavior.
Responsibilities
- Analyze and reverse engineer legacy SQL Server, SSIS packages, stored procedures, views, tables, and SQL Agent jobs to understand existing data flows and business logic.
- Lead data engineering activities to migrate SQL Server tables and ETL workloads to Teradata and/or Snowflake environments.
- Trace and document end-to-end data lineage, upstream/downstream dependencies, technical risks, assumptions, and migration decisions.
- Perform cross-platform SQL conversion across SQL Server, Teradata, Oracle, and Snowflake while maintaining performance, accuracy, and functional equivalence.
- Optimize SQL queries and data processing logic for scalability, efficiency, and reliability across multiple database platforms.
- Partner with technical teams, project leadership, architects, and business stakeholders to validate requirements and ensure migration outcomes align to expected reporting behavior.
- Support architecture reviews and contribute to migration planning, sequencing, and implementation strategy.
- Execute data validation, reconciliation, and testing activities to confirm completeness, integrity, and consistency of migrated datasets.
- Assist with historical data migration, implementation readiness, production cutover, and post-deployment support.
- Identify issues proactively, solve complex dependency challenges, and deliver clear technical documentation throughout the migration lifecycle.
Qualifications
- 4-10 years experience as a Data Engineer
- Strong hands-on experience withSSIS packagesandSQL Agent jobs.
- Advanced SQL development and query optimization experience inSQL Server, Teradata, and Oracle.
- Demonstrated experience withdata lineage analysis,dependency tracing, andreverse engineering legacy ETL processes.
- Proven background indata migration and modernizationinitiatives involving business-critical data and reporting logic.
- Experience performingdata validation, reconciliation testing, and migration quality assurance.
- Strong knowledge ofcross-platform SQL conversionand platform-specific considerations across SQL Server, Teradata, Oracle, and Snowflake.
- Ability to independently trace complex tables, views, stored procedures, SSIS workflows, and job orchestration after onboarding.
- Strong analytical thinking, structured problem-solving, and attention to detail.
- Excellent written and verbal communication skills with the ability to clearly document lineage, risks, and technical decisions.
- Experience supportingarchitecture reviews,historical data migration,production cutover, andimplementation activities.
- Must beonshoreand able to workonsite in Omaha, NE preferred, even if remote flexibility is considered.
Nice to Have
- Experience withSnowflakein migration or modernization programs.
- Experience withInformaticaor other ETL/data integration tools.
- Background indata warehousingand enterprise reporting ecosystems.
- Industry experience inrailroad, transportation, or logisticsenvironments.
The base salary for this position is $ 78,250 to $ 94,356 plus incentives that align with individual and company performance. Actual salaries will vary based on work location, qualifications, skills, education, experience, and competencies. Benefits available to eligible employees in this role include medical, dental, and vision insurance, comprehensive employee assistance program, 401(k) retirement plan, paid time off and holidays and paid learning days.
The deadline to apply for this position is: 08/13/2026. This position is for an existing, immediate vacancy. We are currently seeking to fill this role with an individual who can start as soon as possible.
#LI-Onsite
#Omaha
#Nebraska
Location:
USA, NE, Work-at-Home
Language Requirements:
Time Type:
Full time
Physical and Mental Requirements:
The employee is regularly required to operate a computer, keyboard, telephone/headset, and/or other office equipment as essential functions of this position. Work is generally sedentary in nature.
