Sonata Software - Financial Analyst

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 dataset

- Masters degree in Finance and Accounting (MBA) preferred

Preferred Qualifications:

- Experience working with US-based financial institutions or servicers.

- Exposure to cash management functions.

- Familiarity with GAAP and compliance-related reconciliation processes