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

• Flexible, project-based consulting opportunities with the ability to work across diverse public, private, and nonprofit sector IT initiatives.
  
• Exposure to high-impact digital transformation, infrastructure modernization, cybersecurity, cloud, and AI-enabled projects that strengthen your portfolio and technical expertise.
  
• Collaborative partnership model that values consultant input, innovation, and professional autonomy while working alongside experienced client and project leadership teams.
  
• Competitive contractor compensation with opportunities for repeat engagements, long-term client relationships, and expansion into strategic advisory or technical leadership roles.
  
•