Integration Engineer (SSIS)

Integration Engineer (SSIS) - Leatherhead (Hybrid) - £40,000-£50,000

My client is a UK based consutruction company. They are searching for an experienced Integration Engineer to support the 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. Requirements:

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.
Ability to produce clear, concise, and unambiguous documentation.
Strong interpersonal skills with the ability to develop good working relationships with business users and suppliers.
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.
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. Qualifications

SSIS certification (preferred). Benefits:

Profit share scheme
Flexible working
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. Integration Engineer (SSIS) - Leatherhead (Hybrid) - £40,000-£50,000

Damia Group Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept our Data Protection Policy which can be found on our website.

Please note that no terminology in this advert is intended to discriminate on the grounds of a person's gender, marital status, race, religion, colour, age, disability or sexual orientation. Every candidate will be assessed only in accordance with their merits, qualifications and ability to perform the duties of the job.

Damia Group is acting as an Employment Business in relation to this vacancy and in accordance to Conduct Regulations 2003