Integrations Engineer (Fixed Term) based in Derby

This is a rare opportunity to shape MHA’s integration capability at the outset of a broader programme of organisational transformation. Working collaboratively and with care, you will help deliver solutions that improve the wellbeing of our residents, colleagues, customers and communities. We are looking for an Integrations Engineer with significant experience of designing, delivering and supporting complex integration solutions to join our IT Team on a 24-month fixed-term contract. Working closely with the Data Architect and Operational Leads, you will support both day‑to‑day IT operations and strategic change initiatives. You will play a key role in the design, implementation and maintenance of robust integration solutions that align with and support our enterprise strategy.

Reporting & Relationships

Report directly to the Systems Solutions Manager and use strong technical credibility to build trusted relationships with internal stakeholders, delivery partners and suppliers. Act as a brand ambassador for MHA by consistently embodying our values: respect, dignity, nurturing mind and spirit, and inspiring excellence in others.

About you

The ideal candidate will bring extensive experience of contributing to complex digital transformation programmes, using their integration expertise to translate strategic objectives into reliable, scalable data solutions. You will be a highly experienced Integrations Engineer with a strong understanding of cloud platforms, databases, and the applications and tools used to maximise their potential. You will bring extensive knowledge of the full data‑modelling lifecycle, from conceptualisation through to database optimisation, together with significant hands‑on experience as a Data Engineer. You will hold a bachelor’s degree or demonstrate substantial equivalent experience in the relevant areas.

Key Day-to-Day Responsibilities

• Design, build, and maintain robust integrations and pipelines across cloud and on‑premises platforms (e.g., Azure Data Factory/Fabric and equivalent tools).
• Develop and optimise ETL/ELT processes (extraction, transformation, loading) to meet business, reporting, and analytics requirements.
• Implement data quality, validation, and monitoring controls to ensure accurate, reliable, and timely data flows.
• Troubleshoot, resolve, and prevent integration incidents; continuously improve performance, scalability, and resiliency.
• Collaborate with stakeholders, vendors, and technical teams to gather requirements, design interfaces, and deliver end‑to‑end integrations.
• Embed data security, privacy, and governance standards into integration designs, including access controls and auditability.
• Produce and maintain clear technical documentation (data flows, mappings, runbooks) and contribute to best practices and automation.

Key experience:

• Extensive experience of delivering complex, end-to-end integrations using enterprise integration platforms, ideally Azure Data Factory or Microsoft Fabric, including the design, build, deployment and support of business‑critical production data pipelines.
• Significant hands‑on experience using Azure Data Factory, SQL, Python, Oracle and stored procedures to design, build, maintain, optimise and troubleshoot reliable integrations and database‑driven processes in production environments.
• Extensive hands‑on experience of designing and delivering ETL and ELT solutions, including data extraction, transformation and loading patterns, with the ability to justify design decisions relating to performance, maintainability and reprocessing.
• A strong track record of designing and delivering workflow automation using tools such as Power Automate and/or Make, with clear evidence of streamlining operational processes, improving control and reducing manual effort.
• Extensive experience of operating within complex cloud and hybrid environments, including integrating and moving data between on‑premises and cloud services while managing connectivity, security and operational constraints.
• Significant experience of owning the support, troubleshooting and optimisation of live data pipelines, including proactive monitoring, root‑cause analysis, incident resolution, performance tuning and the prevention of recurring issues.
• Strong experience of leading technical engagement with stakeholders and third parties: eliciting and challenging requirements, managing complex dependencies, communicating change clearly, and producing high‑quality documentation and handovers that support operational resilience and knowledge sharing.

Personal skills

• Strong communication and stakeholder‑management skills: able to explain complex integration concepts clearly to technical and non‑technical audiences, challenge and refine requirements, influence decisions, and keep stakeholders informed throughout delivery and change.
• Solution focused problem‑solving mindset: logical, analytical approach to diagnosing issues and designing pragmatic, reliable solutions.
• Strong prioritisation & issue management: able to triage incidents/requests, balance conflicting demands, and focus on what’s business critical.
• Collaboration and relationship building: works well with internal teams and third‑party vendors; builds effective working relationships at all levels.
• Resilience under pressure: stays effective in a changing environment, handles incidents calmly, and adapts to shifting priorities.

Experience with

• Azure Data Factory, SQL, Python, Oracle/Python/SQL Databases and with stored procedures, Fabric, Power Automate, Make Production‑grade operational thinking.

Location

This is a hybrid role based primarily in Derby, combining on‑site collaboration with the flexibility to work from home. An on‑site presence supports effective team working, with an expectation of approximately two days per week in the office.

Perks of joining the MHA family:

• Values driven culture - we're super proud of our culture.
• Access to Blue Light Card - The UK's no.1 discount service for emergency services, NHS, social care sector & armed forces!
• 33 Days Holiday - including bank holidays (pro‑rota FTE is 37 hrs per week)
• Care and Support for You - Our in‑house Chaplaincy service is widely recognised within MHA and beyond and is available to all staff members who may benefit from pastoral care and support.
• Buy and Sell Annual Leave – buy or sell up to a week’s holiday per annum (depending on your annual entitlement)
• MHA Cares for You – Our bespoke scheme offering a wide range of deals and discounts in leading retailers and online stores.
• Highly supportive leadership team.

About MHA:

As the largest charity care provider for older people in the UK, we offer some of the highest quality care, accommodation, and support services throughout Britain. Our mission is to inspire the best care and wellbeing at every stage of later life.