Analyst - Data Operations - Ares Insurance Solutions - AIS

## Job Description Ares Insurance Solutions (AIS) is seeking an Analyst to support the Asset Analytics and Data Operations function responsible for investment portfolios backing life and annuity insurance liabilities. This role will focus on maintaining the quality, accuracy, and completeness of investment data used across investment management, actuarial, finance, and forecasting processes. The Analyst will play a key role in identifying, investigating, and resolving data anomalies, reconciliation exceptions, and data discrepancies across multiple investment systems and data sources, helping ensure the integrity and reliability of investment data used across the organization. Working closely with Asset Analytics, Investment Operations, Finance, Accounting, and Technology teams, the Analyst will support critical data governance and operational processes. The individual will also assist with the preparation and validation of asset-related inputs for FP&A and projection models and may support the execution of forecasting tools and processes. ## Responsibilities: - Monitor the quality, accuracy, and completeness of investment data across various asset classes, including public fixed income, structured products, private credit, mortgages, and alternative investments. - Perform daily, monthly, and quarter-end reconciliations across investment accounting systems, portfolio management platforms, custodians, data warehouses, and analytical applications. - Investigate and resolve reconciliation breaks involving positions, market values, book values, cash balances, accrued interest, investment income, ratings, security master attributes, and cash flows. - Analyze data anomalies and reconciliation exceptions across multiple sources and determine root causes, whether related to source feeds, accounting treatment, data transformations, system configurations, timing differences, or operational processes. - Partner with Investment Operations, Accounting, Technology, and external service providers to investigate and resolve data anomalies and reconciliation exceptions and validate remediation efforts. - Maintain reconciliation inventories, exception logs, and support documentation to ensure transparency and auditability of the resolution process. - Ensure data consistency across upstream and downstream systems supporting investment management, actuarial modeling, FP&A, regulatory reporting, and management reporting. - Assist in establishing and enhancing data quality controls, exception monitoring, and operational workflows to proactively identify anomalies before they impact business processes. - Support data validation efforts related to new security onboarding, portfolio transfers, acquisitions, system implementations, and data migration projects. ## Qualifications: - Bachelor's degree in Finance, Accounting, Economics, Mathematics, Statistics, Data Analytics, Information Systems, Engineering, Actuarial Science, or a related field. - 1–4 years of experience in investment operations, data management, accounting, financial services, insurance, asset management, or a related field. - Advanced proficiency in Microsoft Excel. - Working knowledge of SQL and database querying concepts. - Experience with Python, Power BI, Alteryx, or other data analysis and automation tools is a plus.