Reconciles investment portfolio data from external sources with an internal web-based system. Reviews and updates reporting data, investigates reconciliation issues, applies financial and accounting concepts, and delivers accurate daily portfolio updates to clients. Maintains relationships with data providers and stakeholders, communicates issue resolutions, documents processes, and provides feedback to product teams. Requires strong Excel, problem-solving, organizational, communication, and attention-to-detail skills.
The Reconciliation Associate is responsible for comparing investment portfolio data from external sources with an advanced web-based system. Their primary responsibility is to guarantee the prompt and precise delivery of comprehensive portfolio status updates to clients on a daily basis.
Responsibilities:
- Meets daily deadlines for the review and update of reporting data.
- Investigates and takes action on identified issues within the reconciliation system through problem-solving, seeking support from mentors and department experts as needed.
- Creates and maintains valuable relationships with data providers, clients, and internal stakeholders.
- Contributes feedback to product teams on internal projects as requested.
- Demonstrates familiarity and competency with internal tools and processes.
- Understands financial concepts and can apply them to reconciliation errors.
- Effectively communicates with internal and external parties to submit inquiries and provide timely updates on relevant issues.
Required Skills:
- Basic understanding of investment, financial, and accounting concepts.
- Finance and/or accounting experience preferred.
- Knowledge of GAAP and/or IFRS will be an added advantage.
- Basic understanding of standard security types.
- Securities or financial markets experience preferred.
- Advanced ability in Microsoft Excel (VLOOKUP, SUMIF, Pivot Tables, VBA, etc.) preferred.
- Strong computer skills, including proficiency in Microsoft Office.
- Excellent attention to detail and strong documentation skills.
- Outstanding verbal and written communication skills.
- Strong organizational and interpersonal skills.
- Exceptional problem-solving abilities.
Education and Experience:
- Bachelor's degree in a finance-related and analytical field.
- 1+ years of directly applicable experience (reconciliation, accounting, or finance)
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
Lead reconciliation analyst who designs and automates reconciliation processes, validates third-party and custodial data, back-reconciles and normalizes client investment books, monitors discrepancies, and communicates progress with project leads while applying investment accounting knowledge.
Top Skills:
ExcelMS OfficePivot TablesSumifVlookup
Fintech • Software • Financial Services
Reconciles investment portfolio transactions and holdings against external provider data, investigates discrepancies, updates client reporting, and meets daily deadlines. Builds relationships with clients and data providers, supports workflow improvements and internal projects, analyzes success metrics, mentors analysts, resolves complex issues, and develops training materials. Requires intermediate investment, financial, accounting, and GAAP knowledge, along with strong communication and problem-solving skills.
Fintech • Software • Financial Services
Creates and maintains technical documentation for complex fintech and SaaS products, translating information from product managers and engineers into clear content. Owns content from drafting through publication, manages documentation pipelines in Jira, maintains knowledge-base standards, uses AI tools such as Claude, supports editorial improvements, and mentors junior writers.
Top Skills:
Adobe Creative CloudAPIsCanvaClaudeClisConfluenceCSSFigmaGitlabHTMLIdesJavaJIRALoomMarkdownPythonSnagit
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

