About this role
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. 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. 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.