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 data integration for business success.
- Benefits: Enjoy hybrid working, collaborative culture, and opportunities for professional growth.
- Why this job: Make a real impact on system design and data architecture while working with cutting-edge technologies.
- Qualifications: Expertise in SSIS, SQL Server, and familiarity with Git and Azure DevOps required.
- Other info: Occasional travel to other offices or project sites may be necessary.
The predicted salary is between 36000 - 60000 £ per year.
We’re hiring 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.
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.
- Configure and manage SSIS integrations, ensuring accurate and secure data transfers via ServiceNow.
- Lead the design of new and existing data pipelines, adhering to change control processes.
- Deep experience with SSIS and SQL Server in an enterprise environment.
- Comfortable working with Git, Azure DevOps, and unit testing practices.
- Knowledge of common data formats: CSV, JSON, XML, Parquet.
- Certification in SSIS or relevant Microsoft technologies.
- Detail-oriented with a strong focus on accuracy and performance.
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.
Locations
Integration Developer - SQL, Ssis employer: JCW
Contact Detail:
JCW Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Integration Developer - SQL, Ssis
✨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 and data engineering space. Attend relevant meetups or webinars, and connect with people on LinkedIn who work at StudySmarter or similar companies. This can provide you with insider knowledge and potentially a referral.
✨Tip Number 3
Prepare to discuss specific projects where you've successfully implemented SSIS solutions. Be ready to explain your role, the challenges faced, and how you optimised data integration processes. Real-world examples can set you apart from other candidates.
✨Tip Number 4
Showcase your problem-solving skills by preparing for scenario-based questions. Think about common issues that arise in data integration and how you would approach resolving them. This will highlight your analytical thinking and technical expertise.
We think you need these skills to ace Integration Developer - SQL, Ssis
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SSIS, SQL Server, and any relevant Microsoft technologies. Use specific examples of projects where you've successfully implemented data integration solutions.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention how your skills align with the job requirements, particularly your experience with Azure Data Factory and managing integration pipelines.
Showcase Relevant Certifications: If you have certifications in SSIS or other Microsoft technologies, be sure to mention them prominently in your application. This can set you apart from other candidates.
Highlight Problem-Solving Skills: Provide examples in your application that demonstrate your ability to proactively resolve issues and improve processes. This is crucial for a role that involves maintaining and optimising integration solutions.
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 data integration solutions, and be ready to explain the challenges you faced and how you overcame them.
✨Demonstrate Problem-Solving Skills
Since the role involves resolving issues proactively, think of examples where you've identified and fixed problems in integration pipelines. Use the STAR method (Situation, Task, Action, Result) to structure your responses.
✨Familiarise Yourself with Azure Data Factory
As this position requires knowledge of Azure Data Factory, brush up on its features and functionalities. Be ready to discuss how you've used it in past roles or how you would approach using it for new projects.
✨Prepare for Technical Questions
Expect technical questions related to SQL Server, data formats like CSV and JSON, and version control systems like Git. Review common scenarios and best practices to demonstrate your technical proficiency during the interview.