Data Reconciliation Analyst (Remote)

First American•Usa, SC

8d•Remote

About The Position

ServiceMac, a sub-servicing entity serving the mortgage and real estate industries, is hiring a Data Reconciliation Analyst to support its Regulatory team. The role is responsible for day-to-day reconciliation, validation, maintenance, and continuous improvement of data used in regulatory reporting. It coordinates with business and data teams to support accurate, complete, and reliable reporting through data reconciliations, quality assurance reviews, root-cause analysis, and collaboration. The analyst validates data for Mortgage Call Reports (MCR), NMLS reporting, state licensing reports, investor reporting, and other reporting needs. The position also develops reports, investigates discrepancies, supports regulatory changes and examinations, maintains documentation and controls, and coordinates responses to clients or third parties. The role uses Excel, Power BI, and other reporting tools to analyze large datasets and support management reporting. The job is listed as remote and pays $16.07–$24.04 per hour.

Requirements

Three to five years of recent 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 Microsoft Excel skills such as PivotTables, XLOOKUP, Power Query, and advanced formulas.
Experience with reconciliation reports and analysis of large datasets.
Proficiency in prompt engineering and use of generative AI tools such as ChatGPT or Claude to streamline reporting or reconciliations.
Demonstrated 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 and ability to communicate effectively with internal and external customers, peers, auditors, regulators, and management.

Nice To Haves

Experience with Power BI, SharePoint, Power Automate, or other reporting and automation tools.

Responsibilities

Reconcile data across internal systems, databases, regulatory reports, and source documents to support accurate and complete regulatory reporting.
Validate data for Mortgage Call Reports (MCR), NMLS reporting, state licensing reports, investor reporting, and other reporting requirements.
Develop operational, reconciliation, management, and exception reports.
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 with business units to define data requirements, fulfill requests, and validate report results.
Perform data-quality reviews, reconciliation testing, and validation procedures to ensure reports are complete, accurate, and submitted on time.
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 with testing regulatory reporting changes and new reporting requirements.
Support regulatory examinations, internal audits, client due diligence requests, and management inquiries with reconciliation support and documentation.
Use Microsoft Excel, Power BI, and other reporting tools to analyze large datasets, identify trends, and develop management reporting.
Maintain detailed documentation of reconciliation activities, issue resolution, and regulatory reporting controls.
Coordinate responses to clients and third parties regarding reporting questions.