Portfolio Data Ops & Reconciliation Lead

AdvisorEngine

Raleigh (NC)

On-site

USD 70,000 - 100,000

Full time

14 days+

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, Inc. seeks a meticulous Data Operations & Reconciliation Specialist to own daily portfolio and performance data integrity.

You will be the final line of defense ensuring custodial data flows into our portfolio accounting systems and that performance and billing calculations are accurate. In this role you will collaborate with multiple departments to resolve client and product issues while maintaining AE standards, performing reconciliations, audits, and remediation efforts as part

Qualifications

  • Bachelor’s degree not specified; relevant experience required.
  • Experience reconciling custodial data to portfolio systems.
  • Strong SQL and data analysis skills.
  • Familiarity with ETL processes and data workflows.
  • Experience with financial services data and billing.
  • Ability to troubleshoot data issues and provide remediation.

Responsibilities

  • Execute daily batch data reconciliations for cash, positions, MV, and trades.
  • Audit performance across daily, monthly, and YTD periods; identify anomalies.
  • Monitor advisory fee billing and reconcile complex fee schedules.
  • Reconcile daily accruals, amortization, and income projections for fixed income.
  • Investigate data issues and mapping errors; document root causes.
  • Develop SQL-based remediation scripts for current and historical issues.
  • Collaborate with tech and client service to automate fixes.
  • Communicate status and remediation plans in cross-functional meetings.
  • Support onboarding by mapping and migrating historical data.

Skills

Portfolio accounting
Data reconciliation
SQL
Jenkins
ETL tooling
Data debugging
Performance operations
Billing operations
Analytical ability
Root cause analysis
Data troubleshooting
System optimization

Tools

Jira
Confluence
Jenkins
Redash

Job description

AdvisorEngine, Inc. seeks a meticulous Data Operations & Reconciliation Specialist to own daily portfolio and performance data integrity.

You will be the final line of defense ensuring custodial data flows into our portfolio accounting systems and that performance and billing calculations are accurate. In this role you will collaborate with multiple departments to resolve client and product issues while maintaining AE standards, performing reconciliations, audits, and remediation efforts as part

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Portfolio Data Integrity & Reconciliation Specialist
Portfolio Data Integrity & Reconciliation Specialist

AdvisorEngine • Raleigh (NC)

On-site
USD 90,000 - 120,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
Portfolio Data Operations Specialist
Portfolio Data Operations Specialist

Addepar, Inc. • Town of Poland (NY)

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
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
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
Investment Operations & Data Specialist
Investment Operations & Data Specialist

Western & Southern • Cincinnati (OH)

On-site
USD 70,000 - 90,000
Portfolio Operations Associate
Portfolio Operations Associate

Manhattancapitalsolutions • Newport Beach (CA)

On-site
USD 80,000 - 105,000