Investment Accounting & Risk Analyst
Position Overview
We are seeking an Investment Accounting & Risk Analyst to support a large financial services organization in Minneapolis. This role will combine financial and securities accounting knowledge, regression testing, risk analysis, and advanced Excel-based data analysis.
The ideal candidate will have hands-on experience working with bonds and fixed-income instruments, understand how bond structures and interest calculations work, and possess truly advanced Excel capabilities. This is not a traditional accounts payable/accounts receivable accounting position.
Key Responsibilities
- Support risk analytics and investment accounting initiatives involving financial and securities data.
- Perform regression testing to validate system functionality, calculations, and financial data accuracy.
- Analyze accounting and investment data related to bonds, securities, and fixed-income instruments.
- Review bond structures, calculation methodologies, interest payments, and related financial data.
- Research discrepancies and identify potential data, calculation, or system issues.
- Utilize advanced Excel functionality to organize, analyze, reconcile, and validate large datasets.
- Perform filtering, sorting, grouping, pivot table analysis, data imports, parsing, and data manipulation.
- Assist with identifying process improvements and resolving moderately complex analytical issues.
- Document testing results, findings, discrepancies, and recommended solutions.
- Collaborate with accounting, finance, risk, technology, and business partners.
Required Qualifications
- 2+ years of advanced finance or accounting experience, preferably involving:
- Securities accounting
- Investment accounting
- Bonds/fixed-income instruments
- Bond structures and interest calculations
- 1+ year of regression testing experience.
- 2+ years of advanced Microsoft Excel experience, including:
- Pivot tables
- Filtering and sorting
- Grouping
- Data imports
- Data parsing/manipulation
- Text to Columns and similar advanced functions
- Strong analytical and problem-solving skills.
- Ability to identify discrepancies and validate complex financial calculations and datasets.
- Comfortable working in a hybrid environment in Minneapolis.
Highly Preferred
- SimCorp regression testing experience
- Experience supporting investment or securities accounting systems
- Financial services, banking, investment management, or capital markets experience
- Business systems analysis experience
What We're Looking For
The strongest candidates will bring a combination of advanced Excel + bonds/investment accounting + regression testing. Candidates whose accounting experience is primarily limited to AP/AR without exposure to securities or fixed-income products are unlikely to be a fit.