Data Engineer (Data Migration, ETL & SQL Modernization) | eRay Technologies | Remote / Omaha, Nebraska Preferred

eRay Technologies; Omaha (NE); Remote; USD 90,000 - 130,000; Full time

Job summary

eRay Technologies is seeking an experienced Data Engineer to support large-scale data migration, ETL modernization, and data platform transformation initiatives. You will analyze legacy data environments, map data lineage, optimize SQL workloads, and drive migrations across SQL Server, Teradata, Oracle, and Snowflake.

Remote work is available with a preference for candidates who can work onsite in Omaha, Nebraska.

Qualifications

• 4–10 years of experience as a Data Engineer.
• Experience with SSIS and SQL Server Integration Services.
• Proven track record in data migration and ETL modernization.
• Strong SQL development and query optimization skills.
• Experience with cross-platform migrations (SQL Server, Teradata, Oracle, Snowflake).

Responsibilities

• Design, develop, and optimize ETL workflows and data integrations.
• Develop and support SSIS packages and SQL Agent jobs.
• Analyze complex SQL queries and tune database workloads.
• Perform data lineage analysis and dependency mapping.
• Support migration from legacy platforms to modern cloud analytics environments.
• Create migration artifacts and technical documentation.

Skills

SSIS

SQL development

Data lineage

ETL

SQL tuning

Migration programs

Snowflake

Teradata

Oracle

SQL Agent

Data quality

Documentation

Tools

SSIS

SQL Server

Teradata

Oracle

Snowflake

Job description

Job Title: Data Engineer (Data Migration, ETL & SQL Modernization) | eRay Technologies | Remote / Omaha, Nebraska Preferred

Recruiting Company:

eRay Technologies

Job Location:

Remote (Preference for candidates able to work onsite in Omaha, Nebraska, USA)

Job Type:

Contract / Full-Time (Not Specified)

Interview Process:

• Telephonic Interview
• Video Interview

Additional Information:

• Experience Required: 5+ Years (4–10 Years Preferred)
• Remote Opportunity
• Data Migration & Modernization Focus
• Strong SQL and ETL Expertise Required

Position Summary

eRay Technologies is seeking an experienced Data Engineer to support large-scale data migration, ETL modernization, and data platform transformation initiatives. The role focuses on analyzing legacy data environments, understanding complex data lineage, optimizing SQL workloads, and supporting the migration of business-critical data assets across multiple database platforms.

Detailed Job Description

As a Data Engineer, you will be responsible for designing, analyzing, optimizing, and modernizing enterprise data pipelines and database environments. You will work with stakeholders, architects, business analysts, and development teams to understand legacy data implementations, trace dependencies, and ensure successful migration to modern data platforms.

The successful candidate will possess deep expertise in ETL processes, SQL development, data lineage analysis, and cross-platform database migrations involving SQL Server, Teradata, Oracle, and Snowflake. You will play a critical role in ensuring data quality, migration accuracy, and minimal business disruption during modernization programs.

Key Responsibilities

• Design, develop, and maintain ETL workflows and data integration processes.
• Develop and support SSIS packages and SQL Agent jobs.
• Analyze and optimize complex SQL queries and database workloads.
• Perform data lineage analysis and dependency mapping across enterprise systems.
• Reverse engineer legacy ETL processes, reports, and integration workflows.
• Support enterprise data migration and modernization initiatives.
• Trace dependencies within tables, views, stored procedures, and job scheduling systems.
• Conduct data validation, reconciliation testing, and quality assurance activities.
• Support migration from legacy platforms to modern cloud and analytics environments.
• Identify migration risks and recommend mitigation strategies.
• Participate in architecture reviews and technical design discussions.
• Support cutover activities, implementation planning, and post-migration validation.
• Create comprehensive technical documentation and migration artifacts.

Required Qualifications & Skills

• 4–10 years of experience as a Data Engineer.
• Strong hands‑on experience with SSIS (SQL Server Integration Services).
• Experience managing and troubleshooting SQL Agent jobs.
• Advanced SQL development expertise.
• Strong experience with:
• Microsoft SQL Server
• Teradata
• Oracle Database
• Experience performing SQL tuning and query optimization.
• Strong expertise in data lineage analysis and dependency tracing.
• Experience reverse engineering complex ETL and reporting processes.
• Proven experience supporting enterprise data migration programs.
• Strong understanding of data validation and reconciliation methodologies.
• Experience with migration quality assurance and production cutovers.
• Ability to analyze complex database objects including:
• Tables
• Views
• Stored Procedures
• Functions
• SSIS Packages
• Scheduled Jobs
• Excellent analytical and problem-solving skills.
• Strong technical documentation and communication abilities.

Preferred Qualifications

• Experience with Snowflake migrations and modernization programs.
• Knowledge of cloud data platforms and modern analytics architectures.
• Experience supporting large-scale enterprise reporting environments.
• Familiarity with data governance and data quality frameworks.
• Experience participating in architecture reviews and technical assessments.
• Ability to independently own discovery and analysis activities after onboarding.

Ideal Candidate Background

• Data Engineer
• ETL Developer
• Data Migration Engineer
• Data Warehouse Engineer
• SQL Developer
• Data Integration Specialist
• Data Modernization Consultant
• BI/Data Platform Engineer

Recruitment Pro Tip

For this position, highlight specific projects involving SSIS development, SQL optimization, Teradata-to-Snowflake migrations, Oracle modernization, data lineage analysis, ETL reverse engineering, and reconciliation testing. Hiring managers will be especially interested in candidates who can demonstrate ownership of complex migration initiatives and quantify business impacts such as reduced migration risk, improved data quality, enhanced query performance, or successful production cutovers.