Data Reconciliation Analyst (Remote)
Core
Reconcile data between internal systems, databases, and regulatory reports to ensure accuracy and completeness for the Regulatory team.
Role type
Data Reconciliation Analyst
Builds
Operational, reconciliation, management, and exception reports for regulatory compliance
Domain
Mortgage servicing and financial services
Deliverable
dashboards & analysis
Required skills
Data reconciliation, SQL reporting, Microsoft Excel (PivotTables, XLOOKUP, Power Query), regulatory reporting interpretation, root cause analysis, data quality assurance, process improvement, prompt engineering, generative AI tools
Preferred skills
Power BI, SharePoint, Power Automate
Responsibilities
Perform reconciliations between multiple internal systems and regulatory reports; Validate data for Mortgage Call Reports and NMLS reporting; Develop and maintain reconciliation procedures and documentation; Analyze data discrepancies and coordinate corrective actions; Support regulatory examinations and audits; Utilize reporting tools to analyze large datasets and identify trends.
Seniority
Mid-level, hands-on IC