Reconciliation Analyst

clearwateranalytics; Dadri; On-site; INR 500,000 - 900,000; Full time

Job summary

Clearwater Analytics is seeking a Reconciliation Analyst to compare investment portfolio data from external sources with an advanced web-based system and ensure timely, accurate portfolio status updates to clients daily.

The role emphasizes meeting daily deadlines, resolving issues in the reconciliation system, and maintaining strong relationships with data providers and clients while applying GAAP/IFRS knowledge and using Excel-based tools.

Qualifications

• Bachelor's degree in accounting, finance, business, mathematics, sciences or related field.
• Strong understanding of financial concepts and investments.
• Experience with GAAP/IFRS is a plus.
• Proficiency in Excel (VLOOKUP, Pivot Tables, VBA) and general Office tools.
• Attention to detail and strong documentation skills.
• Excellent written and verbal communication skills.

Responsibilities

• Meet daily deadlines for reviewing and updating reporting data.
• Investigate and address issues within reconciliation system.
• Build relationships with data providers, clients and internal stakeholders.
• Demonstrate curiosity about product innovations and processes.

Skills

Investment concepts

Financial concepts

Accounting concepts

GAAP/IFRS knowledge

Excel proficiency

Securities knowledge

Documentation skills

Communication skills

Problem solving

Education

Bachelor's degree

Tools

Microsoft Excel

Pivot Tables

VLOOKUP

VBA

Microsoft Office

Job description

The Reconciliation Analyst is responsible for comparing investment portfolio data from external sources with an advanced web- based syst em. Their primary responsibility is to guarantee the prompt and precise delivery of comprehensive portfolio status updates to clients on a daily ba sis.

Responsibilities:

• Meet daily deadlines for reviewing and updating reporting data.
• Investigate and address identified issues within the reconciliation system through problem-solving, seeking support from mentors and department experts as needed.
• Create and maintain valuable relationships with data providers, clients and internal stakeholders.
• Demonstrate curiosity regarding product innovation opportunities.
• Develop familiarity with and competency in using internal tools and processes.
• Understand financial concepts and apply them to reconciliation errors.
• Communicate effectively with internal and external parties to submit inquiries and provide timely updates on relevant issues.

Required Skills:

• Basic understanding of investment, financial, and accounting concepts.
• Knowledge of GAAP and/or IFRS will be an added advantage.
• Basic understanding of standard security types.
• Securities or financial markets experienc e preferred.
• Advanced ability in Microsoft Excel ( VLOOKUP , SUMIF, Pivot Tables, VBA, etc.) preferred.
• Finance and/or accounting experience preferred.
• Strong computer skills, including proficiency in Microsoft Office .
• Excellent attention to detail and strong documentation skills .
• Outstanding verbal and written communication skills .
• Strong organizational and interpersonal skills.
• Exceptional problem-solving abilities.

Education and Experience:

Bachelor's degree in accounting, Finance, Business, Mathematics, Sciences, or another related field.