Senior SSIS Developer

Job Description

We are seeking a Senior SSIS Developer for a long-term contract position to support public sector IT projects. The ideal candidate must be highly proficient in SQL Server Integration Services (SSIS) and have strong experience working with complex SQL queries, SQL Server Agent (SSA), and legacy systems such as mainframe and Lotus Notes applications.

This role requires deep technical expertise, the ability to analyze complex systems, and the discipline to work independently in a remote environment. Prior experience in public sector IT projects is mandatory.

Responsibilities

• Design, develop, deploy, and support robust SSIS packages to extract, transform, and load (ETL) data from various sources.
• Write and optimize complex SQL queries, stored procedures, and functions.
• Manage, schedule, and troubleshoot SQL Server Agent jobs.
• Migrate and integrate data from mainframe systems and Lotus Notes applications into modern databases.
• Collaborate with stakeholders to gather requirements and ensure timely delivery of technical solutions.
• Perform data validation, profiling, and performance tuning.
• Document system design, processes, and data flows.
• Maintain a high level of security and data integrity in line with public sector standards.

Required Qualifications

• Minimum 8 years of hands-on experience with SSIS development.
• Proven expertise in writing and optimizing complex SQL queries.
• Experience with SQL Server Agent for job scheduling and monitoring.
• Prior experience working on public sector IT projects.
• Strong understanding of mainframe systems and Lotus Notes applications integration.
• Ability to troubleshoot and resolve issues in a timely manner.
• Excellent communication and documentation skills.
• Self-motivated and able to work effectively in a 100% remote environment.