Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and develop ETL processes using SSIS to manage data integration.
- Company: Dynamic tech company in London with a hybrid work model.
- Benefits: Competitive pay, flexible working, and opportunities for professional growth.
- Why this job: Join a team that values innovation and make a real impact on data solutions.
- Qualifications: Experience with SSIS and strong SQL skills are essential.
- Other info: Collaborative environment with a focus on career advancement.
The predicted salary is between 36000 - 60000 £ per year.
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
Locations
SSIS Developer employer: Experis UK
Contact Detail:
Experis UK Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SSIS Developer
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and join online forums. You never know who might have the inside scoop on a job opening that’s perfect for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best ETL processes and SSIS projects. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common SSIS scenarios and troubleshooting techniques. Practise explaining your thought process when solving problems, as this will demonstrate your expertise and problem-solving skills.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities waiting for talented SSIS Developers like you. Plus, it’s a great way to ensure your application gets seen by the right people.
We think you need these skills to ace SSIS Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SSIS and T-SQL. We want to see how you've designed and developed ETL processes, so don’t hold back on those details!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for this role. Mention your collaboration with business analysts and data architects to show you understand the importance of teamwork.
Showcase Your Problem-Solving Skills: In your application, give examples of how you've optimised and troubleshot SSIS packages. We love candidates who can demonstrate their troubleshooting prowess and how they’ve tackled challenges in past projects.
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to keep track of your application and ensure it gets the attention it deserves. We can’t wait to hear from you!
How to prepare for a job interview at Experis UK
✨Know Your SSIS Inside Out
Make sure you brush up on your SSIS skills before the interview. Be ready to discuss your experience designing, developing, and maintaining ETL processes. Prepare examples of how you've optimised and troubleshot SSIS packages in the past.
✨T-SQL Mastery is Key
Since strong T-SQL knowledge is crucial for this role, practice writing queries, stored procedures, and functions. Be prepared to demonstrate your understanding of performance tuning and indexing during the interview.
✨Understand the Business Needs
Familiarise yourself with common business requirements related to data integration and transformation. Think about how you can translate these needs into technical solutions and be ready to discuss your collaborative experiences with business analysts and data architects.
✨Showcase Your Problem-Solving Skills
Prepare to share specific examples of how you've tackled challenges in previous projects. Highlight your troubleshooting techniques and how you've ensured data integrity and accuracy across systems, as this will resonate well with the interviewers.