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
Who this role would suit:
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 holidaysRemote workingTeam annual get together with guest speakers and an evening socialGenerous Pension SchemeSick PayRefer a friend scheme (total award £1000)Share saver schemeEye test vouchersEmployee Assistance PRemote work options
Additional Information
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.
Mearsgroup · Exeter