Reconciliation Analyst

Clearwater Analytics, LLC; Boise (ID); On-site; USD 50,000 - 70,000; Full time

Job summary

Clearwater Analytics, LLC in Boise, Idaho is seeking a Reconciliation Analyst responsible for comparing investment portfolio data and ensuring accurate daily updates for clients. Candidates must have a bachelor’s degree in a relevant field and strong skills in Microsoft Excel.

The role entails meeting daily reporting deadlines, resolving issues in the reconciliation system, and building relationships with data providers. Knowledge of financial concepts is essential for success in this position.

Qualifications

• Basic understanding of investment, financial, and accounting concepts.
• Knowledge of GAAP and/or IFRS is a plus.
• Experience in securities or financial markets preferred.

Responsibilities

• Meet daily deadlines for reporting updates.
• Investigate and resolve reconciliation issues.
• Maintain relationships with data providers and clients.

Skills

Microsoft Excel (VLOOKUP, SUMIF, Pivot Tables, VBA)

Attention to detail

Verbal and written communication

Organizational skills

Problem-solving abilities

Education

Bachelor's degree in accounting, Finance, Business, Mathematics, or Sciences

Tools

Microsoft Office

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

• Meet daily deadlines for reviewing and updating reporting data.
• Investigate and address identified issues within the reconciliation system through problem‑solving, seeking support from mentors and department experts as needed.
• Create and maintain valuable relationships with data providers, clients, and internal stakeholders.
• Demonstrate curiosity regarding product innovation opportunities.
• Develop familiarity with and competency in using internal tools and processes.
• Understand financial concepts and apply them to reconciliation errors.
• Communicate effectively 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.
• Knowledge of GAAP and/or IFRS – 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.
• Finance and/or accounting experience 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 accounting, Finance, Business, Mathematics, Sciences, or another related field.