SSIS Developer

SSIS Developer

London- Hybrid- 3 days on-site per week

6 months +

UMBRELLA only- Inside IR35

Experienced SSIS Developer to design, develop, and maintain robust ETL processes using SQL Server Integration Services (SSIS). The ideal candidate will work closely with business analysts, data architects, and stakeholders to ensure reliable data integration, transformation, and delivery across enterprise systems.

• Key Responsibilities
• Design, develop, test, and deploy ETL packages using SSIS to extract, transform, and load data from multiple sources into data warehouses, data marts, or operational systems.
• Optimize and troubleshoot existing SSIS packages for performance, scalability, and reliability.
• Develop and maintain SQL queries, stored procedures, functions, and views to support ETL and reporting processes.
• Implement error handling, logging, and auditing within SSIS packages.
• Schedule and automate ETL jobs using SQL Server Agent or equivalent job schedulers.
• Collaborate with data architects and business analysts to understand business requirements and translate them into technical solutions.
• Perform data validation and quality checks to ensure integrity and accuracy across systems.
• Provide support for production deployments, monitoring, and issue resolution.
• Maintain documentation for ETL processes, data flows, and technical designs.

Required Qualifications

• Proven hands-on experience with Microsoft SQL Server Integration Services (SSIS).
• Strong knowledge of T-SQL (queries, stored procedures, functions, indexing, performance tuning).
• Experience working with relational databases (SQL Server, Oracle, etc.) and flat file/CSV/XML/JSON data sources.
• Strong understanding of ETL design patterns, data warehousing concepts.
• Experience with SQL Server Agent or other scheduling tools.
• Strong troubleshooting and problem-solving skills.

Preferred Skills

• Familiarity with Azure Data Factory (ADF), SSRS, SSAS, or Power BI.
• Knowledge of data governance, security, and compliance practices.
• Exposure to DevOps, CI/CD pipelines, and version control tools (e.g., Git, Azure DevOps).
• Experience working in Agile/Scrum environments.

All profiles will be reviewed against the required skills and experience. Due to the high number of applications we will only be able to respond to successful applicants in the first instance. We thank you for your interest and the time taken to apply!