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 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, 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 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 Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center

