Portfolio Management Data Operations & Reconciliation Specialist (Contract)

Posted Yesterday
Be an Early Applicant
Raleigh, NC, USA
In-Office
Entry level
Fintech
The Role
Own daily portfolio and performance data integrity by reconciling custodial feeds, accounting records, transactions, positions, fees, fixed-income calculations, and performance returns. Investigate exceptions, pricing anomalies, data issues, and billing discrepancies using SQL and develop remediation scripts. Support data migrations, troubleshoot recurring issues, improve operational workflows, and communicate client impact, remediation plans, and status to cross-functional stakeholders.
Summary Generated by Built In

About AdvisorEngine

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. We are based in Raleigh, NC. 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

Skills Required

  • Deep knowledge of portfolio accounting, including cost basis accounting, fixed-income accruals and adjustments, options processing, cash processing, and margin processing
  • Experience 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 equivalent
  • Some experience engaging clients to explore data requirements
  • Strong analytical ability to debug complex data issues using system debugging tools
  • Ability to quickly understand complex concepts, large architectures, and sophisticated designs
  • Ability to provide tactical and long-term strategic solutions and identify associated risks
  • Experience with Jira and Confluence
  • Experience in financial services or the brokerage industry
  • Familiarity with logging, monitoring, and self-healing application best practices
  • Experience using Jenkins for ETL processes
  • Experience with Redash for data visualization
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York, NY
64 Employees
Year Founded: 2014

What We Do

AdvisorEngine is a digital platform to supercharge advisor growth. A pioneer in digital wealth management technology, AdvisorEngine was the first company to integrate private-label robo-advice within a full enterprise B2B digital wealth management technology platform. Built from the beginning specifically for financial advisors, AdvisorEngine enables advisors to serve traditional wealth management clients and fully digital clients entirely from a single platform. From online account opening and report automation to comprehensive API platforms—and everything in between—AdvisorEngine provides the tools advisors need to scale more efficiently and compete more effectively.

Similar Jobs

Grainger Logo Grainger

Account Manager

eCommerce • Information Technology • Retail • Industrial
Hybrid
Raleigh, NC, USA
26000 Employees
62K-104K Annually

SoFi Logo SoFi

Senior Manager, Compliance Marketing

Fintech • Mobile • Software • Financial Services
Easy Apply
Remote or Hybrid
United States
4500 Employees
131K-226K Annually

PNC Bank Logo PNC Bank

Product Manager

Machine Learning • Payments • Security • Software • Financial Services
Hybrid
Charlotte, NC, USA
55000 Employees
65K-145K Annually

PNC Bank Logo PNC Bank

Data Scientist

Machine Learning • Payments • Security • Software • Financial Services
Hybrid
Charlotte, NC, USA
55000 Employees
86K-173K Annually

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Artificial Intelligence • Fintech • Software
New York, New York
9 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
85 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account