Actuarial Data Analyst, Captives

This is an opportunity to join Ascot Group - one of the world’s preeminent specialty risk underwriting organizations.

Designed as a modern-era company operating through an ecosystem of interconnected global operating platforms, we’re bound by a common mission and purpose: One Ascot. Our greatest strength is a talented team who flourish in a collaborative, inclusive, and entrepreneurial culture, steeped in underwriting excellence, integrity, and a passion to find a better way, The Ascot Way.

The Ascot Way guides our people and our organization. Our underwriting platforms collaborate to find creative ways to deploy our capital in a true cross-product and cross-platform approach. These platforms work as one, deploying our capital creatively through our unique Fusion Model: Client Centric, Risk Centric, Technology Centric.

Built to be resilient, Ascot maximizes client financial security while delivering bespoke products and world class service — both pre- and post-claims. Ascot exists to solve for our clients’ brightest tomorrow, through agility, collaboration, resilience, and discipline.

Ascot is embedding artificial intelligence (AI) and automation across the organisation to enhance decision‑making, efficiency, and quality of outcomes. In this role, you will be expected to work confidently alongside AI‑enabled tools, apply sound judgment when interpreting insights, and adapt as technology continues to evolve. We value curiosity, critical thinking, and a willingness to embrace change as part of how we work.

Position Overview:

As part of Ascot’s Actuarial business unit, the Actuarial Data Analyst, Captives will work on critical “run the business” core services such as data manipulation and querying, template creation, tool support, and business intelligence (reporting). You will support the Portfolio and Alternative Risk Transfer actuarial group that is responsible for pricing captives and insurance programs. You will be responsible for building data pipelines, running, and maintaining scripts. You will also assist the actuarial team in building out reports that highlight our Pricing KPIs, empower the team to work efficiently with large data sets, and where applicable leverage third party data. You will be joining a team of experienced actuaries that have tackled these problems in similar environments and have established best practices. This role will work in the office on a hybrid (at least 3 times per week) work schedule.

Responsibilities: 

• Ensure data capture from various pricing tools are stored in our data warehouse 

• Use R, Python, and SQL to build data pipelines and reports to monitor portfolio health

• Normalize data for consistency to the data warehouse and collaborate with other functional areas to improve data quality and consistency

• Manage database interactions to create robust exhibits and corresponding visualizations

• Work with actuarial partners in building analytical tools to support underwriters

• Assist with ad hoc projects as needed and contribute to a collaborative, high‑performing culture aligned with The Ascot Way

Requirements:

• Strong experience in multiple languages: SQL, VBA, R, and Python

• Experience building Data Visualization reports in PowerBI or Tableau a plus

• Bachelor’s degree with strong academic performance

• Insurance industry experience is preferred, but not required

• A minimum of 2 years of experience as a data analyst and/or strong data skills achieved as part of an Insurance, IT, Finance, Data, or Math curriculum

• Excel experience in an analytical environment. Prior work experience preferred but not required.

• Strong attention to detail and verifying data, maintaining high levels of accuracy. 

• Respect and manage deadlines

• Highly customer-centric both internally and externally

• Strong collaborative skills in a fast-paced team-centric environment

***This position may be filled at a different level, depending on experience***

Company Benefits:

The Company provides a competitive benefits package that includes the following (eligibility requirements apply): 

• Health and Welfare Benefits: Medical (including prescription coverage), Dental, Vision, Health Savings Account, Commuter Account, Health Care and Dependent Care Flexible Spending Accounts, Life Insurance, AD&D, Work/Life Resources (including Employee Assistance Program), and more 
• Leave Benefits: Paid holidays, annual Paid Time Off (includes paid state /local paid leave where required), Short-term Disability, Long-term Disability, Other leaves (e.g., Bereavement, FMLA, Adoption, Maternity, Military, Primary & Non-Primary Caregiver) 
• Retirement Benefits: Contributory Savings Plan (401k)

#LI-Hybrid

#LI-MR1