Allshores is looking for an insurance-focused Actuarial Data Analyst to support the Actuarial team's growing need for data extraction, analysis, reporting, and business insights across Life, Health, and P&C insurance operations. This role will serve as a bridge between actuarial expertise and data analytics by helping the team efficiently access, organize, analyze, and interpret large and complex datasets.
Working closely with actuaries and business stakeholders, the successful candidate will leverage SQL, Power BI, Excel, and other analytical tools to support valuation activities, experience studies, claims trend analysis, capital reporting, model governance, and strategic decision-making. This role will help enhance the team's ability to transform data into actionable business insights.
Primary Responsibilities:
- Partner with actuarial and business stakeholders to understand business questions and translate them into data, reporting, analytical requirements and actionable insights.
- Extract, prepare, reconcile, and analyze large and complex datasets from multiple internal and external sources to support actuarial and business initiatives.
- Develop and maintain SQL queries, reports, dashboards, and analytical tools to support decision-making across Life, Health, and P&C operations.
- Support valuation activities, experience studies, claims trend analysis, capital reporting, and other actuarial functions through data preparation and analysis.
- Perform exploratory data analysis to identify trends, patterns, anomalies, risks, and opportunities within insurance and claims data.
- Assist in the development, maintenance, testing, and documentation of actuarial models and related analytical processes.
- Support model governance activities, including documentation, validation support, data controls, and compliance with regulatory and internal requirements.
- Create visualizations, dashboards, and reporting packages that effectively communicate findings to technical and non-technical audiences.
- Monitor and improve data quality through validation, reconciliation, and continuous improvement processes.
- Identify opportunities to automate manual reporting and analytical processes to improve efficiency and scalability.
- Work closely with Technology, Finance, Operations, and other stakeholders to improve access to data and reporting capabilities.
- Document data sources, business rules, methodologies, and reporting processes to support governance and knowledge sharing.
- Stay current on data analytics tools, techniques, and industry best practices to continually enhance team capabilities.
Skills, Experience & Attributes:
- Bachelor's degree in Data Analytics, Statistics, Mathematics, Computer Science, Actuarial Science, Economics, Business Analytics, or a related quantitative discipline.
- 5+ years of experience in data analytics, business intelligence, reporting, or a similar analytical role.
- Strong SQL skills with experience querying, extracting, and analyzing large and complex datasets.
- Experience developing reports, dashboards, and visualizations using tools such as Power BI, Tableau, or similar reporting platforms.
- Advanced Excel skills, including data analysis, validation, and reporting.
- Experience working with data extraction, transformation, validation, reconciliation, and quality assurance processes.
- Familiarity with Python, R, or other analytical tools is considered an asset.
- Knowledge of insurance, actuarial concepts, financial services, health claims, or other regulated industries is considered an asset.
- Experience supporting business reporting, analytics, operational decision-making, or data governance initiatives.
- Strong quantitative, analytical, and problem-solving skills, with a high degree of attention to detail and accuracy.
- Strong verbal and written communication skills, with the ability to present technical findings to non-technical audiences.
- Self-motivated, curious, and collaborative, with the ability to manage multiple priorities and identify opportunities for process improvement and automation.