Industry : US Mortgage / Financial Services
Job Summary :
We are seeking a detail-oriented and experienced Financial Analyst to oversee and manage Bank reconciliation activities within the Treasury function. The ideal candidate should have 8+ years of hands-on experience in Bank / Merchant account reconciliation, preferably within the US mortgage industry. Strong analytical capabilities and advanced Excel proficiency are essential for this role.
Key Responsibilities :
- Perform and review daily, weekly, and monthly bank reconciliations for multiple entities and accounts.
- Investigate and resolve reconciliation differences by liaising with internal teams and banking partners.
- Reconcile transactions related to payments, payoffs, escrow, and other mortgage-related inflows and outflows.
- Ensure all transactions comply with company policies, accounting standards, and regulatory requirements.
- Assist in automation initiatives and process improvements related to reconciliation activities.
- Coordinate with production, accounting, and technology teams for issue resolution and workflow efficiency.
- Maintain audit-ready documentation and support internal / external audit requests.
- Prepare regular reports and dashboards highlighting reconciliation status, exceptions, and aging items.
- Query and extract data from relationship database to produce reports and refresh on a daily basis
Required Skills and Qualifications :
8+ years of relevant experience in bank reconciliation, with at least 6 years in the US mortgage industry.Strong understanding of mortgage loan cycles, escrow accounting, and settlement processes.Proficiency in Microsoft Excel (vlookups, pivots, advanced formulas, macros preferred).Experience with reconciliation tools and mortgage origination platforms is a plus.Analytical mindset with excellent attention to detail and problem-solving skills.Strong communication and coordination abilities across cross-functional teams.Intermediate knowledge of SQL, can extract data and build logic on top of raw datasetMasters degree in Finance and Accounting (MBA) preferredPreferred Qualifications :
Experience working with US-based financial institutions or servicers.Exposure to cash management functions.Familiarity with GAAP and compliance-related reconciliation processes(ref : iimjobs.com)