Business System Analyst - Bench

Job Description

Key Responsibilities:

• Support the end-to-end process of TPA claim transfers, ensuring clean and accurate data integration into Arch’s systems.
• Review and validate claim mappings, including Claim Numbers, Claimant Numbers, and other key identifiers, between old and new TPA systems.
• Confirm consistency of critical operational fields such as Policy Number, Accident Date, Reported Date, and Loss Details, ensuring no unauthorized changes or inconsistencies exist in transferred data.
• Conduct financial reconciliation by comparing financial amounts and balances between old and new TPAs, ensuring alignment with Arch’s reporting and operational requirements.
• Define and document business rules and data mappings for reporting and reconciliation processes.
• Perform detailed data analysis using Excel and basic SQL queries to validate and troubleshoot data discrepancies.
• Create and maintain clear user stories, process documentation, and business requirements.
• Collaborate with TPAs, business users, and technical teams to track issues, manage dependencies, and maintain project timelines.
• Provide UAT planning, execution, and documentation support, and documenting reconciliation results.
• Effectively communicate issues, risks, and status updates to stakeholders and leadership.

Qualifications

Required Skills & Experience:

• Mid-Level to Senior Business Systems Analyst experience, preferably in insurance, claims processing, or financial reconciliation projects.
• Strong Excel skills (pivot tables, lookups, formulas, data analysis).
• Experience in defining business rules, data elements, and reporting requirements.
• Basic SQL skills for data validation, querying, and troubleshooting.
• Proven ability to manage project timelines, priorities, and stakeholder expectations.
• Strong experience in stakeholder management and cross-functional collaboration.
• Ability to review, validate, and reconcile data mappings and operational fields across systems.
• Hands-on experience in UAT planning, execution, and documentation for system integrations or data migrations.
• Excellent written and verbal communication skills.

Additional Information

• Preferred Qualifications:

• Experience working with Third-Party Administrators (TPAs) or insurance data systems.
• Familiarity with Jira, Agile methodology, or other project management tools.
• Background in claims data management, financial reconciliation, or data migration projects.