Data Reconciliation Analyst

First American

. Perform reconciliations between internal systems, databases, regulatory reports and source documents .

Posted 10/26/2026full-timeRemote • United StatesMid-LevelSenior💰 $16 - $24 per hourWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data reconciliation and regulatory reporting within the banking or financial services sector, utilizing advanced Microsoft Excel and reporting tools to analyze large datasets and ensure compliance. Strong analytical and problem-solving skills are essential for identifying discrepancies and implementing process improvements.

Highest-signal resume keywords

Data ReconciliationRegulatory ReportingAdvanced Microsoft ExcelPower BIData Analysis

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ReconciliationRegulatory ReportingData AnalysisFinancial ReportingPrompt EngineeringGenerative AI ToolsAdvanced Microsoft ExcelPivotTablesXLOOKUPPower Query

Soft Skills

Analytical SkillsOrganizational SkillsProblem-Solving SkillsAttention to DetailCommunication Skills

Tools & Technologies

Microsoft Office SuitePower BISharePointPower AutomateReporting Tools

Industry Keywords

BankingMortgage ServicingFinancial ServicesRegulatory ComplianceData Quality Assurance

About the role

Key responsibilities & impact

Perform reconciliations between internal systems, databases, regulatory reports and source documents
Validate data supporting Mortgage Call Reports, NMLS reporting, state licensing reports, investor reporting and other reporting requirements
Develop operational, reconciliation, management and exception reports
Analyze data discrepancies, identify root causes and coordinate corrective actions
Interpret regulatory reporting requirements and translate them into reconciliation and validation processes
Coordinate with business units to define data requirements and validate report results
Perform data quality assurance reviews, reconciliation testing and validation procedures
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
Use Microsoft Excel, Power BI and other reporting tools to analyze large datasets, identify trends and develop management reporting
Maintain documentation supporting reconciliation activities, issue resolution and regulatory reporting controls
Coordinate responses to clients and third parties regarding reporting questions

Requirements

What you’ll need

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
Expert-level knowledge of Microsoft Excel, including PivotTables, XLOOKUP, Power Query and advanced formulas
Experience reconciling reports and analyzing large data sets
Proficiency in prompt engineering and generative AI tools such as ChatGPT or Claude
Ability to research, analyze, and resolve complex data discrepancies
Strong analytical, organizational, and problem-solving skills with exceptional attention to detail
Excellent verbal and written communication skills
Experience with Power BI, SharePoint, Power Automate, or other reporting and automation tools is preferred

Benefits

Comp & perks

Medical insurance
Dental insurance
Vision insurance
401(k)
PTO/paid sick leave
Employee stock purchase plan
Inclusive, people-first workplace culture