Supports investment portfolio reconciliation by comparing external data with an internal reconciliation system, reviewing reporting data, investigating discrepancies, and communicating updates. The intern develops foundational knowledge of financial reconciliation, accounting concepts, securities, reporting, and investment technology while completing training and assigned projects under supervision.
Job Summary:
The Reconciliation Analyst Intern will support the team in comparing investment portfolio data from external sources against an advanced web-based reconciliation system. Working alongside experienced analysts, the intern will help ensure the timely and accurate delivery of portfolio status updates to clients, while building foundational skills in financial reconciliation and reporting.
Responsibilities:
- Assist with reviewing and updating reporting data to help meet daily deadlines.
- Learn to investigate and help address issues within the reconciliation system, with guidance from mentors and department experts.
- Support the team in building relationships with data providers, clients, and internal stakeholders.
- Demonstrate curiosity about product innovation opportunities.
- Build familiarity with internal tools and processes through hands-on training.
- Develop an understanding of financial concepts and how they apply to reconciliation errors.
- Communicate professionally with internal and external parties, submitting inquiries and providing updates under supervision.
- Complete assigned projects or learning modules to deepen technical and industry knowledge.
Required Skills:
- Basic understanding of investment, financial, and accounting concepts.
- Familiarity with GAAP and/or IFRS is a plus.
- Basic understanding of standard security types is a plus.
- Coursework or interest in securities or financial markets preferred.
- Working knowledge of Microsoft Excel (VLOOKUP, SUMIF, Pivot Tables); VBA a plus.
- Strong computer skills, including proficiency in Microsoft Office.
- Excellent attention to detail and strong documentation skills.
- Strong verbal and written communication skills.
- Strong organizational and interpersonal skills.
- Eagerness to learn and solve problems.
Education and Experience:
- Currently pursuing a Bachelor's degree in Accounting, Finance, Business, Mathematics, Sciences, or a related field (rising junior/senior preferred).
- No prior professional experience required.
What we offer:
- Business casual atmosphere in a flexible working environment
- Team-focused culture that promotes innovation and ownership
- Hands-on exposure to cutting-edge investment reporting technology and expertise
- Mentorship and structured learning opportunities
- Networking events and exposure to cross-functional teams
- Potential pathway to full-time opportunities
- Work from home Fridays
Similar Jobs at Clearwater Analytics (CWAN)
Fintech • Software • Financial Services
Supports investment portfolio data reconciliation by comparing external data with a web-based system, reviewing reporting data, investigating discrepancies, and communicating updates. The intern develops skills in financial reconciliation, reporting, investment concepts, documentation, and client and stakeholder communication while completing assigned projects and training.
Top Skills:
ExcelMS OfficeVBA
Fintech • Software • Financial Services
Supports investment portfolio reconciliation by comparing external data with an internal reconciliation system, updating reports, investigating discrepancies, communicating with stakeholders, and completing assigned learning projects. The role develops foundational knowledge of financial reconciliation, accounting concepts, securities, reporting, and investment technology under mentorship.
Top Skills:
ExcelMS OfficePivot TablesSumifVBAVlookup
Fintech • Software • Financial Services
Supports investment portfolio reconciliation by comparing external data with an internal reconciliation system, reviewing reporting data, investigating discrepancies, and communicating updates. The intern learns financial reconciliation, reporting, investment concepts, and internal tools while assisting with client, data-provider, and stakeholder relationships. Responsibilities include meeting daily deadlines, documenting work, completing learning projects, and identifying product innovation opportunities. No prior professional experience is required; candidates should be pursuing a relevant bachelor's degree and have basic finance knowledge and Excel skills.
Top Skills:
ExcelMS OfficeVBA
What you need to know about the Edinburgh Tech Scene
From traditional pubs and centuries-old universities to sleek shopping malls and glass-paneled office buildings, Edinburgh's architecture reflects its unique blend of history and modernity. But the fusion of past and future isn't just visible in its buildings; it's also shaping the city's economy. Named the United Kingdom's leading technology ecosystem outside of London, Edinburgh plays host to major global companies like Apple and Adobe, as well as a growing number of innovative startups in fields like cybersecurity, finance and healthcare.
