Senior Data Engineer (SSIS to ADF Migration)

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).