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, collaborative culture, and opportunities for professional growth.
- Why this job: Make a real impact on system design and data architecture while working with a skilled team.
- 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.
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.
Locations
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 interviews but also demonstrate your commitment to staying current in the field.
✨Tip Number 2
Network with professionals in the integration space, especially those who work with SSIS and Azure services. Engaging in relevant online forums or local meetups can provide valuable insights and connections that may lead to job opportunities.
✨Tip Number 3
Prepare to discuss specific examples of past projects where you successfully led integration designs or resolved complex issues. Highlighting your problem-solving skills and ability to manage multiple workflows will set you apart from other candidates.
✨Tip Number 4
Research StudySmarter’s current integration projects and challenges. Tailoring your conversation during interviews to show how your skills can directly address their needs will demonstrate your genuine interest in the role and the company.
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 led integration designs or resolved complex issues.
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 communicate effectively with both technical and non-technical teams, as this is crucial for the position.
Showcase Relevant Skills: Clearly list your proficiency in T-SQL, stored procedures, and ETL logic. Highlight any certifications in SSIS or Microsoft technologies, as well as your familiarity with Git and Azure DevOps.
Prepare for Technical Questions: Be ready to discuss your experience with integration pipelines and troubleshooting methods. Think of specific scenarios where you successfully managed integration workflows or improved data transfer processes.
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've 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 approach and the tools you used, such as ServiceNow for ticket management.
✨Communicate Clearly
As a potential deputy to the Integration Manager, strong communication skills are essential. Practice explaining complex technical concepts in simple terms, as you'll need to collaborate with both technical and non-technical teams.
✨Prepare for Technical Questions
Brush up on your knowledge of T-SQL, stored procedures, and ETL logic. Be ready to answer questions or even solve problems on the spot that demonstrate your technical proficiency and understanding of data integration.