Actuarial Data Analyst

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.

Job Summary:

As part of Ascot’s Actuarial business unit, the Actuarial Data Analyst will work on critical “run the business” core services such as data manipulation and querying, template creation, tool support, and business intelligence (reporting). The Actuarial Data Analyst will be responsible for running and maintaining reports centered around Profitability Studies. They 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. 

Responsibilities:

• Use R, Python, and SQL to build data pipelines and reports to monitor portfolio health
• Manage database interactions to create robust exhibits and corresponding visualizations
• Work with actuarial partners in building analytical tools to support underwriters
• Collaborate with other functional areas to improve data quality and consistency
• Leverage sample prototype reports to build out more robust reports in production
• Assist with additional ad hoc projects as required.

Requirements:

• Bachelor’s degree with strong academic performance
• 1-2 years data analyst experience and/or strong data skills achieved as part of an Insurance, IT, Finance, Data, or Math curriculum
• Experience coding in SQL, and R/Python
• Experience using/building Oracle databases a plus
• Excel experience in an analytical environment. Prior work experience preferred but not required.
• Experience building Data Visualization reports in PowerBI or Tableau a plus
• Insurance industry experience is 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***

Compensation

Actual base pay could vary and may be above or below the listed range based on factors including but not limited to experience, subject matter expertise, and skills. The base pay is just one component of Ascot’s total compensation package for employees. Other rewards may include annual cash bonus, and other forms of discretionary compensation awarded by the Company. 

• The annualized base pay range for this role is: In New York Metro is: $80,000 - $90,000.

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