Description

You will lead the migration of legacy SQL Server metrics and ETL processes to modern data platforms, ensuring data integrity and business logic preservation.

This role is hybrid.

Responsibilities

• Reverse engineer legacy ETL processes, tracing complex tables, views, stored procedures, SSIS packages, and SQL Agent jobs.
• Perform data lineage and dependency analysis to document end-to-end data flows, risks, and decisions.
• Migrate business-critical data and reporting logic between SQL Server, Teradata, Oracle, and Snowflake environments.
• Conduct data validation and reconciliation testing to ensure accurate migration results.
• Support production cutover, historical data migration, and architecture reviews.

Required Skills

• Strong SQL development and query optimization in Teradata, Oracle, and SQL Server.
• Hands-on experience with SSIS packages and SQL Agent jobs.
• Proven ability to reverse engineer legacy ETL and trace dependencies independently.
• Experience working across SQL Server, Teradata, Oracle, and Snowflake.
• Strong analytical and problem-solving abilities.
• 10+ years of experience in data engineering or related fields.

Preferred Skills

• Experience with Informatica, Oracle SQL, and general ETL tools.
• Data warehouse experience and railroad/transportation/logistics domain knowledge.
• Ability to communicate effectively with project leadership and technical teams.

Key Skills

Education

Any Graduate