Job Description

Annual salary: up to £45,000.00

Integration Developer

Location: Remote (UK Based)

Contract: Full time, Permanent, 40 hours per week, 8:30am – 5pm, Monday to Friday

Salary: Up to £45,000 plus benefits

We are seeking a hands‑on Integration Developer with recent, proven, and demonstrable experience delivering SQL Server–based integrations in operational, transactional environments that run on schedules or triggers, move data between live systems, and require monitoring, incident handling and safe reruns.

Experience must include T‑SQL, SSIS, and end‑to‑end ownership of integration workflows, including design, build, monitoring, incident handling, and safe reruns.

This role is central to ensuring that data moves reliably and safely between our internal and external systems. You will work closely with analysts, testers, operations teams and business stakeholders to deliver integrations that are robust, supportable, and maintainable.

To accompany your application, please submit a cover letter along with your CV, outlining your skills and examples of why you believe you’re a strong fit for this role. Applications without a cover letter will not be considered. Your cover letter should include at least two examples of integrations you have personally designed or supported in a production environment.

Responsibilities:

• Design, build and maintain SQL Server and SSIS‑based integrations across multiple systems
• Implement restartable, idempotent, and supportable integration patterns
• Design and maintain staging layers, including validation, cleansing, row‑count checks and audit trails
• Diagnose and resolve integration issues, including duplicates, missing records, late‑arriving data and schema changes
• Work with analysts and testers to clarify requirements, define rules and ensure integrations behave as expected
• Collaborate with operations teams to ensure integrations are monitored, logged and support‑ready
• Produce clear technical documentation, including design specs, support guides and data flow diagrams
• Apply best practices for performance, security, error handling and operational resilience
• Contribute to continuous improvement of integration patterns, tooling and processes

Role Criteria: (must be clearly evidenced in your CV and cover letter)

• Please ensure your CV and cover letter clearly describe your personal contribution to the integrations you reference.
• Recent, hands‑on experience delivering integrations using SQL Server, T‑SQL and SSIS
• Experience designing restartable and safe‑to‑rerun SSIS packages
• Experience with incremental loads, matching logic, staging patterns, and data quality controls
• Experience diagnosing and resolving operational integration issues
• Experience working with analysts, testers or operations teams in a delivery environment
• Ability to produce clear, structured technical documentation
• Strong problem‑solving skills with lived examples of applied experience
• Ability to manage workload, prioritise issues and work independently

Desirable Experience:

• C#.NET for custom components or API integrations
• Azure Logic Apps, Azure Functions or Azure Data Factory
• API integration patterns and API security
• Azure DevOps for version control and CI/CD
• Experience in housing, repairs, field services or similar operational domains

To accompany your application, please submit a cover letter along with your CV, outlining your skills and examples of why you believe you’re a strong fit for this role. Applications without a cover letter will not be considered. Your cover letter should include at least two examples of integrations you have personally designed or supported in a production environment.

Who this role would suit:

This role is ideal for candidates who have hands‑on, practical experience delivering SQL Server and SSIS‑based integrations in operational environments. It will particularly suit people who enjoy working with transactional data flows, solving real‑world integration issues, and building solutions that are robust, supportable and safe to rerun.

You will thrive in this role if you have experience with:

• SQL Server, T‑SQL and SSIS as core integration tools
• Designing restartable, idempotent and support‑ready integration patterns
• Working with staging layers, incremental loads, matching logic and data quality controls
• Supporting integrations in live environments, including diagnosing failures and preventing recurrence
• Collaborating with analysts, testers and operations teams to deliver reliable data flows
• Producing clear technical documentation and improving integration processes over time

We welcome applicants from all backgrounds, and we encourage you to apply if your experience aligns with the skills and responsibilities described above.

Benefits:

• 25 days annual leave plus bank holidays
• Remote working
• Team annual get together with guest speakers and an evening social
• Generous Pension Scheme
• Sick Pay
• Refer a friend scheme (total award £1000)
• Share saver scheme
• Eye test vouchers
• Employee Assistance Programme (Access to Free counselling service)
• Wellbeing service (Access to trained mental health & wellbeing advisors)
• Mears Annual Family Fun Day for you and your family to places like Drayton Manor fully paid for including lunch
• Mears Rewards - A performance recognition platform whereby you can be rewarded in high street vouchers
• Volunteering Leave - Mears supports employees to undertake volunteering in the community, in support of our social value commitment

All our roles require candidates to have the entitlement to work within the UK, Mears- does not currently offer visa sponsorship.

Candidates should be aware that all our roles are subject to relevant DBS/Security checks before commencement of employment.

Apply below or to discuss your application further; contact:

Joe Monger (joe.monger@mearsgroup.co.uk)

If you need any help with your application process, we are here to support you. We will be accessible every step of the way.

At Mears Group, we are committed to fostering a diverse and inclusive environment where everyone can thrive, we are a Disability Confident employer, valuing individuality and ensuring equal opportunities for all.

We proudly support the Armed Forces Covenant and are honoured to have achieved the Gold Award in the Defence Employer Recognition Scheme (ERS) to coincide with this, we hold an Endorser Award for the Career Transition Partnership, recognising our commitment to veterans transitioning into civilian careers.

In our continued effort to promote social mobility, we invite applicants to voluntarily share their background information during the application stages to help us better understand the diverse experiences of our candidates. This is to ensure we are committed to improving social mobility. We use the Social Mobility Index to assess and enhance opportunities for individuals from diverse backgrounds. These questions are optional and will not impact your ability to apply.