Clearwater Analytics

Reconciliation Analyst

In short

This role compares investment portfolio data from external sources against a web-based reconciliation system to ensure clients receive accurate daily portfolio status updates. It's an office-based position at a financial data/analytics company in Edinburgh, suited to someone with a finance-related degree and at least 1 year of reconciliation, accounting, or finance experience. The job demands strong Excel skills, attention to detail, and the ability to apply financial concepts to resolve reconciliation errors.

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)

Stop applying.
Get referred.

$10 in free credits

In just 60 seconds, fully on autopilot — Eraldt's AI agents read your CV, map the roles you fit, find live vacancies and the people who can refer you, write personal emails, and get you referred.

This isn't an application: your CV doesn't go to the company, and we don't promise a referral for this exact role.

Discover who else lands interviews on autopilot