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.
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
Clearwater Analytics (CWAN) Chicago, Illinois, USA Office
Located in the heart of the Loop in Downtown Chicago. The office is easy to get to with various train and bus stops nearby.
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 develops foundational knowledge of financial reconciliation, accounting concepts, securities, reporting, and investment technology while completing training and assigned projects under supervision.
Top Skills:
ExcelMS OfficePivot TablesSumifVBAVlookup
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
