Website:
rvsiglobal.co.uk
Job details:
We are looking for a skilled and proactive Data and Integration Engineer (AI and Automation) to support the customer's internal service platform and wider MSP operating model. The candidate will be responsible for building and maintaining API integrations, automating recurring processes, improving data quality, contributing to the central data warehouse, and delivering reliable, documented and supportable solutions. The role requires strong technical expertise across API integration engineering, data, automation, reporting
Requirements
- Build and maintain API integrations between customer business systems, including Halo PSA to Float two-way sync, HiBob to Float, and ApprovalMax into the central data layer.
- Build integrations that report their own failures, including error handling, alerting and reconciliation checks.
- Automate recurring manual processes across finance and operations, including scheduled extracts, reconciliation support and supplier billing, to an auditable and reproducible standard.
- Remediate data quality at source, starting with Halo PSA, Xero and HubSpot, including entity matching between Halo customers, Xero contacts and HubSpot records, and put controls in place so that issues do not recur.
- Contribute to the design and build of the central data warehouse, including staging layer design, entity matching, incremental loading and history handling.
- Work with colleagues across finance and operations to produce reports and dashboards that sit on top of the data layer.
- Build AI-assisted workflows where they measurably improve throughput, and use AI development tooling to accelerate build work.
- Gather requirements directly from non-technical colleagues across finance, sales and operations, and convert them into written specifications.
- Work within the established delivery process covering high level plan, scope of work, pre-sales authorisation, peer review and documentation before go-live.
- Substantial hands-on experience designing, building and supporting API integrations between business systems in production.
- Working knowledge of REST, OAuth2 and webhooks.
- Experience with two-way synchronisation, including write conflicts, retries, idempotency and reconciliation.
- Experience integrating through Microsoft Graph, Entra APIs or comparable vendor APIs, with the ability to assess and adopt new interfaces as the MSP toolset changes.
- Experience handling production constraints, including permission limits, rate limits, schema access refused by a vendor, and endpoints that behave differently from their documentation.
- SQL proficiency, including queries, joins, views and stored procedures.
- Power Query experience, including ETL, data transformation and M language.
- Experience automating recurring processes end to end, including scheduling, monitoring and failure handling.
- Practical use of AI coding tools such as Claude Code inside a reviewed workflow, with a clear account of how output is verified before it is relied upon.
- Experience building and delivering reports and dashboards for business users, in Power BI or a comparable tool.
- Ability to take a reporting requirement from a non-technical colleague through to a working, documented output.
- Understanding of how the data model underneath a report determines what the report can and cannot do.
- Ability to tie output back to source and present the reconciliation as part of delivery.
- Ability to distinguish between figures that drive an invoice and figures on a dashboard, and test them accordingly.
- Ability to surface limitations of your own build before anyone else finds them.
- Experience with Azure AI Foundry, including orchestrating AI services over a data platform and understanding how models and APIs are selected and governed.
- Experience with Microsoft Fabric Lakehouse and pipelines, including a working understanding of capacity and licensing cost.
- Involvement in delivering a data warehouse or lakehouse, including staging layer design, dimensional modelling, incremental loading and slowly changing dimensions.
- Working knowledge of data governance, including sensitivity labelling, Purview, access control and data classification.
- Experience integrating Xero, QuickBooks, Sage or NetSuite with reporting tools or downstream systems.
- Experience with PSA and MSP tooling such as Halo PSA, ConnectWise, Autotask or Datto, or comparable time tracking and project management systems.
- IT Glue, Liongard and Scalepad exposure.
- Advanced Power BI skills, including advanced DAX, semantic model and star schema design, and Power BI Service administration covering workspaces, gateways, scheduled refreshes and row level security.
- MSP, professional services or another project based business background where billable utilisation and project margin matter.
- Experience with Power Automate, Zapier or similar low-code automation.
Benefits
- Annual Bonus
- Provident Fund
- Performance bonuses
- Employee's State Insurance Corporation
- Medical Insurance
- Night Allowances
- Pick and Drop facilities (Only for Female Staff)
- Day outs for Staff
- Team Lunches
- Maternity/ Paternity leaves
- Retirement Benefits
- Paid Time Off
- Flexible work schedules
Click on Apply to know more.