Skip to main content

Senior Data Engineer (SSIS to ADF Migration)

Cumberland, GA 30339

Posted: 01/29/2025 Job Number: 2963

Job Description

Senior Data Engineer - SSIS to ADF Migration - Job Description:

We are seeking a highly experienced Senior Data Engineer for a short-term 2-3 month contract to support a critical cloud migration initiative. The ideal candidate will have strong expertise in SQL Server, SSIS (SQL Server Integration Services), and Azure Data Factory (ADF) to assist in migrating legacy SSIS packages and stored procedures from an out-of-support SQL Server 2016 environment to a modern Azure-based data platform.

This role requires hands-on technical expertise, problem-solving skills, and a deep understanding of data migration best practices. The candidate should be comfortable working independently and collaborating with internal stakeholders, including data architects and business analysts, to ensure a smooth transition.

Key Responsibilities:
  • Assess, analyze, and document existing SSIS packages, stored procedures, and legacy ETL processes running on SQL Server 2016.
  • Design and implement migration strategies to modernize and rebuild SSIS workflows using Azure Data Factory (ADF).
  • Refactor and optimize T-SQL stored procedures and SQL-based transformations for cloud compatibility and performance.
  • Develop, test, and deploy ADF pipelines to replace existing SSIS-based ETL processes.
  • Ensure data integrity, security, and performance efficiency during the migration process.
  • Troubleshoot, debug, and optimize data workflows to ensure stability in the cloud environment.
  • Collaborate with data architects, cloud engineers, and business analysts to align migration efforts with business goals.
  • Document all migration steps, configurations, and post-migration validation processes.
  • Provide knowledge transfer and technical guidance to internal teams for long-term sustainability.
Required Qualifications & Experience:
  • 8+ years of experience in data engineering and ETL development.
  • Strong expertise in SQL Server (2016 & later), SSIS (SQL Server Integration Services), and T-SQL development.
  • Proven experience migrating SSIS packages to Azure Data Factory (ADF).
  • Deep knowledge of Azure cloud data services, including Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics.
  • Hands-on experience optimizing stored procedures, indexing strategies, and performance tuning for cloud-based SQL environments.
  • Experience working with data transformation, data cleansing, and ETL pipeline development.
  • Familiarity with PowerShell, Python, or C# scripting for automation is a plus.
  • Strong problem-solving skills and ability to work independently with minimal supervision.
  • Excellent communication skills to document processes and collaborate with stakeholders.
Preferred Qualifications:
  • Experience in real estate, property management, or financial services industries.
  • Knowledge of data governance, compliance, and security best practices in cloud environments.
  • Exposure to DevOps & CI/CD pipelines for data engineering (e.g., Azure DevOps, Git, Terraform).

Job Requirements

SQL,Azure,ETL,ADF,Azure Data Factory,SQL Server, SSIS

Meet Your Recruiter

Rick Mewborn

I'm happy to connect with you on your next career challenge. Whatever your needs are, we at Resolution Technologies promise to provide unrivaled quality and service. Please don't hesitate to contact me if you have any questions about this position.            

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Cumberland, GA

Ready to find your next career opportunity in the vibrant area of Cumberland, Georgia? Nestled in the heart of Cobb County, Cumberland beckons with its unique blend of urban amenities and scenic beauty. This bustling region offers job seekers a chance to thrive in a dynamic community filled with charming landmarks like the iconic Battery Atlanta, delicious Southern cuisine, and renowned art galleries such as the Marietta/Cobb Museum of Art. Home to the Cobb Energy Performing Arts Centre and SunTrust Park, the area also boasts cultural delights and entertainment options for all. Join us in exploring job listings in Cumberland, GA, and discover why this flourishing area is the perfect place to grow both personally and professionally.