Portfolio Management Data Operations & Reconciliation Specialist (Contract)

AdvisorEngine•Raleigh, NC

About The Position

We are looking for a meticulous Data Operations & Reconciliation Specialist to own our daily portfolio and performance data integrity. In this role, you will be the final line of defense ensuring that custodial data flows seamlessly into our portfolio accounting systems, and performance and billing calculations are accurate. If you actually enjoy hunting down a missing penny in a multi-million-dollar cash reconciliation, this is the role for you. This role works with multiple departments to ensure the timely resolution of client and product issues while maintaining established procedures for an elevated level of service and data quality in line with AdvisorEngine (AE) standards.

Requirements

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
Some experience with Client engagement for data requirements exploration
Strong analytical ability to quickly debug complex data issues with a variety of system debugging tools
Ability to grasp difficult concepts, large architectures, and sophisticated designs quickly
Ability to provide short tactical and long-term strategic solutions and provide the risks associated with each

Nice To Haves

Experience working with Jira and Confluence
Experience with financial services or brokerage industry
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

Responsibilities

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume