Investment Accounting & Risk Analyst

Risk Analytics Consultant 

Location: Minneapolis, MN
Job Type: Contract
Duration: 6 months
Max Pay Rate:$43.75/hr
Start Date: ASAP / Targeting early October 2026
Schedule: Hybrid — minimum3 days onsite per week
Potential: Extension possible based on performance and business need

Position Overview

We are seeking aRisk Analytics Consultant to support regression testing and financial systems validation within a Finance/Controllers environment. This role will be heavily focused onadvanced Excel, regression testing, data manipulation, and validation of system outputs.

The ideal candidate will have strong QA or testing experience combined with advanced Excel skills. Experience inbanking, securities, investment accounting, investment operations, corporate trust, or other financial-services environments is highly preferred but not required.

Key Responsibilities

• Execute regression and functional testing related to a financial system upgrade.
• Work extensively withmacro-enabled Excel spreadsheets and existing regression scripts.
• Manipulate, filter, sort, and validate large datasets.
• Compare test results and identify differences between systems and environments.
• Use Excel features such asPivot Tables, Text to Columns, filtering, sorting, data imports, and data parsing.
• Navigate network folders and manage files required for testing.
• Perform basic imports and exports and validate system outputs.
• Research and analyze low-to-moderately complex Risk Analytics assignments.
• Identify opportunities for process improvements.
• Investigate discrepancies and evaluate alternative solutions.
• Present recommendations for resolving issues and exercise independent judgment.
• Support testing documentation and cleanup activities following testing cycles.
• Provide information and support to internal business partners.
• Learn and navigateSimCorp Dimension, the team's investment management system of record.

Required Qualifications

• 1+ year of regression testing experience.
• 2+ years of advanced finance or accounting experience, preferably involving securities, investments, or financial systems.
• 2+ years of advanced Microsoft Excel experience.
• Demonstrated experience with:
  • Filtering and sorting
  • Pivot Tables
  • Grouping
  • Data manipulation
  • Data import and parsing
  • Text to Columns
  • Comparing datasets and test results
• Strong analytical and critical-thinking skills.
• Ability to research issues, evaluate alternatives, and make sound recommendations.
• Strong attention to detail and ability to work independently.
• Ability to work onsite in Minneapolis at least 3 days per week.

VBA/coding is NOT required. Candidates should be advanced Excel users who can work with existing macros and spreadsheets rather than Excel developers.

Preferred Experience

• SimCorp Dimension
• Investment accounting
• Securities accounting
• Investment operations
• Bond instruments and payment methodologies
• Equities
• Corporate trust
• Banking or financial services
• Financial systems testing
• Bloomberg
• SWIFT
• System upgrades or migrations
• UAT or functional testing