Data Reconciliation Analyst (Remote)

Overview

This role supports the Regulatory team by reconciling, validating, maintaining, and continuously improving data used for regulatory reporting. Responsibilities include coordinating with business and data teams to ensure the accuracy, completeness, and integrity of reporting.

Responsibilities

• Perform reconciliations between multiple internal systems, databases, regulatory reports, and/or source documents to ensure regulatory reporting is accurate and complete.
• 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 with business units to define data requirements, fulfill requests, and validate report results.
• Conduct data quality assurance reviews, reconciliation testing, and validation procedures to ensure reports are complete, accurate, and submitted by 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 with reconciliation support and documentation.
• Use Microsoft Excel, Power BI, and other reporting tools to analyze large datasets, identify trends, and create 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.

Requirements

• 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, including expert-level knowledge of Microsoft Excel (PivotTables, XLOOKUP, Power Query, and advanced formulas).
• Experience developing reconciliation reports and analyzing large data sets.
• Proficiency in prompt engineering and using 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 the ability to communicate effectively with internal and external customers, peers, auditors, regulators, and management.

Preferred Qualifications

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

Compensation & Benefits

• Pay Range: $17.69 - $23.56 Hourly, Remote
• Benefits (based on eligibility): medical, dental, vision, 401k, PTO/paid sick leave, and an employee stock purchase plan.

Location

Remote.

Note: The following statements apply only to candidates who will be working from an unincorporated area within Los Angeles County. Employment consideration includes qualified applicants with arrest or conviction records in a manner consistent with applicable state and local laws (e.g., the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act). A review of an applicant’s criminal history may occur in connection with a conditional offer. The employer reasonably believes criminal history may have a direct, adverse, and negative relationship to material job duties for this position, potentially resulting in withdrawal of the conditional offer, including handling confidential, proprietary, or trade secret information belonging to the employer or its customers; administrating or facilitating financial transactions; and meeting customer-imposed criminal history requirements.