DATA ENGINEER - SQL SERVER METRIC MIGRATION- Mid Level #26-19686

US Tech Solutions; Omaha (NE); On-site; USD 90,000 - 130,000; Full time

Job summary

US Tech Solutions in Omaha, NE is seeking a data engineer contractor to move SQL Server tables and SSIS jobs to Teradata or Snowflake, ensuring data integrity and lineage. You will trace complex ETL processes, document dependencies, and collaborate with stakeholders across architecture reviews, testing, and production cutover.

Strong SQL, Teradata, Oracle, and Snowflake experience required; 12+ months contract with remote/hybrid options.

Qualifications

• Strong SQL Server and Teradata skills with the ability to trace complex tables, views, stored procedures, SSIS packages, and SQL Agent jobs.
• Analytical and problem-solving skills required.
• Ability to document end-to-end data lineage, dependencies, risks, decisions clearly.
• Experience across SQL Server, Teradata, Oracle, and Snowflake environments.
• Capable of tracing data lineage, reverse engineering ETL processes, and migrating business-critical data and reporting logic between platforms after onboarding.
• Strong communication skills and ability to work with project leadership, technical teams, and business stakeholders.
• Experience supporting architecture reviews, validation testing, historical data migration, production cutover, and implementation activities.
• Strong background delivering accurate migration results while preserving existing business logic and reporting behaviour.

Responsibilities

• Move SQL Server tables and SSIS jobs to Teradata or Snowflake.
• Trace ETL processes and maintain data integrity during migration.
• Document data lineage, dependencies, risks, and decisions clearly.
• Collaborate with project leadership, technical teams, and business stakeholders.
• Support architecture reviews, validation testing, and production cutover activities.
• Preserve existing business logic and reporting behaviour during migration.

Skills

SQL Server

Teradata

SSIS

Oracle

Snowflake

Data Migration

Data Lineage

SQL Development

Query Optimization

ETL

Tools

SQL Agent

Informatica

ETL Tools

Data Warehouse

Job description

Duration: 12+ Months Contract

Job Description

data engineering to move SQL server tables and ssis jobs to Teradata or snowflake.

• strong SQL server and Teradata technical skills and ability to trace complex tables, views, stored procedures, SSIS packages, and SQL agent jobs.
• very good analytical skills and problem-solving ability a must.
• ability to document end-to-end data lineage, dependencies, risks, decisions clearly.
• experience working across SQL server, Teradata, oracle, and snowflake environments.
• must be capable of independently tracing data lineage, reverse engineering etl processes, and migrating business-critical data and reporting logic between platforms after onboarding.
• strong communication skills and ability to work with project leadership, technical teams, and business stakeholders.
• experience supporting architecture reviews, validation testing, historical data migration, production cutover, and implementation activities.
• strong background delivering accurate migration results while preserving existing business logic and reporting behaviour.

Duration: 12+ Months Contract

Job Description

Summary

data engineering to move SQL server tables and ssis jobs to Teradata or snowflake.

Desired profile

• strong SQL server and Teradata technical skills and ability to trace complex tables, views, stored procedures, SSIS packages, and SQL agent jobs.
• very good analytical skills and problem-solving ability a must.
• ability to document end-to-end data lineage, dependencies, risks, decisions clearly.
• experience working across SQL server, Teradata, oracle, and snowflake environments.
• must be capable of independently tracing data lineage, reverse engineering etl processes, and migrating business-critical data and reporting logic between platforms after onboarding.
• strong communication skills and ability to work with project leadership, technical teams, and business stakeholders.
• experience supporting architecture reviews, validation testing, historical data migration, production cutover, and implementation activities.
• strong background delivering accurate migration results while preserving existing business logic and reporting behaviour.

Must have

Experience with SSIS packages and SQL agent jobs; strong SQL development and query optimization in Teradata, oracle, and SQL server; data lineage and dependency analysis; reverse engineering legacy etl Processes; data migration and modernization; data validation and reconciliation testing; cross-platform SQL conversion.

Good to have

snowflake, oracle SQL, informatica, etl tools, data warehouse experience, railroad / transportation / logistics experience, production cutover support

About US Tech Solutions

US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.

US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

AI Statement

By applying, you acknowledge that AI-assisted tools may be used during hiring.