Regulatory Data Reconciliation Analyst

First American; Lorida (FL); À distance; USD 65 000 - 90 000; Plein temps

Résumé du poste

First American seeks a Data Reconciliation Analyst to manage day-to-day reconciliation, validation, and data integrity for regulatory reporting in a mortgage servicing environment. You will coordinate with data teams, perform QA, and implement process improvements.

You will leverage SQL, Power BI, and AI tools to automate reporting, investigate discrepancies, and support examinations and audits. Strong communication is essential.

Qualifications

• Three to five years of recent experience performing 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 and advanced formulas).
• Experience with Power BI, SharePoint, Power Automate, or other reporting and automation tools is preferred.
• Prompt engineering and using AI tools like ChatGPT or Claude to streamline reporting/reconciliations.
• Excellent verbal and written communication skills with internal/external customers, auditors, regulators, and management.

Responsabilités

• Perform reconciliations between internal systems, databases, regulatory reports, and source documents to ensure accuracy of regulatory reporting.
• Validate data supporting MCR, NMLS reporting, state licensing reports, investor reporting, and other requirements.
• Develop operational, reconciliation, management, and exception reports.
• Analyze data discrepancies, identify root causes, and coordinate corrective actions with business partners.
• Interpret regulatory reporting requirements and translate them into reconciliation processes.
• Collaborate with business units to define data requirements and validate report results.
• Perform data quality assurance reviews, reconciliation testing, and validation procedures to ensure timely regulatory submissions.
• Monitor recurring reconciliation exceptions and recommend process improvements and automation opportunities.
• Maintain reconciliation procedures, data dictionaries, and supporting documentation.
• Assist in testing regulatory reporting changes and new requirements.

Connaissances

Data reconciliation

SQL reporting

Power BI

AI tools

Excel advanced

Data analysis

Regulatory reporting

Communication

Formation

3-5 years data reconciliation/regulatory reporting experience

Outils

SharePoint

Power Automate

Description du poste

First American seeks a Data Reconciliation Analyst to manage day-to-day reconciliation, validation, and data integrity for regulatory reporting in a mortgage servicing environment. You will coordinate with data teams, perform QA, and implement process improvements.

You will leverage SQL, Power BI, and AI tools to automate reporting, investigate discrepancies, and support examinations and audits. Strong communication is essential.