Data and Integration Engineer (AI and Automation)

RVS iGlobal - White Label Service Provider; Jammu district; On-site; INR 1,800,000 - 3,000,000; Full time

Benefits offered by this job

Annual Bonus

Provident Fund

Performance bonuses

Medical Insurance

Night Allowances

Pick and Drop facilities (Only for in

Day outs for Staff

Team Lunches

Maternity/ Paternity leaves

Retirement Benefits

Paid Time Off

Flexible work schedules

Job summary

RVS iGlobal - White Label Service Provider is seeking a Data and Integration Engineer (AI and Automation) to support the customer's internal service platform and MSP operating model. You will build and maintain API integrations, automate recurring processes, improve data quality, and contribute to the central data warehouse with well-documented, scalable solutions.

You will work across Halo PSA, Xero, HubSpot, and other systems, delivering reliable integrations, predictive monitoring, and

Qualifications

• Extensive experience designing and supporting API integrations in production.
• Strong data quality improvement and reconciliation experience.
• Proficient in SQL, Power BI, and ETL tooling.
• Hands-on with AI-assisted data workflows and low-code automation.
• Experience with Halo PSA, Xero, HubSpot and MSP tooling is a plus.
• Ability to translate non-technical requirements into specs.

Responsibilities

• Build and maintain API integrations between business systems (two-way where applicable).
• Automate recurring processes across finance and operations with auditable standards.
• Improve data quality at source and implement reconciliation checks.
• Contribute to central data warehouse design, staging, and history handling.
• Create reports and dashboards sitting on top of the data layer.
• Develop AI-assisted workflows and verify outputs before use.
• Gather requirements from non-technical colleagues and write specs.
• Ensure delivery follows established processes and governance.

Skills

API integrations

Data quality

Automation

SQL

Power BI

ETL

Azure AI Foundry

Microsoft Fabric Lakehouse

Data warehousing

Webhooks

REST/OAuth2

Two-way sync

Azure/Cloud APIs

Power Query/M language

Automation tooling

DAX/semantic modeling

Reporting for business users

Tools

Halo PSA

Float

HiBob

ApprovalMax

Xero

HubSpot

Power BI

Azure AI Foundry

Microsoft Fabric Lakehouse

Job description

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