Reconciliation Analyst

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

Job summary

Clearwater Analytics, Ltd. seeks a Reconciliation Analyst to compare portfolio data from external sources with an advanced web-based system. You will ensure prompt, precise delivery of detailed portfolio status updates to clients daily.

Responsibilities include meeting daily deadlines, resolving reconciliation issues, and collaborating with data providers and internal teams. Strong Excel, GAAP/IFRS knowledge, and communication skills are required.

Qualifications

• Bachelor's degree in finance or analytical field required.
• 1+ years of reconciliation, accounting, or finance experience preferred.

Responsibilities

• Meets daily deadlines for updating reporting data.
• Investigates issues in the reconciliation system and seeks guidance as needed.
• Builds relationships with data providers, clients, and internal stakeholders.
• Provides feedback to product teams on internal projects.
• Demonstrates familiarity with internal tools and processes.
• Applies financial concepts to reconciliation errors.
• Communicates with internal and external parties to submit inquiries and provide updates.

Skills

Excel advanced

Financial concepts

GAAP IFRS knowledge

Communication skills

Problem solving

Attention to detail

Education

Bachelor's degree in finance/analytical field

Tools

Microsoft Office

VBA

Pivot Tables

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

Company Overview

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.

Diversity Statement

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, we encourage you to still apply! You may be just what we're looking for.