At a Glance
- Tasks: Lead the development and optimisation of data integration solutions using SSIS and Azure Data Factory.
- Company: Join a dynamic team in Leatherhead, focused on impactful enterprise-wide data systems.
- Benefits: Enjoy hybrid work options and the chance to influence system design and delivery quality.
- Why this job: Be part of a collaborative team where your skills directly drive business success and innovation.
- Qualifications: Deep experience with SSIS, SQL Server, and Azure Integration Services is essential.
- Other info: Occasional travel to other offices or project sites may be required.
The predicted salary is between 36000 - 60000 £ per year.
We're Hiring: SSIS Expert / Integrations Engineer
Location: Leatherhead (Hybrid) | Type: Full-Time
Are you an SSIS expert looking for a high-impact role where your skills will directly drive the success of business-critical systems? We’re looking for a skilled Integrations Engineer to lead the development, support, and optimisation of enterprise-wide data integration solutions—and to act as a trusted deputy to the Integration Manager.
About the Role
You’ll take ownership of maintaining and improving integration pipelines, proactively resolving issues, and leading design and development initiatives using SSIS and Azure Data Factory. You'll also be the technical point of contact across multiple teams and act as 3rd line support for escalated incidents.
What You'll Do
- Configure and manage SSIS integrations, ensuring accurate and secure data transfers
- Monitor, troubleshoot, and resolve integration issues, managing a ticket queue (e.g., via ServiceNow)
- Lead the design of new and existing data pipelines, adhering to change control processes
- Collaborate with stakeholders—including BAs, PMs, Architects, and Infrastructure teams
- Deputise for the Integration Manager during technical meetings, escalations, or design reviews
- Ensure integrations are secure, compliant, and well-documented
What We’re Looking For
- Deep experience with SSIS and SQL Server in an enterprise environment
- Strong proficiency in T-SQL, stored procedures, and complex ETL logic
- Familiar with Azure Integration Services (e.g., Logic Apps, ADF, Service Bus, Functions)
- Comfortable working with Git, Azure DevOps, and unit testing practices
- Knowledge of common data formats: CSV, JSON, XML, Parquet
- Ability to lead integration designs with minimal rework required
Preferred Qualifications
- Certification in SSIS or relevant Microsoft technologies
- Proven track record of delivering robust integration solutions
Key Skills & Traits
- Clear and confident communicator across technical and non-technical teams
- Detail-oriented with a strong focus on accuracy and performance
- Excellent problem-solving, time management, and documentation skills
- Able to juggle multiple integration workflows and priorities
- Strong sense of ownership and a passion for continuous improvement
Why This Role?
This is a great opportunity to be part of a collaborative, technically strong team where you’ll have real influence over system design, data architecture, and delivery quality. Occasional travel may be required to other company offices or project sites.
Sound like a good fit? Apply now or message us directly to explore how you can make an impact.
Integration Engineer employer: JCW
Contact Detail:
JCW Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Integration Engineer
✨Tip Number 1
Familiarise yourself with the latest features and updates in SSIS and Azure Data Factory. Being well-versed in these tools will not only boost your confidence during discussions but also demonstrate your commitment to staying current in the field.
✨Tip Number 2
Network with professionals in the integration space, especially those who have experience with SSIS and SQL Server. Engaging in relevant online forums or local meetups can provide valuable insights and connections that may help you stand out.
✨Tip Number 3
Prepare to discuss specific examples of how you've successfully managed integration projects in the past. Highlighting your problem-solving skills and ability to lead design initiatives will resonate well with the hiring team.
✨Tip Number 4
Showcase your communication skills by being clear and concise when discussing technical concepts. The role requires collaboration with both technical and non-technical teams, so demonstrating your ability to bridge that gap will be a plus.
We think you need these skills to ace Integration Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SSIS, SQL Server, and Azure Integration Services. Use specific examples of past projects where you successfully managed data integration solutions.
Craft a Compelling Cover Letter: In your cover letter, express your passion for data integration and how your skills align with the role. Mention your ability to lead design initiatives and collaborate with various teams, as these are key aspects of the job.
Showcase Technical Skills: Clearly outline your technical skills in T-SQL, ETL logic, and familiarity with Git and Azure DevOps. Providing concrete examples of how you've used these skills in previous roles will strengthen your application.
Highlight Problem-Solving Abilities: Demonstrate your problem-solving skills by including examples of how you've resolved integration issues in the past. This will show your potential employer that you can handle challenges effectively.
How to prepare for a job interview at JCW
✨Showcase Your SSIS Expertise
Be prepared to discuss your experience with SSIS in detail. Highlight specific projects where you successfully implemented SSIS solutions, focusing on the challenges you faced and how you overcame them.
✨Demonstrate Problem-Solving Skills
Expect to be asked about troubleshooting integration issues. Prepare examples of past incidents you've resolved, detailing your thought process and the steps you took to find a solution.
✨Communicate Clearly
As this role involves liaising with various teams, practice explaining technical concepts in simple terms. This will show your ability to communicate effectively with both technical and non-technical stakeholders.
✨Prepare for Technical Questions
Brush up on your knowledge of T-SQL, ETL processes, and Azure Integration Services. Be ready to answer questions or even solve problems on the spot to demonstrate your technical proficiency.