Institutional Reporting Specialist

Jobtailor; Arizona; On-site; USD 85,000 - 120,000; Full time

Job summary

Jobtailor in the United States is seeking a senior portfolio accounting professional to compile monthly and quarterly performance reports, reconcile discrepancies, and self‑audit data for accuracy.

You will leverage SQL, Python, and Excel VBA to automate processes, reconcile investment transactions, and collaborate with researchers, traders, operations, and custodians to ensure precise client reporting.

Qualifications

• 3+ years portfolio accounting or investment reporting experience serving institutional and ultra‑high net worth clients.
• Firm understanding of portfolio management concepts including modern portfolio theory, asset allocation, portfolio construction, manager selection, risk management, and performance attribution.
• Experience with Addepar, Investment Metrics, or other investment reporting platforms a plus.
• Technical background with strong analytical and quantitative skills; proficient in SQL, Python, or Excel VBA a plus.
• Undergraduate degree in accounting, finance, economics, data, or related field.

Responsibilities

• Compile and generate monthly and quarterly performance reports, reconcile performance discrepancies, and ensure accuracy of data through self‑audit.
• Manually capture and reconcile alternative investment transactions and valuations into designated systems and spreadsheets.
• Responsible for collecting, processing, managing, and analyzing large amounts of data and creating programs to automate processes.
• Process, review and resolve any exception items to ensure accurate reporting of client investments.
• Interface and maintain strong relationships with internal and external stakeholders including research, trading, operations, product specialists, third‑party vendors, and custodians.

Skills

SQL

Python

Excel VBA

Education

Bachelor's degree in accounting/finance/economics/data

Tools

Addepar

Investment Metrics

Job description

Responsibilities

• Compile and generate monthly and quarterly performance reports, reconcile performance discrepancies, and ensure accuracy of data through self‑audit.
• Manually capture and reconcile alternative investment transactions and valuations into designated systems and spreadsheets.
• Responsible for collecting, processing, managing, and analyzing large amounts of data and creating programs to automate processes.
• Process, review and resolve any exception items to ensure accurate reporting of client investments.
• Interface and maintain strong relationships with internal and external stakeholders including research, trading, operations, product specialists, third‑party vendors, and custodians.

Requirements

• 3+ years portfolio accounting or investment reporting experience serving institutional and ultra‑high net worth clients.
• Firm understanding of portfolio management concepts including modern portfolio theory, asset allocation, portfolio construction, manager selection, risk management, and performance attribution.
• Experience with Addepar, Investment Metrics, or other investment reporting platforms a plus.
• Technical background with strong analytical and quantitative skills; proficient in SQL, Python, or Excel VBA a plus.
• Undergraduate degree in accounting, finance, economics, data, or related field.