Regulatory Data Reconciliation Specialist

First American; United States; Remote; USD 22,000 - 33,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401(k) plan

Paid time off

Employee stock purchase plan

Job summary

First American is seeking a Data Reconciliation Analyst to support its Regulatory team, focusing on day-to-day data reconciliation, validation, maintenance, and continuous improvement of data supporting regulatory reporting.

The role emphasizes coordinating with multiple business and data teams, ensuring accuracy and integrity of reporting, and utilizing Excel, Power BI, and other tools to analyze large datasets and generate management reports.

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.
• Advanced proficiency with Microsoft Office Suite, including expert-level knowledge of Microsoft Excel (PivotTables, XLOOKUP, Power Query and advanced formulas).
• Experience with Power BI, SharePoint, Power Automate, or other reporting and automation tools is preferred.

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 to 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.
• Coordinate responses to clients and/or third parties regarding reporting questions.

Skills

Data reconciliation

Regulatory reporting

Data analysis

Prompt engineering

Power BI

Advanced Excel

Tools

Excel

Power BI

Job description

First American is seeking a Data Reconciliation Analyst to support its Regulatory team, focusing on day-to-day data reconciliation, validation, maintenance, and continuous improvement of data supporting regulatory reporting.

The role emphasizes coordinating with multiple business and data teams, ensuring accuracy and integrity of reporting, and utilizing Excel, Power BI, and other tools to analyze large datasets and generate management reports.