Portfolio Management Data Operations & Reconciliation Specialist (Contract)

Daily Batch Data Reconciliation

Execute daily cash, position, market value, and transaction reconciliations between custodial data feeds and the AdvisorEngine portfolio management system. Investigate, troubleshoot, and resolve daily reconciliation issues, trade breaks, pricing anomalies, etc.

Performance Auditing

Proactively audit daily, monthly, YTD, and ITD performance returns to identify anomalies, out-of-tolerance outliers, or data spikes. Reverse engineer outliers to provide root cause analysis.

Fee Billing & Revenue Operations

Monitor and review the monthly/quarterly advisory fee billing cycle per client. Reconcile complex fee schedules, householding rules, and tier structures within the AdvisorEngine portfolio management system.

Fixed Income Operations

Reconcile daily accrual calculations, amortization and accretion adjustments, and income projections.

Data Foundation & Troubleshooting

Research and resolve underlying data issues that impact performance and billing, such as unpriced securities, corporate actions, cash flow timing errors, incorrect transaction mappings, batch data feed issues, incorrect/incomplete security reference data, and software issues.

Exception Management and Remediation Planning

Analyze the client impact for each exception found primarily using SQL, and develop SQL based remediation scripts to resolve current and historical issues.

System Optimization

Work alongside our tech and client service teams to resolve recurring data issues and help automate manual workarounds.

Reporting

Clearly articulate current data status, open tickets causing issues, remediation plans for resolving issues, and client impact analysis. Host regular cross functional stakeholder meetings to communicate status, and receive input on prioritization.

Onboarding Support

Assist in mapping and migrating historical data for new RIA clients.

Technical Skills & Experience

• Deep knowledge of Portfolio Accounting including cost basis accounting, fixed income accruals and adjustments, options processing, cash and margin processing
• Experience with reconciling custodial data to portfolio management systems
• Experience with Portfolio Management Performance Operations
• Experience with Portfolio Management Billing Operations
• Experience with SQL
• Experience with Jenkins
• Experience with operational support and application support
• Experience with ETL tooling, or the equivalent

Desired Skills & Experience

• Experience working with Jira and Confluence
• Strong familiarity with best practices around logging, monitoring, and self-healing applications
• Experience working with Jenkins for ETL processes
• Experience working with Redash for Data Visualization