Role Summary

HIGHLIGHTS

Analyst role on Ares Insurance Solutions (AIS) supporting ALM, financial planning, and analytics for Ares' life and annuity platform in New York. You will maintain Excel/Python models, standardize investment and liability data, support regulatory and accounting inputs, and prepare reporting for senior management. Strong bond math, Excel/VBA skills and familiarity with Python/SQL are emphasized.

JOB DESCRIPTION SUMMARY

Support ALM, cashflow projections and investment-liability analytics for a life and annuity platform
Maintain and enhance in-house Excel and Python models (pandas/numpy) and automate processes
Standardize and reconcile investment and transaction data across entities and jurisdictions
Prepare monthly/quarterly reports and summaries for senior management
Based in New York (AIS team); entry-level Analyst position

DOMAIN EXPERTISE

bond mathematics (duration, convexity, OAS, z-spread, spread duration)
advanced Excel/VBA modelling and automation
model validation and analytics in Python (pandas/numpy)
asset-liability management and cashflow projections
investment accounting / transaction data reconciliation

KEY REQUIREMENTS

Advanced Excel and VBA skills required, including automation
Strong bond mathematics knowledge (duration, convexity, OAS, z‑spread) required
Demonstrated experience building models in Excel and Python
Familiarity with Python (pandas, numpy) and SQL/Git preferred

TECH STACK

Excel
PowerPoint
Git_GitHub
Jupyter_Notebook

Role Summary

HIGHLIGHTS

JOB DESCRIPTION SUMMARY

Support ALM, cashflow projections and investment-liability analytics for a life and annuity platform
Maintain and enhance in-house Excel and Python models (pandas/numpy) and automate processes
Standardize and reconcile investment and transaction data across entities and jurisdictions
Prepare monthly/quarterly reports and summaries for senior management
Based in New York (AIS team); entry-level Analyst position