Reconciliation Analyst Intern
Required skills
- investment portfolio data
- reconciliation system
- reporting data
- Microsoft Excel
- VLOOKUP
- SUMIF
- Pivot Tables
- Microsoft Office
- documentation skills
- eagerness to learn
Nice to have
- GAAP
- IFRS
- standard security types
- securities
- financial markets
- VBA
Role 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 include assisting with reporting data, investigating reconciliation system issues under guidance, supporting team relationships, and developing an understanding of financial concepts and reconciliation errors. The role requires basic understanding of investment, financial, and accounting concepts, proficiency in Microsoft Excel and Office, strong attention to detail, communication, and organizational skills. Familiarity with GAAP/IFRS and securities is a plus.
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 roles
- Quantitative Financial Analyst IClearwater Analytics · Boise, ID · Onsite
- Business Development RepresentativeClearwater Analytics · Boise, ID · Onsite
Reconciliation Analyst - Remote USCoverMyMeds · Remote · Remote- Financial Reconciliation AnalystThe Stevens & Lee Companies · Reading, PA · Onsite
Bank Reconciliation Analyst (Remote)First American · Remote · Remote- Reconciliation Analyst / Investment Operations Process AnalystDodge & Cox · San Francisco, CA · Hybrid
