The Role
Build and support production API integrations, automation workflows, data quality controls, and central warehouse or lakehouse solutions. Develop reports and dashboards in Power BI, implement reconciliation and failure monitoring, and gather requirements from finance, sales, and operations. The role also involves AI-assisted workflows, Azure AI Foundry, Microsoft Fabric, data governance, dimensional modelling, incremental loading, and Power BI Service administration.
Summary Generated by Built In
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
Skills Required
- Substantial hands-on experience designing, building, and supporting production API integrations between business systems
- Working knowledge of REST, OAuth2, and webhooks
- Experience with two-way synchronization, write conflicts, retries, idempotency, and reconciliation
- Experience integrating Microsoft Graph, Entra APIs, or comparable vendor APIs
- Experience handling production constraints such as permission limits, rate limits, restricted schemas, and inconsistent vendor endpoints
- SQL proficiency including queries, joins, views, and stored procedures
- Power Query experience including ETL, data transformation, and M language
- Experience automating recurring processes with scheduling, monitoring, and failure handling
- Practical use of AI coding tools such as Claude Code in a reviewed and verified workflow
- Experience building and delivering business reports and dashboards in Power BI or a comparable tool
- Ability to convert reporting requirements into working, documented outputs
- Understanding of data models and their impact on report capabilities
- Ability to reconcile reporting outputs to source data
- Ability to distinguish invoice-driving figures from dashboard figures and test them appropriately
- Ability to identify limitations and risks in delivered solutions
- Experience with Azure AI Foundry and orchestrating AI services over a data platform
- Experience with Microsoft Fabric Lakehouse and pipelines, including capacity and licensing costs
- Experience delivering a data warehouse or lakehouse with staging, dimensional modelling, incremental loading, and slowly changing dimensions
- Working knowledge of data governance, sensitivity labelling, Purview, access control, and data classification
- Experience integrating Xero, QuickBooks, Sage, or NetSuite with reporting tools or downstream systems
- Experience with PSA or MSP tooling such as Halo PSA, ConnectWise, Autotask, or Datto
- Exposure to IT Glue, Liongard, and Scalepad
- Advanced Power BI skills including DAX, semantic models, star schemas, workspaces, gateways, scheduled refreshes, and row-level security
- MSP, professional services, or project-based business experience involving billable utilization and project margin
- Experience with Power Automate, Zapier, or similar low-code automation tools
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
RVS iGlobal is a London-headquartered white-label IT services provider with a network operations centre in India. It helps managed service providers, IT service providers, cloud providers, SaaS vendors, and other organisations extend their capabilities through 24/7/365 technical helpdesk, NOC and SOC operations, RMM, backup and server monitoring, Microsoft 365/Azure cloud support, migrations, automation, and remote office-professional services and project delivery.
