Reconciliation Analyst

Clearwater Analytics (CWAN); Boise (ID); On-site; USD 65,000 - 90,000; Full time

Job summary

Clearwater Analytics CWAN is seeking a Reconciliation Analyst to compare portfolio data from external sources with our advanced web-based system and ensure timely, accurate client updates. You will review data daily, investigate discrepancies, and collaborate with data providers and internal teams to address issues.

The role requires strong Excel skills, GAAP/IFRS knowledge, and excellent communication. Candidates with securities experience and solid problem-solving abilities will excel in this

Qualifications

• Bachelor's degree in accounting, finance, business, mathematics, or a related field.
• GAAP/IFRS knowledge is a plus.
• Securities or financial markets experience preferred.
• Experience with reconciliation processes is beneficial.

Responsibilities

• Compare portfolio data from external sources with an advanced web-based system.
• Meet daily deadlines for reviewing and updating reporting data.
• Investigate and address issues within the reconciliation system.
• Maintain relationships with data providers, clients, and internal stakeholders.

Skills

Investment concepts

GAAP/IFRS knowledge

Security types knowledge

Attention to detail

Communication skills

Problem-solving

Data analysis

Organizational skills

Education

Bachelor's degree in Accounting/Finance/Business/Mathematics

Tools

Microsoft Excel

Pivot Tables

VLOOKUP

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