Senior Data Engineer – ETL and Data Modernization

Concentrix•Omaha, NE

4d•Onsite

About The Position

We're Concentrix. The intelligent transformation partner. Solution-focused. Tech-powered. Intelligence-fueled. The global technology and services leader that powers the world’s best brands, today and into the future. We’re solution-focused, tech-powered, intelligence-fueled. With unique data and insights, deep industry expertise, and advanced technology solutions, we’re the intelligent transformation partner that powers a world that works, helping companies become refreshingly simple to work, interact, and transact with. We shape new game-changing careers in over 70 countries, attracting the best talent. The Concentrix Technical Products and Services team is the driving force behind Concentrix’s transformation, data, and technology services. We integrate world-class digital engineering, creativity, and a deep understanding of human behavior to find and unlock value through tech-powered and intelligence-fueled experiences. We combine human-centered design, powerful data, and strong tech to accelerate transformation at scale. You will be surrounded by the best in the world providing market leading technology and insights to modernize and simplify the customer experience. Within our professional services team, you will deliver strategic consulting, design, advisory services, market research, and contact center analytics that deliver insights to improve outcomes and value for our clients. Hence achieving our vision. Our game-changers around the world have devoted their careers to ensuring every relationship is exceptional. And we’re proud to be recognized with awards such as "World's Best Workplaces," “Best Companies for Career Growth,” and “Best Company Culture,” year after year. Join us and be part of this journey towards greater opportunities and brighter futures.

Requirements

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 Haves

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.

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.