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.
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 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
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 a web-based reconciliation system, updating reports, investigating discrepancies, and communicating status updates. The intern receives mentorship while developing foundational knowledge of financial markets, accounting concepts, reconciliation processes, reporting, and client communication. Responsibilities also include documenting work, completing learning projects, and collaborating with data providers, clients, and internal stakeholders.
Top Skills:
ExcelMS OfficePivot TablesSumifVBAVlookup
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
