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.