Portfolio Administrator

Sterling Capital Management LLC; Charlotte (NC); Hybrid; USD 70,000 - 90,000; Full time

Job summary

A financial services firm headquartered in Charlotte, NC seeks a hybrid Portfolio Administrator/Regulatory Reporting Associate. The successful candidate will handle portfolio accounting and reconciliations while assisting regulatory reporting. Key qualifications include a Bachelor's degree in accounting/finance and 5+ years in Asset Management, with strong proficiency in Excel and knowledge of portfolio accounting systems like Advent. This role requires excellent communication and problem-solving skills.

Qualifications

• 5+ years of back/middle office financial work experience in Asset Management.
• Direct experience with a portfolio accounting system.
• Strong Excel skills including vlookups, pivot tables, macros.

Responsibilities

• Ensure transaction/position integrity in records against client custodial records.
• Manage operational aspects of new account onboarding.
• Prepare monthly and quarterly regulatory reports.

Skills

Excellent math and problem-solving skills

Strong customer service approach

Technical understanding of investment markets

Proficiency in software packages like Bloomberg and Excel

Ability to analyze data operations workflows

Education

Bachelor’s degree in accounting, finance, or relevant field

Tools

Advent APX

Charles River

Bloomberg

Excel

Job description

Sterling Capital Management LLC (Sterling), headquartered in Charlotte, North Carolina, is a registered investment adviser founded in 1970.

Sterling Capital Management is looking to fill a hybrid role that is part Portfolio Administrator and part Regulatory Reporting Associate. The role will perform portfolio accounting, reconciliation, and reporting (at a 75% workload) while also assisting with capturing, organizing and reporting on various facets of regulatory reporting data. A successful Portfolio Administrator combines excellent math and problem solving skills, a sound proficiency with technology (from Outlook and Excel to Bloomberg, Advent, and Charles River), and a strong customer service approach. A successful Regulatory Reporting Associate will have relevant experience with various regulatory frameworks for investment advisors, excellent data organization skills, strong time management/project management, and a high degree of precision.

Essential Duties and Responsibilities

• Ensure transaction/position integrity in Sterling’s records (Advent APX) against client custodial records, and also to Sterling’s OMS (Charles River) and relevant reference data (Bloomberg, etc.).
• Research and remediate reconciliation discrepancies daily. Requires close and frequent communication (email and phone) with counterparts at custodial banks and internal settlement team.
• Prepare and distribute all month-end accounting and performance statements, per client specific instructions, for assigned client list during first 7 business days after month end.
• Manage operational aspects of new account onboarding, including set up of account attributes in portfolio accounting system, data feed connectivity to custodian, and verifying funding status.
• Oversee necessary steps for other operational activities over an account lifecycle, such as contributions/withdrawals, audit requests, and account terminations.
• Provide internal "customer" support, quickly responding to a high volume of time sensitive questions and requests from multiple internal teams.
• Assist with providing data and supporting the compilation of Form ADV.
• Prepare and submit regulatory reports, including Form 13 D.G.F. and Treasury Reports, on a monthly/quarterly basis.
• Ensure data accuracy for SOC 1 reporting, including support for population testing.
• Participate in internal audit activities as needed.

Required Qualifications

• Bachelor’s degree. Preferably in accounting, finance, or relevant field.
• Five+ years of back/middle office financial work experience, preferably within Asset Management.
• Technical understanding of investment markets, securities, security data, and investment systems.
• Direct experience with a portfolio accounting system, preferably an Advent system.
• Direct experience with regulatory and compliance requirements within an investment advisor.
• Excellent overall computer skills with demonstrated proficiency in several software packages. Familiarity with Bloomberg, Charles River, Factset and Salesforce preferred.
• Strong ability in Microsoft Excel, including vlookups, pivot tables and macros. SQL, Python, R, Power BI, and/or Tableau skills are a plus.
• Analyze existing data operations workflows and identify opportunities for automation, efficiency improvements, and risk mitigation.
• Implement process improvements and best practices to streamline data acquisition, processing, and distribution.