Reconciliation Analyst Intern

Job Description

Reconciliation Analyst Intern | Clearwater Analytics

The Tone:
This is a Reconciliation Analyst Internship at Clearwater Analytics, a company that develops cutting-edge investment reporting technology. Clearwater Analytics builds an advanced web-based reconciliation system designed to compare and consolidate complex investment portfolio data received from various external sources. This role offers hands-on exposure to this technology, supporting a team dedicated to ensuring the timely and accurate delivery of comprehensive portfolio status updates to clients. The intern will build foundational skills in financial reconciliation and reporting, contributing directly to the company’s core mission of providing reliable investment data.

The TL;DR
• Role: Internship
• Location: Hybrid
• Team: Reconciliation team, working alongside experienced analysts and mentors.
• Mission: Ensure timely and accurate delivery of investment 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 Review and Updating: Assist with reviewing and updating reporting data within the advanced web-based reconciliation system, contributing to daily deadlines and ensuring data accuracy.
• Issue Investigation: Learn to investigate and help address discrepancies or issues identified within the reconciliation system, working closely with experienced mentors and department experts to find resolutions.
• Relationship Support: Support the team in building and maintaining professional relationships with various data providers, external clients, and internal stakeholders to facilitate smooth data flow and communication.
• Professional Communication: Communicate professionally with both internal teams and external parties, including submitting inquiries for data clarification and providing updates on reconciliation statuses under supervision.
• Technical and Industry Learning: Complete assigned projects and dedicated learning modules, designed to deepen understanding of both technical tools and processes, as well as broader industry knowledge related to financial reconciliation.

The Must-Haves
• Background: Candidates must currently be pursuing a Bachelor’s degree in Accounting, Finance, Business, Mathematics, Sciences, or a closely related field, with a preference for rising juniors or seniors. A basic understanding of core investment, financial, and accounting concepts is required to grasp the fundamentals of reconciliation processes.
• Experience: No prior professional experience is explicitly required for this internship position, making it an ideal entry point for students seeking their first professional role in financial technology.
• Skills: This role requires a working knowledge of Microsoft Excel, including familiarity with functions like VLOOKUP, SUMIF, and Pivot Tables. Strong overall computer proficiency, including other Microsoft Office applications, is essential. Candidates must possess excellent attention to detail and strong documentation skills for accurate record-keeping. Effective verbal and written communication skills are necessary for interacting with internal and external parties. Strong organizational and interpersonal skills are also vital for team collaboration, alongside a demonstrated eagerness to learn and solve problems.
• Bonus: Preferred qualifications include familiarity with accounting principles such as GAAP and/or IFRS, a basic understanding of standard security types, and academic coursework or a general interest in securities or financial markets. Proficiency in VBA within Excel is also considered a plus.