Back to jobs
Clearwater Analytics
Clearwater Analytics

Reconciliation Analyst

City of Edinburgh On-site 0-2 yrs exp Software Development 3,280 employees
Investment Portfolio ReconciliationFinancial ConceptsAccounting ConceptsMicrosoft ExcelVLOOKUP

Requirements

A bachelor's degree in a finance-related and analytical field and at least one year of applicable reconciliation, accounting, or finance experience are required. Candidates should understand investment, financial, and accounting concepts, have strong Excel and computer skills, and demonstrate excellent attention to detail, communication, organization, and problem-solving abilities.

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)

Education

Bachelor Degree

Skills

Investment Portfolio ReconciliationFinancial ConceptsAccounting ConceptsMicrosoft ExcelVLOOKUPSUMIFPivot TablesVBAMicrosoft OfficeGAAPIFRSAttention To DetailDocumentationVerbal And Written CommunicationProblem-SolvingStakeholder Relationship Management

About Clearwater Analytics

Clearwater Analytics is the natively agentic investment management platform built on a single, continuously reconciled investment record. Portfolio management, trading, accounting, risk, compliance, and private markets workflows run on a single source of truth, creating a connected foundation for automation, AI-driven insights, and agentic workflows across the investment process. Clearwater supports more than $10 trillion in assets globally for insurers, asset managers, hedge funds, banks, corporations, and governments. Learn more at www.cwan.com.

View company profile →