Data Reconciliation Analyst: Regulatory Reporting & AI Tools

First American

Columbus (OH)

Remote

USD 70,000 - 110,000

Full time

9 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical benefits

401k plan

PTO / paid sick leave

Employee stock purchase plan

Job summary

First American is seeking a Data Reconciliation Analyst to support ServiceMac's regulatory reporting processes. The role emphasizes data validation, reconciliation across multiple systems, and collaboration with business and data teams to ensure reporting accuracy.

Ideal candidates have 3–5 years of experience in data reconciliation or related finance or mortgage servicing analytics, with strong Excel and SQL skills and familiarity with Power BI. A comprehensive benefits package is offered.

Qualifications

3–5 years of experience in data reconciliation, regulatory reporting, financial reporting, or data analysis in banking, mortgage servicing, or financial services.
Advanced proficiency with Microsoft Office Suite, including expert-level Excel (PivotTables, XLOOKUP, Power Query).
Experience with Power BI, SharePoint, Power Automate or similar tools is preferred.

Responsibilities

Perform reconciliations between multiple internal systems, databases, regulatory reports, and source documents to ensure accuracy of regulatory reporting.
Validate data supporting MCR, NMLS, state licensing, investor reporting, and other reporting needs.
Develop and maintain reconciliation procedures, reports, data dictionaries and supporting documentation.
Utilize Excel, Power BI and other reporting tools to analyze large datasets and develop management reporting.