Underwriter Assistant/Data Analyst

*pay is commensurate with experience*

Summary:

SPEAR Specialty’s Excess Casualty is seeking a motivated candidate to work in growing a diverse suite of Excess Casualty Products. They will be responsible for supporting and managing workflows between Underwriting and Operations. The successful candidate will handle the life cycle of an account, including new business, renewals, and servicing of business.

Essential Duties and Responsibilities:

· Handle extensive volumes of data using spreadsheets, graphs, data tables, calculations, and automation to generate desired outcomes.

· Create and/or work with spreadsheet formulas, which will allow for tackling sophisticated problems and achieving advanced data manipulation with confidence.

· Support all steps of the underwriting process in conjunction with the underwriting operations function.

· Liaise with Underwriters, Brokers, and Reinsurers as needed to communicate account status and complete outstanding subjectivities.

· Liaise with Underwriters to confirm policy issuance instructions for policies, endorsements, forms, notices, certificates, etc., and effectively complete coding/issuance.

· Assist with new and renewal business life cycle work such as submission preparation, rating, referral prep, quoting, and binding all the way through to policy issuance and endorsements within assigned authority.

· Work with internal operations partners to ensure that service standards are being met.

· Ensuring all parts of the Underwriting workflow are completed both accurately and on time.

· Assist underwriters in processing new business submissions and rating sheets.

· Assists with onboarding of new hires and/or acts as a mentor for colleagues.

· Other duties, tasks, and projects as assigned.

Education and Experience:

· Associate’s or Bachelor’s degree in Mathematics, Actuarial or Data Science, Statistics, or related field (preferred).

· Experience in the insurance industry (preferred).

· Highly proficient – i.e. Intermediate high or close to Advanced level – in Microsoft Office suite.

· Advanced Excel knowledge and skills.

· *Please see page 2 for more details on this required experience.

· Demonstrated experience working with extensive volumes of data.

Key Competencies:

· Strong attention to detail and accuracy in managing high amount of paperwork, data, and records.

· Excellent communication and interpersonal skills for interacting with clients and colleagues.

· Must be positive, self-motivated, and possess strong interpersonal and communication skills.

· Highly customer-centric both internally and externally.

· Strong problem-solving and decision-making abilities.

· Ability to work independently with minimal supervision.

· Strong collaborative skills in a fast-paced team-centric environment.

· Must be able to work a Hybrid working model.

Job Type: Full-time, 40 hours a week.

Schedule: 8:15am – 5:00pm, Monday – Friday.

Location: Fairview Park, OH.

Work Status: Hybrid.

Benefits:

· 401(k) matching.

· Dental insurance.

· Health insurance: Includes Vision Savings Pass.

· Voluntary additional benefits: Life insurance, short-term disability, and long-term disability.

· 7 paid holidays (8 days off in total).

· Paid time off.

*Note – Clarification on advanced Excel skills:

· Advanced Excel skills refer to a specialized and sophisticated level of proficiency that surpasses the basic knowledge of Excel formulas and features.

· Individuals with Advanced Excel skills possess a breadth of knowledge and expertise that enables them to perform complex data analysis, create dynamic reports, automate tasks, and handle large datasets efficiently.

· These skills are vital in sectors that rely heavily on data-driven decision-making, such as insurance, financial services, data analysis, and market research.

· Examples of Advanced Excel skills include:

· Applying advanced formulas, e.g. INDEX MATCH, OFFSET, and SUMPRODUCT.

· Building a PivotTable to extract insights from data.

· Effective use of the AutoFilter feature.

· Record and edit macros.

· Advanced skills include Intermediate Excel skills involving a deeper understanding of Excel’s features and functionalities, allowing the candidate to effectively use Excel’s functions and ensures accurate data analysis and manipulation.

· Examples of Intermediate Excel skills include:

· Advanced formulas and functions, e.g. VLOOKUP.

· Creating charts and graphs.

· Data tables and what-if analysis.

· Making use of the Formula tab and Functions library.

· Using formulas to manipulate basic data.

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Vision insurance

Application Question(s):

• What are your salary requirements?

Experience:

• Data analysis skills: 1 year (Preferred)

Work Location: Hybrid remote in Cleveland, OH 44126