Portfolio Management Data Operations & Reconciliation Specialist

AdvisorEngine

Raleigh (NC)

On-site

USD 90,000 - 120,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

AdvisorEngine is seeking a meticulous Data Operations & Reconciliation Specialist to own daily portfolio and performance data integrity. You will ensure custodial data flows into our portfolio accounting systems, validate performance and billing calculations, and partner across departments to resolve issues with AE standards in mind.

The role requires deep experience in reconciliations, performance operations, billing, and data troubleshooting, using SQL and ETL tooling to build remediation

Qualifications

  • 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, including UMA and Sleeve performance.
  • Experience with Portfolio Management Billing Operations.
  • Experience with SQL, Jenkins, ETL tooling, or the equivalent.
  • Some experience with Client engagement for data requirements exploration.

Responsibilities

  • Daily Batch Data Reconciliation: Reconcile daily cash, position, market value, and transaction data between custodial feeds and AE system.
  • Performance Auditing: Audit returns to identify anomalies and provide root cause analysis.
  • Fee Billing & Revenue Operations: Review monthly/quarterly advisory fee billing and reconcile fee schedules.
  • Fixed Income Operations: Reconcile daily accrual calculations and income projections.
  • Data Foundation & Troubleshooting: Resolve data issues affecting performance and billing.
  • Exception Management: Analyze client impact and develop SQL remediation scripts.
  • System Optimization: Collaborate with tech and client service to reduce recurring data issues.
  • Reporting: Communicate data status and remediation plans in stakeholder meetings.
  • Onboarding Support: Assist in migrating historical data for new clients.

Skills

Portfolio accounting
Cost basis
Fixed income accruals
Options processing
Cash processing
Margin processing
Custodial data reconciliation
Performance operations
Billing operations
SQL
Jenkins
ETL tooling
Data troubleshooting
Client engagement

Tools

SQL
Jenkins
ETL tooling
Redash

Job description

We believe that the future of financial advice is personal, scientific and beautiful – these three ideals drive everything that we do.

AdvisorEngine technology creates a unified experience across financial advisors, clients, and business management personnel. While our journey is in the early phases, we’ve already started turning our vision into reality. We have already delivered a wealth management platform that enables financial advisors to deliver an engaging personalized client experience to drive growth and to operate at scale through smart automation.

Our team is made up of designers, enterprise technologists, data scientists, futurists, and business builders. If you are driven to create the future of financial advice, we’d love to hear from you.

About the Role

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.

Overall 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. Validating UMA and Sleeve performance.
  • 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, including UMA and Sleeve performance
  • 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
Desired Skills & Experience:
  • 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
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Portfolio Management Data Operations & Reconciliation Specialist (Contract)
Portfolio Management Data Operations & Reconciliation Specialist (Contract)

AdvisorEngine • Raleigh (NC)

On-site
USD 70,000 - 100,000
Portfolio Data Integrity & Reconciliation Specialist
Portfolio Data Integrity & Reconciliation Specialist

AdvisorEngine • Raleigh (NC)

On-site
USD 90,000 - 120,000
Portfolio Data Ops & Reconciliation Lead
Portfolio Data Ops & Reconciliation Lead

AdvisorEngine • Raleigh (NC)

On-site
USD 70,000 - 100,000
Senior DevOps Engineer
Senior DevOps Engineer

AdvisorEngine • Raleigh (NC)

Hybrid
USD 90,000 - 120,000
Financial Systems Engineer - Hedge Funds, PE & VC Funds
Financial Systems Engineer - Hedge Funds, PE & VC Funds

Junonia Partners • Dallas (TX)

On-site
USD 120,000 - 170,000
Portfolio Data Operations Analyst
Portfolio Data Operations Analyst

Addepar, Inc. • Town of Poland (NY)

On-site
USD 70,000 - 90,000
Investment Data Platform Lead
Investment Data Platform Lead

Sage Advisory • Austin (TX)

Hybrid
USD 150,000 - 190,000
Data Analyst
Data Analyst

Summit Financial • Parsippany-Troy Hills (NJ)

On-site
USD 70,000 - 110,000
Investment Reporting Associate
Investment Reporting Associate

EARNEST Partners LLC • Atlanta (GA)

On-site
USD 90,000 - 140,000
Annual bonus
Comprehensive benefits
Operations Associate
Operations Associate

The Mather Group, LLC • Chicago (IL)

On-site
USD 50,000 - 70,000