Portfolio Data Integrity & 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

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Portfolio Data Ops & Reconciliation Lead
Portfolio Data Ops & Reconciliation Lead

AdvisorEngine • Raleigh (NC)

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

AdvisorEngine • Raleigh (NC)

On-site
USD 90,000 - 120,000
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 Ops Specialist - Data Quality & Support
Portfolio Data Ops Specialist - Data Quality & Support

Addepar • United States

Remote
USD 35,000 - 42,000
Remote Portfolio Operations & Data Integrity Specialist
Remote Portfolio Operations & Data Integrity Specialist

Mercer Advisors Inc. • United States

Remote
USD 34,000 - 40,000
Medical
Dental
Vision
+2
Investment Operations & Data Specialist
Investment Operations & Data Specialist

Western & Southern • Cincinnati (OH)

On-site
USD 70,000 - 90,000
Portfolio Data Operations Analyst
Portfolio Data Operations Analyst

Addepar, Inc. • Town of Poland (NY)

On-site
USD 70,000 - 90,000
Portfolio Data Operations Specialist
Portfolio Data Operations Specialist

Addepar, Inc. • Town of Poland (NY)

On-site
USD 70,000 - 90,000
Remote Wealth Ops Analyst: Performance Reporting & Data Integrity
Remote Wealth Ops Analyst: Performance Reporting & Data Integrity

Aprio • Chicago (IL), Atlanta (GA), Overland Park (KS)

Hybrid
USD 65,000 - 90,000
Medical, Dental, and Vision Insurance
401k with Profit Sharing
Parental Leave
+1
Financial Operations Analyst – Reconciliation & Support
Financial Operations Analyst – Reconciliation & Support

SEI • Upper Providence Township (PA)

On-site
USD 52,000 - 76,000
Healthcare benefits
401(k) match
Paid time off
+2