Job Title:
Financial Professional
Company: Sonata Software
Location: Bengaluru, Karnataka
Created: 2025-10-16
Job Type: Full Time
Job Description:
Job Title: Financial Analyst Experience: 8+ Years Location: Bangalore (Hybrid / Remote) Industry: US Mortgage / Financial Services Need candidate with strong Mortgage experience, Strong excel skills including modelling and SQL. 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 • Master’s 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.