Reconciliation Analyst

Clearwater Analytics; Dadri; On-site; INR 600,000 - 900,000; Full time

Job summary

Clearwater Analytics is seeking a Reconciliation Analyst in India to ensure accurate daily portfolio status updates by comparing external data with our web-based system. You will review data, resolve issues, and build client and data-provider relationships.

Ideal candidates have a finance/accounting background, solid Excel skills, and strong communication. Knowledge of GAAP/IFRS and financial markets is a plus, with opportunities to grow in a collaborative environment.

Qualifications

• Bachelor's degree in accounting, finance, business or related field.
• Basic understanding of investment, financial and accounting concepts.
• Knowledge of GAAP and IFRS is a plus.
• Experience with securities or financial markets preferred.
• Strong Excel skills (VLOOKUP, SUMIF, Pivot Tables, VBA).
• Strong communication and documentation skills.

Responsibilities

• Meet daily deadlines for reviewing and updating reporting data.
• Investigate and address issues within the reconciliation system.
• Build relationships with data providers, clients, and internal teams.
• Show curiosity about product innovation opportunities.
• Familiarize yourself with internal tools and processes.
• Understand financial concepts and apply them to reconciliation errors.
• Communicate effectively with internal and external parties about issues.

Skills

Attention to detail

Communication skills

Problem-solving

Interpersonal skills

Organizational skills

Education

Bachelor's degree in accounting/finance/business

Tools

Microsoft Excel

VBA

Pivot Tables

VLOOKUP

Job description

Job Summary:

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

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 experience 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.