Reconciliation Analyst Intern

Job Description

Reconciliation Analyst Intern | Clearwater Analytics

The Tone:
This is an internship opportunity at Clearwater Analytics, a financial technology company that provides an advanced web-based reconciliation system for investment portfolio data. Located in a hybrid setting, with work-from-home Fridays, this role is crucial in supporting the reconciliation team. As an intern, you will contribute directly to ensuring the timely and accurate delivery of portfolio status updates to clients, while building foundational skills in financial reconciliation and reporting within the fintech industry.

The TL;DR
• Role: Internship
• Location: Hybrid – Boise, ID
• Team: Reconciliation Analyst Team, working alongside experienced analysts
• Mission: Help ensure the timely and accurate delivery of portfolio status updates to clients.
• Tech Stack: Advanced web-based reconciliation system, Microsoft Excel (VLOOKUP, SUMIF, Pivot Tables), Microsoft Office

What You’ll Actually Do
• Data Management: Assist with reviewing and updating reporting data to help meet daily deadlines.
• Issue Resolution: Learn to investigate and resolve issues within the reconciliation system under the guidance of mentors and department experts.
• Stakeholder Collaboration: Support the team in building and nurturing relationships with data providers, clients, and internal stakeholders.
• Financial Analysis: Develop an understanding of financial concepts and how they apply to the resolution of reconciliation errors.
• Professional Communication: Communicate professionally with internal and external parties, submitting inquiries and providing updates under supervision.

The Must-Haves
• Background: Currently pursuing a Bachelor’s degree in Accounting, Finance, Business, Mathematics, Sciences, or a related field, with a preference for rising juniors or seniors. Candidates should possess a basic understanding of core investment, financial, and accounting concepts.
• Experience: No prior professional experience is required for this role. However, candidates should demonstrate a working knowledge of Microsoft Excel, including proficiency with functions such as VLOOKUP, SUMIF, and Pivot Tables.
• Skills: Working knowledge of Microsoft Excel (VLOOKUP, SUMIF, Pivot Tables); excellent attention to detail and strong documentation skills; strong verbal and written communication skills; strong organizational and interpersonal skills; and an eagerness to learn and solve problems.
• Bonus: Familiarity with GAAP and/or IFRS accounting standards is a plus, as is a basic understanding of standard security types. Coursework or demonstrated interest in securities or financial markets is preferred, and any experience with VBA would be a valuable asset.