Data Architect

Job Summary (Data Architect Sarasota, FL)

• Lead End-to-End Data Migration: Oversee the migration of participant, plan, transactional, compliance, and historical data from FIS Relias to FIS FRP, ensuring data integrity and regulatory compliance.
• Data Architecture Design: Design, govern, and maintain data architecture, including data mapping, canonical data structures, and conversion strategies.
• Data Governance & Quality: Establish data governance controls, define data quality standards, and ensure compliance with ERISA, SEC, IRS, SOC1/SOC2, and audit requirements.
• Data Modeling & Mapping: Develop logical and physical data models, define source-to-target mappings, and resolve transformation requirements for all data categories (participant, employer, payroll, loan, investment).
• Migration Strategy: Define and implement enterprise migration data strategy, including phased migration plans, historical retention, and authoritative data sources.
• Reconciliation & Validation: Design reconciliation frameworks and exception management processes for participant balances, payroll, loans, investments, and historical transactions.
• Integration Architecture: Collaborate with payroll, custodians, CRM, data warehouse, and reporting teams to define migration interface dependencies and downstream integration alignment.
• Risk & Issue Management: Identify and resolve migration data risks, inconsistencies, duplicates, or incomplete records; support mock conversions and cutover rehearsals.
• Deliver Key Documentation: Produce migration strategies, data models, mapping documents, retention plans, reconciliation frameworks, data lineage documentation, and readiness reports.
• Industry & Technical Expertise: Apply knowledge of 401(k) recordkeeping, financial reconciliation, retirement plan compliance, data architecture, ETL tools, SQL, and integration architectures.
• Preferred Experience: Experience with FIS Relias, FIS FRP, retirement industry migrations, and cloud data platforms such as Microsoft Fabric, Snowflake, or Azure.