Data Reconciliation Analyst (Remote)

Role overview

Responsibilities

• Reconcile data across internal systems, databases, regulatory reports, and source documents.
• Validate data for Mortgage Call Reports, NMLS, state licensing, investor, and other reporting.
• Develop operational, reconciliation, management, and exception reports.
• Investigate discrepancies, identify root causes, and coordinate corrective action with business partners.
• Translate regulatory reporting requirements into reconciliation and validation processes.
• Define data requirements with business units and validate report results.
• Perform data quality reviews, reconciliation testing, and validation to ensure accurate and timely reports.
• Monitor exceptions and recommend process improvements, automation, and enhanced controls.
• Maintain procedures, data dictionaries, and supporting documentation.
• Test reporting changes and support examinations, audits, due diligence requests, and management inquiries.
• Use Excel, Power BI, and other tools to analyze datasets, identify trends, and develop management reporting.
• Coordinate responses to client or third-party reporting questions.

Qualifications

• Three to five years of recent data reconciliation, regulatory reporting, financial reporting, or data analysis experience in banking, mortgage servicing, or financial services.
• Advanced Microsoft Office proficiency, including expert Excel skills in PivotTables, XLOOKUP, Power Query, and advanced formulas.
• Experience reconciling reports and analyzing large datasets.
• Proficiency in prompt engineering and generative AI tools such as ChatGPT or Claude for reporting or reconciliations.
• Ability to research, analyze, and resolve complex data discrepancies.
• Strong analytical, organizational, and problem-solving skills with attention to detail.
• Excellent verbal and written communication skills for internal and external stakeholders.
• Power BI, SharePoint, and Power Automate experience is also listed; the available description is truncated after this qualification.

Relevant tools and domains

• The description identifies Excel, Power BI, and other reporting tools for data analysis and management reporting.
• The role involves SQL reporting, generative AI tools, financial services, mortgage servicing, and regulatory reporting.

Work arrangement

• The source title explicitly identifies the role as remote.

Compensation

• The provided salary is USD 16–24 per hour.