Data Engineer

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

Role : Data Engineer With Data Modernization (W2 Position )

Location: Omaha, NE (Onsite - 5 days a week)

Exp : 5+ Years

Need Resource from railroads domain Background .

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.