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 with SSIS packages and SQL Agent jobs.
- Advanced SQL development and query optimization experience in SQL Server, Teradata, and Oracle.
- Demonstrated experience with data lineage analysis, dependency tracing, and reverse engineering legacy ETL processes.
- Proven background in data migration and modernization initiatives involving business-critical data and reporting logic.
- Experience performing data validation, reconciliation testing, and migration quality assurance.
- Strong knowledge of cross-platform SQL conversion and 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 supporting architecture reviews, historical data migration, production cutover, and implementation activities.
- Must be onshore and able to work onsite in Omaha, NE preferred, even if remote flexibility is considered.
Nice to Have
- Experience with Snowflake in migration or modernization programs.
- Experience with Informatica or other ETL/data integration tools.
- Background in data warehousing and enterprise reporting ecosystems.
- Industry experience in railroad, transportation, or logistics environments.
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.
As part of the hiring process, candidates may be required to undergo background screening and identity verification, where permitted by applicable law and consistent with the requirements of the role. Certain verification processes used by the Company or its service providers may involve technologies that rely on biometric identifiers or biometric information, where permitted by law. If biometric identifiers or biometric information are collected, used, or stored, the Company will provide the legally required disclosures and obtain any required written consent prior to such collection, and will handle such information in accordance with applicable biometric privacy laws and Company policies.
#LI-Onsite
#Omaha
#Nebraska
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.
Equal Employment Opportunity:
Concentrix is an equal opportunity and affirmative action (EEO-AA) employer. We promote equal opportunity to all qualified individuals and do not discriminate in any phase of the employment process based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy or related condition, disability, status as a protected veteran, or any other basis protected by law.
For more information regarding your EEO rights as an applicant, please visit the following websites:
Accommodation:
Concentrix welcomes and encourages applications from candidates with disabilities and is committed to providing an inclusive recruitment process. If you require reasonable accommodation to participate in any stage of the application or interview process, please let us know. Requests may be made by contacting [email protected]. All information will be treated confidentially and used solely to facilitate your participation in the recruitment process.
Artificial Intelligence:
As part of our recruitment process, we may use artificial intelligence (AI) tools to assist in the screening and/or assessment of job applicants. These tools could be used to evaluate resumes, applications, and other materials submitted to help us identify the best candidates for the role.
Work Authorization:
In accordance with federal law, only applicants who are legally authorized to work in the United States will be considered for this position. Must reside in the United States or have a valid U.S. address for residence.
For further information on available work states and Equal Employment Opportunity as an applicant, please click HERE
