Regulatory Data Reconciliation Analyst

First American; Athens (GA); Remote; USD 65,000 - 90,000; Full time

Benefits offered by this job

Medical, dental, vision benefits

401(k) plan with company match

PTO and paid sick leave

Employee stock purchase plan

Job summary

First American is seeking a Data Reconciliation Analyst to support the Regulatory team with day‑to‑day reconciliation, data validation, and reporting improvement in a mortgage servicing context.

The role focuses on coordinating with multiple data teams, building reconciliation and management reports, and ensuring regulatory data accuracy for MCR, NMLS and other filings, with strong emphasis on Excel, Power BI, and AI-assisted tooling.

Qualifications

• Three to five years of recent experience performing data reconciliation, regulatory reporting, financial reporting, or data analysis in a banking, mortgage servicing, or financial services environment.

Responsibilities

• Perform reconciliations between multiple internal systems, databases, regulatory reports and/or source documents to ensure the accuracy and completeness of regulatory reporting.
• Validate data supporting Mortgage Call Reports (MCR), NMLS reporting, state licensing reports, investor reporting and other reporting needs/requirements.
• Develop operational, reconciliation, management, and exception reports.
• Analyze and investigate data discrepancies, identify root causes, and coordinate corrective actions with business partners.
• Interpret regulatory reporting requirements and translate them into reconciliation and validation processes.
• Work closely with the business units they define the data requirements to fulfill requests and validate report results.
• Perform data quality assurance reviews, reconciliation testing, and validation procedures to ensure regulatory reports are complete, accurate, and submitted within required deadlines.
• Monitor recurring reconciliation exceptions and recommend process improvements, automation opportunities and enhanced data controls.
• Develop and maintain reconciliation procedures, desktop procedures, data dictionaries and supporting documentation.
• Assist in testing regulatory reporting changes and new reporting requirements.
• Support regulatory examinations, internal audits, client due diligence requests and management inquiries by providing reconciliation support and documentation.
• Utilize Microsoft Excel, Power BI, and other reporting tools to analyze large datasets, identify trends and develop management reporting.

Skills

Data reconciliation

SQL reporting

AI tools

Power BI

Excel

Regulatory reporting

Tools

Power BI

SharePoint

Power Automate

Job description

First American is seeking a Data Reconciliation Analyst to support the Regulatory team with day‑to‑day reconciliation, data validation, and reporting improvement in a mortgage servicing context.

The role focuses on coordinating with multiple data teams, building reconciliation and management reports, and ensuring regulatory data accuracy for MCR, NMLS and other filings, with strong emphasis on Excel, Power BI, and AI-assisted tooling.