Reconciliation Analyst

Clearwater Analytics; City of Edinburgh; Hybrid; GBP 28,000 - 38,000; Full time

Job summary

Clearwater Analytics is seeking a Reconciliation Analyst to join our Edinburgh office. You will compare portfolio data from external sources with our web-based system to ensure timely, accurate client updates on a daily basis.

You will meet daily deadlines, investigate issues, and communicate effectively with data providers, clients, and internal teams. A finance background and strong Excel skills are essential for success in this role.

Qualifications

• Bachelor's degree in a finance-related and analytical field.
• 1+ years of reconciliation, accounting, or finance experience preferred.
• Basic understanding of investment concepts and accounting principles.

Responsibilities

• Match investment portfolio data from external sources with the reconciliation system.
• Investigate issues, escalate as needed, and document actions taken.
• Maintain relationships with data providers, clients, and internal teams.

Skills

Investment concepts

Accounting concepts

GAAP IFRS

Security types

Excel skills

VBA

Communication

Attention to detail

Documentation

Problem-solving

Organizational skills

Education

Bachelor's degree in finance/analytical field

Tools

Microsoft Excel

Pivot Tables

VBA

Job description

## Reconciliation AnalystApply: Office - Edinburgh: Full time: Posted Today: R12257**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:*** Meets daily deadlines for the review and update of reporting data.* Investigates and takes action on identified issues within the reconciliation system through problem-solving, seeking support from mentors and department experts as needed.* Creates and maintains valuable relationships with data providers, clients, and internal stakeholders.* Contributes feedback to product teams on internal projects as requested.* Demonstrates familiarity and competency with internal tools and processes.* Understands financial concepts and can apply them to reconciliation errors.* Effectively communicates 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.* Finance and/or accounting experience preferred.* 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.* 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 a finance-related and analytical field.* 1+ years of directly applicable experience (reconciliation, accounting, or finance)