Data Engineer – SSIS Migration & Modernization | Diverselynx | Plano, TX

Diverselynx; Plano (TX); On-site; USD 135,000 - 145,000; Full time

Job summary

Diverselynx is seeking a Data Engineer specializing in SSIS Migration & Modernization to join our Plano, TX team on a long-term contract. You will analyze legacy SSIS packages, design cloud migration roadmaps, and build reusable frameworks for successful data platform migrations.

You will lead end-to-end migration testing and deployment, develop robust data pipelines, and collaborate with data architects, DBAs, and stakeholders to ensure data quality and high performance in enterprise

Qualifications

• Bachelor’s degree in computer science, information technology, software engineering, data analytics, or related field.

Responsibilities

• Analyze, audit, and assess existing SSIS packages, ETL workflows, and system dependencies.
• Design migration strategies for legacy SSIS workloads to cloud-based platforms.
• Refactor ETL logic and stored procedures while preserving data integrity.
• Develop migration accelerators and reusable data frameworks for cloud onboarding.
• Perform end-to-end data migration testing, deployment, and production support.
• Design scalable data pipelines for ingestion, transformation, and orchestration.
• Implement data quality, error handling, logging, and validation across pipelines.
• Collaborate with data architects, DBAs, and stakeholders in Plano, TX.

Skills

SSIS Expertise

Advanced SQL

Python

ETL Development

Data Warehousing

Cloud Migration

Stakeholder Coordination

Education

Bachelor’s degree in Computer Science/IT/Engineering

Tools

Azure Data Factory

AWS Glue

Snowflake

Databricks

Apache Airflow

Docker

Kubernetes

GitHub Actions

Job description

Position Summary

Diverselynx is seeking an experienced, highly technical, and accomplished Data Engineer specializing in SSIS Migration and Modernization to join our client team on a long-term contract basis in Plano, TX. In this specialized data engineering and ETL migration role, you will spearhead analyzing existing SQL Server Integration Services (SSIS) packages, designing comprehensive cloud migration strategies, and re-engineering legacy ETL workloads for modern enterprise data platforms. You will work closely with cross-functional data architects, database administrators, and software development squads to build scalable data pipelines, reusable migration frameworks, and robust automation solutions. Ideal candidates bring a strong academic background in computer science or information technology, deep practical mastery of SSIS and cloud data warehousing, and immediate availability for long-term contract engagement.

Detailed Job Description

As a Data Engineer – SSIS Migration & Modernization at Diverselynx in Plano, TX, you will take full ownership of assessing, re-engineering, and modernizing complex ETL workflows and data integration architectures. Your day-to-day responsibilities encompass analyzing legacy SSIS packages and dependencies, formulating cloud-native migration roadmaps, developing custom migration accelerators and reusable frameworks, and executing end-to-end data pipeline migration, testing, and production deployment. You will design batch and near-real-time data ingestion pipelines, implement rigorous data quality and validation frameworks, and optimize data transformation logic. Working in a fast-paced enterprise consulting environment, you will troubleshoot pipeline failures, ensure high data fidelity, and collaborate closely with stakeholders to deliver secure, high-performance data platforms.

Key Responsibilities

• Analyze, audit, and assess existing SQL Server Integration Services (SSIS) packages, ETL workflows, and system dependencies.
• Design and execute comprehensive migration strategies for legacy SSIS workloads to modern cloud-based or enterprise data platforms.
• Re-engineer complex ETL logic and stored procedures while preserving core business functionality and data integrity.
• Develop custom migration accelerators, reusable data frameworks, and automation solutions to streamline cloud onboarding.
• Perform end-to-end data migration testing, validation, deployment, monitoring, and ongoing production support.
• Design and build scalable, high-performance data pipelines for ingestion, transformation, and orchestration.
• Implement robust data quality, error handling, logging, and validation frameworks across all data workflows.
• Support both batch and near-real-time data processing requirements across enterprise data warehouses and lakes.
• Collaborate closely with data architects, database administrators, and business stakeholders in Plano, TX.
• Maintain comprehensive technical documentation, data lineage maps, pipeline runbooks, and migration progress reports.

Required Qualifications & Skills

• Bachelor’s degree in Computer Science, Information Technology, Software Engineering, Data Analytics, or a related field.
• Minimum 5+ years of professional experience in data engineering, ETL development, and database systems.
• Deep specialized expertise in SSIS (SQL Server Integration Services) package analysis, refactoring, and modernization.
• Proven experience executing legacy ETL migration projects to modern cloud platforms (e.g., Azure Data Factory, AWS Glue, Snowflake, Databricks).
• Strong programming proficiency in advanced SQL, T-SQL, Python, or Scala for data pipeline development.
• Solid foundation in data warehousing concepts, schema design, data lakes, and distributed data processing.
• Experience implementing data quality frameworks, automated testing, and validation checks in ETL pipelines.
• Strong analytical, problem-solving, stakeholder coordination, and cross-functional communication skills.
• Professional availability for long-term contract engagement in Plano, TX.

Nice-to-Have Skills

• Professional certifications such as Microsoft Certified: Azure Data Engineer Associate or AWS Certified Data Analytics.
• Hands-on experience with Microsoft Azure data stack including Azure SQL, Azure Synapse Analytics, and ADF.
• Familiarity with containerization (Docker, Kubernetes) and CI/CD deployment pipelines (GitHub Actions, Azure DevOps).
• Experience working with modern data orchestration tools (e.g., Apache Airflow, Prefect).
• Prior consulting experience in enterprise IT services or financial services environments.

Application Information

• Recruiter: Diverselynx Recruitment Team
• Contact Name: Ratan Mehta (Technical Recruiter / Connector)
• Email: [e-mail]
• Phone: Unspecified
• Application URL: Unspecified
• Salary/Rate: $65/Hr - $70/Hr (Commensurate with experience)
• Deadline: Open until filled
• Notice Period: Immediate to short notice preferred
• Contract Duration: Long-Term Contract (Plano, TX)

Recruitment Pro Tip

When applying for SSIS migration and ETL modernization contracts, ensure your resume explicitly highlights your experience refactoring legacy packages, migrating workloads to cloud data platforms, and handling large-scale data validation.