Back to Jobs
Recently postedFinance

Reconciliation Senior Middle Office Specialist Retail Wealth Management

Key2Source INCWindsor, CT🇺🇸United States

Quick overview

SeniorityMid-Senior
Work modeHybrid
LocationWindsor, CT, United States
OnboardingSQLMicrosoft ExcelComplianceFixed IncomeInternal AuditProcess ImprovementReconciliationPower BI

Job description

Job Description: Reconciliation Senior Middle Office Specialist Retail Wealth Management

Location: Windsor, CT

Business Area: Retail Wealth Management
Function: Middle Office / Investment Operations
Primary Platform: Orion
Experience: 8-10+ years
Industry: Wealth Management / Brokerage / Investment Operations

Position Summary

We are seeking an experienced Reconciliation Middle Office Specialist to support Retail Wealth Management operations, with a primary focus on back-office reconciliation, data integrity, exception management, and operational controls within the Orion platform.

The candidate will be responsible for ensuring accurate and timely reconciliation of cash, positions, transactions, securities, account balances, and custodial data across Orion and upstream/downstream systems. This role will work closely with custodians, operations, technology, data, and platform-support teams to investigate reconciliation breaks, identify root causes, and drive issues through resolution.

The ideal candidate will have strong hands-on experience with Orion, portfolio accounting, investment operations, custodial feeds, and wealth-management reconciliation processes.

Roles & Responsibilities

Daily Reconciliation & Exception Management

  • Perform daily reconciliation of cash, positions, transactions, securities, and account balances between Orion, custodians, and other books and records.
  • Monitor reconciliation dashboards, reports, queues, and exception files to identify breaks and discrepancies.
  • Research and resolve differences involving:
    • Cash balances
    • Security positions
    • Trades and transactions
    • Deposits and withdrawals
    • Dividends and interest
    • Fees
    • Security pricing
    • Corporate actions
    • Cost basis and other account-level information
  • Investigate aged and recurring reconciliation exceptions and ensure timely resolution within established SLAs.
  • Maintain accurate supporting documentation and audit trails for reconciliation activities.
  • Escalate material or unresolved reconciliation issues through appropriate operational channels.

Orion Reconciliation & Data Operations

  • Perform hands-on reconciliation and operational activities using Orion.
  • Monitor and validate inbound custodial and investment data feeds into Orion.
  • Identify missing, delayed, duplicate, or inaccurate data impacting account and portfolio records.
  • Investigate discrepancies between Orion and custodian/source-system records.
  • Validate successful processing of daily files and data-loading activities.
  • Research account, security, transaction, and position-level issues within Orion.
  • Coordinate with Orion/ platform support and internal technology teams to resolve data-feed and reconciliation issues.
  • Support onboarding and validation of new data feeds, custodians, accounts, or books of business when required.

Custodial Data & Interface Reconciliation

  • Monitor daily custodial interfaces and ensure data is received and processed completely and accurately.
  • Validate account, position, transaction, security, and cash data received from custodians.
  • Identify file-processing failures, missing feeds, data-quality issues, and interface exceptions.
  • Work with custodians, technology teams, and platform support to investigate and resolve data-feed discrepancies.
  • Perform reconciliation between custodian/source data and Orion portfolio accounting records.
  • Support remediation activities following feed failures, delayed files, or processing issues.

Wealth Management Operations

  • Support reconciliation activities for brokerage, advisory, managed, retirement-related, and other applicable retail investment accounts.
  • Apply knowledge of the investment processing lifecycle, including:
    • Trade execution and settlement
    • Cash movements
    • Securities processing
    • Transfers
    • Fees
    • Corporate actions
    • Dividends and interest
    • Security pricing
    • Account maintenance
  • Understand how different investment products and transaction types affect portfolio accounting and reconciliation.
  • Support operational activities associated with equities, fixed income, mutual funds, ETFs, managed accounts, cash products, and other wealth-management products.
  • Ensure downstream systems receive accurate and reconciled investment/account data.

Break Resolution & Root-Cause Analysis

  • Perform detailed analysis of complex and recurring reconciliation breaks.
  • Trace issues across the transaction/data lifecycle to determine whether discrepancies originate from:
    • Custodial feeds
    • Source systems
    • Data transformation or interfaces
    • Security master/reference data
    • Orion processing
    • Transaction mapping
    • Pricing
    • Account configuration
  • Conduct root-cause analysis and coordinate permanent remediation of recurring issues.
  • Differentiate between operational exceptions, data-quality issues, system defects, and interface failures.
  • Partner with technology and data teams to define corrective actions where system changes are required.

Operational Controls & Data Quality

  • Execute daily, weekly, and monthly reconciliation controls.
  • Ensure outstanding reconciliation items are appropriately tracked, aged, documented, and resolved.
  • Monitor key operational metrics including:
    • Break volumes
    • Aging
    • Resolution turnaround
    • Recurring exceptions
    • Data-feed failures
    • SLA adherence
  • Maintain reconciliation procedures, SOPs, control documentation, and operational runbooks.
  • Support internal audit, compliance, and operational-risk reviews as required.
  • Identify operational risks associated with unresolved or recurring reconciliation exceptions.
  • Ensure processes comply with established operational-control and data-governance standards.

Process Improvement & Automation

  • Identify repetitive manual reconciliation activities suitable for automation.
  • Recommend improvements to reconciliation rules, matching logic, exception workflows, and operational controls.
  • Partner with technology teams to enhance automated reconciliation capabilities.
  • Participate in testing and validation of system enhancements affecting Orion or reconciliation processes.
  • Support UAT, production validation, and post-implementation reconciliation for platform or data changes.
  • Analyze recurring break patterns and recommend preventive improvements rather than relying solely on manual correction.

Cross-Functional Collaboration

Partner closely with:

  • Middle Office Operations
  • Back Office Operations
  • Investment Operations
  • Custodian Operations
  • Trading Operations
  • Data Management teams
  • Technology/Application Support
  • Orion Platform Support
  • Security Master / Reference Data teams
  • Risk and Compliance teams
  • Finance/Accounting teams, where applicable

The role will be primarily operations and reconciliation focused, with no direct Financial Advisor support responsibility.

Required Qualifications

  • 8-10+ years of experience in wealth management, investment operations, middle-office operations, portfolio accounting, or reconciliation.
  • Strong hands-on experience with Orion in a wealth-management or investment-operations environment.
  • Strong experience with:
    • Cash reconciliation
    • Position reconciliation
    • Transaction reconciliation
    • Custodial data reconciliation
    • Portfolio accounting
    • Exception management
    • Data-feed monitoring
  • Experience investigating complex reconciliation breaks and performing root-cause analysis.
  • Strong understanding of the trade lifecycle and settlement processes.
  • Knowledge of investment products including equities, fixed income, mutual funds, ETFs, managed accounts, and cash products.
  • Experience working with custodial feeds and financial data interfaces.
  • Strong analytical and problem-solving skills.
  • Advanced Excel skills and ability to analyze high-volume reconciliation data.
  • Strong attention to detail and ability to work within a controlled, deadline-driven financial-services environment.
  • Ability to manage multiple reconciliation exceptions and operational priorities simultaneously.

Preferred Qualifications

  • Experience in Retail Wealth Management, RIA, Broker-Dealer, or Investment Management operations.
  • Strong experience with Orion portfolio accounting and reconciliation functionality.
  • Experience working with major custodians and their data feeds.
  • Experience with portfolio accounting, performance, security master, and reference-data processes.
  • Understanding of corporate actions, fee processing, cost basis, pricing, and securities processing.
  • Experience with SQL, Power BI, reconciliation tools, or data-analysis platforms is desirable.
  • Experience supporting data migrations, platform conversions, or onboarding of investment accounts/books of business onto Orion.
  • Experience participating in UAT and production validation for investment-operations systems.
  • Knowledge of operational risk, controls, audit, and regulatory requirements within a financial-services environment.

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs