Data Modernization Engineer: SQL to Snowflake/Teradata

Astir IT Solutions, Inc.; Omaha (NE); On-site; USD 100,000 - 140,000; Full time

Job summary

Astir IT Solutions, Inc. is seeking a Data Engineer to modernize and migrate data assets from SQL Server/SSIS to Teradata and Snowflake, with on-site work in Omaha, NE.

The role involves tracing data lineage, validating migrations, and preserving business logic. The ideal candidate has 5+ years of Data Engineering experience, hands-on SSIS/SQL Agent, and strong cross-platform SQL skills across SQL Server, Teradata, Oracle, and Snowflake.

Qualifications

• 5+ years of experience as a Data Engineer.
• Hands-on experience with SSIS packages and SQL Agent jobs.
• Advanced SQL development and query optimization across SQL Server, Teradata, and Oracle.
• Experience with data lineage analysis, dependency tracing, and reverse engineering legacy ETL processes.
• Proven background in data migration and modernization involving critical data and reporting logic.
• Experience with data validation, reconciliation testing, and migration QA.
• Must be onshore and able to work onsite in Omaha, NE.

Responsibilities

• Analyze and reverse engineer legacy SQL Server, SSIS packages, stored procedures, views, tables, and SQL Agent jobs to understand data flows and business logic.
• Lead data engineering activities to migrate SQL Server tables and ETL workloads to Teradata and/or Snowflake.
• Trace and document end-to-end data lineage, upstream/downstream dependencies, risks, assumptions, and migration decisions.
• Perform cross-platform SQL conversion across SQL Server, Teradata, Oracle, and Snowflake while preserving performance and reporting behavior.
• Optimize SQL queries and data processing for scalability across multiple platforms.
• Collaborate with architects, leadership, and stakeholders to validate requirements and migration outcomes.
• Support migration planning, sequencing, and implementation strategy.
• Execute data validation, reconciliation, and testing to ensure data integrity.
• Assist with historical data migration, production cutover, and post-deployment support.
• Proactively identify issues and deliver clear technical documentation.

Skills

SSIS Packages

SQL Agent Jobs

Advanced SQL Development

Data Migration & Modernization

Data Lineage & Dependency Tracing

Cross-Platform SQL Conversion

Teradata

Snowflake

Oracle

Tools

Teradata

Snowflake

Informatica

Job description

Astir IT Solutions, Inc. is seeking a Data Engineer to modernize and migrate data assets from SQL Server/SSIS to Teradata and Snowflake, with on-site work in Omaha, NE.

The role involves tracing data lineage, validating migrations, and preserving business logic. The ideal candidate has 5+ years of Data Engineering experience, hands-on SSIS/SQL Agent, and strong cross-platform SQL skills across SQL Server, Teradata, Oracle, and Snowflake.