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