Reconciliation Associate

Clearwater Analytics, Ltd.; City of Edinburgh; On-site; GBP 32,000 - 46,000; Full time

Job summary

Clearwater Analytics in Edinburgh is seeking a Reconciliation Analyst to compare investment portfolio data from external sources with our web-based system and deliver daily, accurate status updates to clients. Responsibilities include meeting daily deadlines, investigating discrepancies, building relationships with data providers and clients, and providing feedback to product teams.

A finance-related degree and 1+ years in reconciliation or accounting are preferred.

Qualifications

• Bachelor's degree in a finance-related and analytical field.
• 1+ years of directly applicable experience (reconciliation, accounting, or finance)

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.

Skills

Investment concepts

Accounting basics

Excel proficiency

Attention to detail

Communication skills

Problem solving

Education

Bachelor's degree in finance

Tools

Excel

Pivot Tables

VBA

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

• 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)

Thank you for your interest in a career with Clearwater! Clearwater Analytics (NYSE: CWAN) is transforming investment management with the industry’s most comprehensive cloud‑native platform for institutional investors across global public and private markets. While legacy systems create risk, inefficiency, and data fragmentation, Clearwater’s single‑instance, multi‑tenant architecture delivers real‑time data and AI‑driven insights throughout the investment lifecycle. The platform eliminates information silos by integrating portfolio management, trading, investment accounting, reconciliation, regulatory reporting, performance, compliance, and risk analytics in one unified system. Serving leading insurers, asset managers, hedge funds, banks, corporations, and governments, Clearwater supports over $8.8 trillion in assets globally. Learn more at www.clearwateranalytics.com.

Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. We are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with the job description, You may be just what we're looking for.