Posted 6 days ago
Reconciliation Analyst Intern
BoiseRemoteFull-time
AI Summary
Supports the reconciliation team by comparing investment portfolio data against a web-based reconciliation system, ensuring timely and accurate client portfolio status updates under mentor guidance.
About this role
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
Skills
ExcelFinancial ReconciliationGAAPIFRSInvestment ReportingMicrosoft OfficePivot TablesSUMIFVBAVLOOKUP
Explore related jobs
More jobs at Clearwater Analytics, LLC
Similar Excel jobs
Jobs in Boise
Assistant TechnicianNWESI · Boise, Idaho- Community ManagerRedstone Residential · Boise, Idaho
- Distribution OperatorVeolia Environnement SA · Boise, ID
- Service Technician for Maintenance & Repair - On Call As NeededNational Water Services · Boise, Idaho
BAS Business Development RepresentativeKelso Building Services · Boise, ID- Service Delivery ManagerClearwater Analytics, LLC · Office - Boise
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.