Data Migration Developer

We are seeking an experienced SQL Developer / Data Integration Specialist to design, develop, and maintain data solutions across SQL Server and Microsoft Dataverse environments. The role will focus heavily on SQL development, SSIS packages, and scheduled data integrations, with exposure to KingwaySoft migration tools and Microsoft Dynamics 365 Dataverse.

• Design, develop, and optimise SQL Server databases, queries, stored procedures, views, and functions

• Build, maintain, and support SSIS packages, including scheduling and monitoring via SQL Server Agent jobs

• Manage data integrations and migrations between SQL Server and Microsoft Dataverse using KingwaySoft

• Ensure data integrity, performance, and reliability across all integration processes

• Troubleshoot and resolve data-related issues, including failed jobs, performance bottlenecks, and data inconsistencies

• Collaborate with application, reporting, and business teams to understand data requirements

• Create and maintain technical documentation for data flows, jobs, and integrations

• Support deployment and release processes across development, test, and production environments

• Strong experience in SQL Server development (T-SQL, performance tuning, indexing)

• Proven hands-on experience with SSIS development, including package configuration and deployment

• Experience creating and managing SQL Server Agent jobs and schedules

• Practical experience using KingwaySoft for data migration or integration between SQL Server and Dataverse

• Strong understanding of ETL concepts and best practices