Data Reconciliation Analyst AI-Driven Regulatory Reporting

First American; Tallahassee (FL); À distance; USD 22 000 - 33 000; Plein temps

Avantages offerts par ce poste

Medical benefits

Dental benefits

Vision benefits

401k

Résumé du poste

ServiceMac in Tallahassee, FL is seeking a Data Reconciliation Analyst to manage day-to-day reconciliation, validation, maintenance, and continuous improvement of data supporting the Regulatory team. You will coordinate with multiple teams to ensure accuracy and integrity of reporting through detailed data reconciliations and QA reviews.

The role requires 3–5 years of data reconciliation and regulatory reporting experience within financial services or mortgage servicing, plus strong Excel and

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.
• Advance proficiency with Microsoft Office Suite, including expert-level knowledge of Microsoft Excel (PivotTables, XLOOKUP, Power Query and advanced formulas).
• Experience reconciliation reports and analyzing large data sets.
• Proficiency in prompt engineering and utilizing generative AI tools like ChatGPT or Claude to streamline reporting and/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 with internal/external customers, peers, auditors, regulators, and management.
• Experience with Power BI, SharePoint, Power Automate, or other reporting and automation tools is preferred.

Responsabilités

• 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.
• Maintain detailed documentation supporting reconciliation activities, issue resolution, and regulatory reporting controls.
• Coordinate responses to clients and/or third parties regarding reporting questions.

Connaissances

Data reconciliation

Regulatory reporting

Data analysis

Excel

Power BI

AI tools

Communication

Power Automate

Outils

Power BI

SharePoint

Power Automate

Description du poste

ServiceMac in Tallahassee, FL is seeking a Data Reconciliation Analyst to manage day-to-day reconciliation, validation, maintenance, and continuous improvement of data supporting the Regulatory team. You will coordinate with multiple teams to ensure accuracy and integrity of reporting through detailed data reconciliations and QA reviews.

The role requires 3–5 years of data reconciliation and regulatory reporting experience within financial services or mortgage servicing, plus strong Excel and