Integrations Engineer

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.

• 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.

• 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.

• SSIS certification (preferred).

• 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.

• 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.

• 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 include 26 weeks fully paid maternity, 8 weeks fully paid paternity.

Wates is one of the UK's leading family-owned development, building and property maintenance companies. Founded over 125 years ago, we have a proud legacy in the built environment. We are driven by our purpose, 'reimagining places for people to thrive' and our three promises:

• Thriving places - working with customers, partners and communities to create places that are more sustainable, inclusive, and full of opportunity.
• Thriving planet - protecting nature and taking action on climate change by collaborating and innovating with our partners.
• Thriving people - creating opportunities and relationships so that everyone who works for and with us feels included, invested in, and treated with care.