Note: The job is a remote job and is open to candidates in USA. Concentrix is a global technology and services leader that helps organizations transform through data, technology, and intelligence-fueled solutions. The Senior Data Engineer will modernize and migrate business-critical data assets from SQL Server and SSIS environments to Teradata and/or Snowflake, while tracing dependencies, documenting data lineage, validating migrations, and preserving 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
Skills
- * 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
- 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
- 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
- * 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
Benefits
- Incentives that align with individual and company performance
- Medical insurance
- Dental insurance
- Vision insurance
- Comprehensive employee assistance program
- 401(k) retirement plan
- Paid time off and holidays
- Paid learning days
- Onsite work in Omaha, NE (5 days a week)
Company Overview