Analyst, Risk, Analytics and Reporting, AIS
OnsiteIndividual AnnuitiesIndividual Life ProtectionLife Annuity OtherAsset-Liability ManagementRegulatory ReportingBusiness Intelligence & Reporting
Role Summary
Loading...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
