Job DescriptionAres 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.
This role is well-suited for a detail-oriented professional interested in investment operations, insurance asset management, data governance, and cross-functional problem-solving.
Responsibilities: Asset Data Management and Reconciliation- 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.
Cross-Functional Coordination- Serve as a key liaison between Asset Analytics, Investment Operations, Finance, Accounting, Actuarial, and Technology teams.
- Communicate data anomalies, reconciliation findings, business requirements, and remediation priorities to stakeholders across functions.
- Coordinate exception resolution efforts from identification through testing, validation, and closure.
- Participate in user acceptance testing (UAT) for system enhancements, data feeds, platform upgrades, and process changes.
- Maintain documentation of data definitions, business requirements, reconciliation procedures, exception management workflows, and operating controls.
FP&A and Projection Support- Prepare, validate, and reconcile asset-related inputs used in FP&A forecasts, planning exercises, and financial projection models.
- Ensure completeness and accuracy of portfolio attributes, asset cash flows, yields, spreads, ratings, durations, reinvestment assumptions, and other modeling inputs.
- Support periodic forecasting and planning processes by providing timely and accurate data extracts and validation checks.
- Assist in executing asset-side projection tools and perform reasonability reviews of outputs.
- Investigate and resolve data anomalies, exceptions, or inconsistencies that may impact model inputs, assumptions, or projection results.
Process Improvement and Data Governance- Identify opportunities to improve reconciliation processes, data controls, and operational efficiency.
- Support initiatives to strengthen data governance and improve data lineage, transparency, and consistency across systems.
- Assist with the development of automated data validation and reconciliation processes where appropriate.
- Contribute to the establishment of best practices for investment data management and operational controls.
Qualifications:Education- Bachelor's degree in Finance, Accounting, Economics, Mathematics, Statistics, Data Analytics, Information Systems, Engineering, Actuarial Science, or a related field.
Experience- 1-4 years of experience in investment operations, data management, accounting, financial services, insurance, asset management, or a related field.
- Experience working with financial data, reconciliations, operational controls, or data quality processes preferred.
- Exposure to life insurance, annuities, investment accounting, investment operations, or asset management is a plus.
Technical Skills- 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.
- Ability to analyze large datasets and investigate data discrepancies across multiple systems.
- Familiarity with investment accounting concepts and investment data structures is preferred.
Professional Competencies- Strong analytical and problem-solving skills.
- Exceptional attention to detail and commitment to data accuracy.
- Ability to independently investigate complex data anomalies and determine root causes.
- Strong organizational skills and ability to manage multiple priorities simultaneously.
- Effective communication and stakeholder management skills.
- Ability to work collaboratively across business, operations, finance, actuarial, and technology teams.
- Continuous improvement mindset with a focus on operational excellence and control effectiveness.
Preferred Qualifications:- Familiarity with fixed income, structured products, private credit, or insurance investment portfolios.
- Understanding of investment accounting platforms, custodial data, security master data, and investment operations workflows.
- Experience supporting financial projections, planning processes, or actuarial and finance data requirements.
- Progress toward a professional designation in accounting, actuarial science, finance, or a related field is a plus, but not required.
Success in this Role:A successful candidate will:
- Ensure the integrity and reliability of asset data across critical investment, finance, and actuarial systems.
- Consistently identify, investigate, and resolve reconciliation breaks, data anomalies, and data quality exceptions in a timely manner.
- Serve as a trusted partner across Operations, Accounting, Finance, Actuarial, Technology, and Asset Analytics teams.
- Deliver accurate and well-controlled asset data inputs for forecasting and projection processes.
- Contribute to a stronger data governance framework and a more scalable investment data operating model.
Reporting RelationshipsHead of Risk, ALM & Capital Management, Ares Insurance Solutions
CompensationThe anticipated base salary range for this position is listed below. Total compensation may also include a discretionary performance-based bonus. Note, the range takes into account a broad spectrum of qualifications, including, but not limited to, years of relevant work experience, education, and other relevant qualifications specific to the role.
$95,000 - $110,000
The firm also offers robust Benefits offerings. Ares U.S. Core Benefits include Comprehensive Medical/Rx, Dental and Vision plans; 401(k) program with company match; Flexible Savings Accounts (FSA); Healthcare Savings Accounts (HSA) with company contribution; Basic and Voluntary Life Insurance; Long-Term Disability (LTD) and Short-Term Disability (STD) insurance; Employee Assistance Program (EAP), and Commuter Benefits plan for parking and transit.
Ares offers a number of additional benefits including access to a world-class medical advisory team, a mental health app that includes coaching, therapy and psychiatry, a mindfulness and wellbeing app, financial wellness benefit that includes access to a financial advisor, new parent leave, reproductive and adoption assistance, emergency backup care, matching gift program, education sponsorship program, and much more.
There is no set deadline to apply for this job opportunity. Applications will be accepted on an ongoing basis until the search is no longer active.
