What are the responsibilities and job description for the Data Engineer - ETL and Data Modernization position at American Unit Inc.?
Title: Data Engineer - ETL and Data Modernization
Location: Omaha, NE (Onsite 5 days a week)
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-7 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.
Salary : $60 - $70