NTERGRATION ENGINEER (SSIS) We are seeking an experienced Integration Engineer to support our Integration Manager in managing, maintaining, and developing our application integration solutions. This role involves proactively monitoring interfaces, acting as 3rd line support for resolving complex issues, and developing data integration pipelines using ETL tools such as SSIS & Azure Data Factory. As a key technical expert, you will take the lead in SSIS development, managing stakeholders and ensuring the integrity of the SSIS platform. You will be responsible for designing robust system integration solutions with minimal or no rework required by the Integration Manager. Key Responsibilities Provide day-to-day support for all SSIS integrations, including: Configuring SSIS to extract, transform, and load (ETL) data from various applications. Monitoring data flows and ensuring they are processed correctly. Identifying and resolving integration errors. Act as 3rd line support, taking ownership of complex incidents and problems while keeping the Integration Manager informed. Manage the ServiceNow queue for SSIS integrations, ensuring timely resolution of all issues within agreed SLAs. Act as a deputy for the Integration Manager, leading incident resolution, design, and development when necessary. Translate business requirements into robust technical integration solutions using SSIS & Azure Data Factory. Design and implement new interfaces while maintaining and fixing existing ones, always following Change Control processes. Collaborate on projects, contributing analytical, programming, and system expertise. Clearly communicate technical configurations and integration issues to Business Analysts, Project Managers, Architects, and Infrastructure Engineers. Knowledge Strong experience with ETL / ELT tools such as SSIS & Azure Data Factory. Ability to read and write SQL scripts and stored procedures. Good understanding of SQL Server Integration Services Catalog, SQL Agent, and Linked Servers. Knowledge of Azure Integration Services, including Logic Apps, Service Bus, API Management, Event Grid, Azure Functions, and Azure Data Factory. Experience using Source Control tools such as Git and Azure DevOps. Proficiency in SQL Server Data Tools (SSDT). Understanding of data formats: CSV, JSON, XML, Parquet. Qualifications SSIS certification (preferred). Skills & Competencies Excellent verbal and written communication skills. Ability to produce clear, concise, and unambiguous documentation. Strong interpersonal skills with the ability to develop good working relationships with business users and suppliers. Exceptional organizational skills and keen attention to detail. Ability to debug and fix errors in complex code. Proficiency in error handling and logging for future problem diagnosis. Strong analytical and problem-solving abilities. Ability to work independently and manage multiple projects simultaneously. Strong time management skills, capable of handling urgent requests professionally. Ability to switch seamlessly between different integration developments running in parallel. Ability to deliver integrations within project deadlines. Additional Information This role is based in Leatherhead but may require occasional travel to other offices, supplier offices, or project sites. The successful candidate must always act in accordance with the company's Zero Harm safety culture. Experienced Integration Engineer with expertise in SSIS, Azure Data Factory, and SQL Server. Hybrid working 2/3 days per week, working from home WHAT WE OFFER Competitive salary & bonus Flexible working Car Allowance / Company Car (subject to Role/Grade) Travel covered to any of our sites (subject to HMRC advisory rates) Extensive corporate benefits including, Private Medical, Pension 8% employers’ contribution, Health and Wellness programme, 26 days holidays bank holidays and much more… Excellent range of learning and development activity to support your career progression. Industry leading family leave benefits to included 26 weeks fully paid maternity, 8 weeks fully paid paternity. Given the nature of this position, you will need to undergo a Basic Disclosure and Barring Service Check (DBS) at offer stage. Applicants with criminal convictions will be assessed individually, and we assure you that we do not discriminate based on an applicant's criminal record or the details of any disclosed offenses. Additionally, certain roles may be subject to additional pre-employment checks. To learn more about the checks included in this process, please click on the following link: National Security Vetting