What are the responsibilities and job description for the Portfolio Administrator position at Sterling Capital Management LLC?
Job Statement
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.
Compensation
- Commensurate with experience