RPA & Insurance Portal Automation Engineer

ATS+Partners is seeking an RPA &
Insurance Portal Automation Engineer to own the robotic process automation
layer of the City of Brockton’s AI automation initiative, with a specific focus
on the insurance carrier portal interactions and reconciliation workflows that
represent the most operationally complex component of the engagement. This
contractor addresses a critical gap against Comparative Criterion B of the RFP,
which requires demonstrated experience automating Vehicle Insurance
Reconciliation and, advantageously, Health Insurance Reconciliation.

Many of the City’s insurance carrier portals,
state licensing databases, and vendor registration systems expose no
programmatic API, requiring a capable RPA practitioner who understands how to
build reliable, supervised automations that interact with live web interfaces.
The contractor will design, build, test, and deploy UiPath and/or Power
Automate workflows that retrieve insurance certificates directly from carrier
portals, validate coverage data against the City’s fleet registry, and support
health insurance enrollment reconciliation against carrier billing records —
all within a compliance-controlled Azure Government Cloud environment.

•     Design and develop UiPath or Power Automate RPA
workflows for Vehicle Insurance Certificate Reconciliation, including
authenticated session management with carrier portals and direct certificate
retrieval.

•     Build and maintain the insurance coverage matrix:
per-vehicle coverage tracking, expiration date monitoring, and automated
90/60/30-day renewal alert generation.

•     Implement intelligent RPA (iRPA) using semantic element
targeting so automations are resilient to carrier portal UI changes — targeting
elements by role and label, not screen coordinates.

•     Establish and manage a supervised execution framework
for the initial 50+ executions of each portal automation, documenting pass/fail
behavior before transitioning to unattended operation.

•     Build portal change detection monitors that alert the
team when a carrier portal’s structure changes materially, preventing silent
automation failures in production.

•     Implement ACORD certificate parsing logic for the
insurance reconciliation pipeline, handling layout variability across dozens of
carrier formats with pre- and post-OCR validation.

•     Configure carrier authentication workflows that verify
certificate legitimacy through direct portal query, not reliance on
self-submitted certificates alone.

•     Support Health Insurance Reconciliation automation:
build enrollment comparison logic identifying members billed but not enrolled,
enrolled but not billed, tier mismatches, and dependent eligibility
discrepancies.

•     Store all portal credentials in Azure Key Vault; ensure
no credentials appear in automation scripts, configuration files, or logs.

•     Log all portal sessions with full replay capability for
audit compliance; ensure RPA activity logs integrate with the Azure Log
Analytics immutable audit trail.

•     Provide RPA workflow documentation, operator SOPs, and
troubleshooting guides for City IT staff responsible for monitoring automations
in Phase 5.

Requirements

Benefits