Data Reconciliation Analyst

This is a fully remote position, open to applicants in Arizona, +5 more states.

📋 Description

• Execute reconciliations among internal systems, databases, regulatory reports, and source documents.

• Validate data that supports Mortgage Call Reports, NMLS reporting, state licensing reports, investor reporting, and other reporting obligations.

• Create operational, reconciliation, management, and exception reports.

• Analyze data inconsistencies, determine root causes, and coordinate corrective measures.

• Interpret regulatory reporting mandates and convert them into reconciliation and validation methodologies.

• Collaborate with business units to outline data requirements and verify report outcomes.

• Conduct data quality assurance assessments, reconciliation testing, and validation processes.

• Oversee recurring reconciliation exceptions and suggest process enhancements, automation opportunities, and improved data controls.

• Develop and sustain reconciliation procedures, desktop procedures, data dictionaries, and related documentation.

• Assist in testing updates to regulatory reporting and new reporting demands.

• Support regulatory examinations, internal audits, client due diligence inquiries, and management requests.

• Utilize Microsoft Excel, Power BI, and other reporting tools to analyze extensive datasets, identify trends, and create management reporting.

• Maintain documentation that supports reconciliation processes, issue resolution, and regulatory reporting controls.

• Coordinate responses to clients and third parties regarding inquiries related to reporting.

⛳️ Requirements

• Three to five years of recent experience in data reconciliation, regulatory reporting, financial reporting, or data analysis within a banking, mortgage servicing, or financial services setting.

• Advanced proficiency in the Microsoft Office Suite.

• Expert-level skills in Microsoft Excel, including PivotTables, XLOOKUP, Power Query, and advanced formulas.

• Experience in reconciling reports and analyzing large datasets.

• Proficiency in prompt engineering and generative AI tools such as ChatGPT or Claude.

• Ability to research, analyze, and resolve complex data discrepancies.

• Strong analytical, organizational, and problem-solving capabilities with exceptional attention to detail.

• Excellent verbal and written communication skills.

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

🏝️ Benefits

• Medical insurance

• Dental insurance

• Vision insurance

• 401(k)

• PTO/paid sick leave

• Employee stock purchase plan

• Inclusive, people-first workplace culture