Financial Analyst III

Equiliem; Wellesley (MA); Hybrid; USD 76,000 - 90,000; Full time

Benefits offered by this job

Medical Insurance

Vision & Dental Insurance

Life Insurance

Matching 401(k)

Commuter Benefits

Employee Discounts & Rewards

Payroll Payment Options

Job summary

Equiliem is seeking a Financial Analyst III to support group reinsurance administration and stop-loss programs. The role emphasizes monthly reporting, data validation, and process improvement, with strong Excel and reinsurance knowledge.

You will work hybrid, 3 days onsite per week, with a flexible 8-hour schedule and $60/hour pay. The position requires 5–8 years in related fields, experience with reinsurance concepts, and collaboration with internal teams and external stakeholders.

Qualifications

• The candidate has 5–8 years in insurance, finance, or reinsurance administration.
• Advanced Excel, VBA, and data analysis skills are required.
• Experience with data tools and automation is encouraged.

Responsibilities

• Prepare monthly stop-loss captive reporting and accruals.
• Validate, reconcile, and troubleshoot financial data.
• Identify automation opportunities and streamline workflows.
• Collaborate with internal and external stakeholders.
• Support migration to modern data analytics platforms.
• Investigate discrepancies and recommend solutions.
• Communicate clearly with reinsurers and managers.

Skills

Advanced Excel

Data analysis

Attention to detail

Communication skills

Independent problem solving

AI/data tools awareness

Education

Bachelor's degree in Finance, Business, Actuarial Science, Mathematics, or related field

Tools

SQL

Python

R

Dataiku

VBA

Excel

Job description

Financial Analyst III

Location: Wellesley Hills, MA / Hartford, CT

Schedule/Shift: Hybrid - 3 days onsite per week; flexible 8-hour schedule

Pay:$60.00 per hour

26-10666

Job Summary

The Financial Analyst III is a senior contributor supporting group reinsurance administration and stop-loss captive programs, with responsibility for monthly reporting, data validation, and process improvement. The role requires strong reinsurance knowledge, advanced Excel skills, and the ability to interpret treaty language and apply business rules to financial reporting. During the second half of the month, the analyst will support workflow optimization, automation, documentation improvements, and data-related initiatives. The position works closely with internal business partners and external reinsurance stakeholders to ensure accurate, timely, and compliant reporting.

Job Responsibilities

• Prepare monthly stop-loss captive reporting, including internal accruals and external submissions.
• Manage assigned source files, including captive policy lists, during the first five business days of each month.
• Apply treaty requirements and business logic to validate, reconcile, and troubleshoot financial data.
• Produce submission reporting by treaty year following financial close.
• Follow established checklists, procedures, and documentation to maintain reporting accuracy and compliance.
• Review highly manual reinsurance workflows and identify opportunities for automation, streamlining, or transition to offshore operations.
• Evaluate and improve existing process documentation for clarity, accuracy, and usability.
• Use AI and data tools to support process analysis, workflow redesign, automation, and efficiency improvements.
• Support migration from legacy database processes to modern data analytics platforms.
• Identify opportunities to reduce manual effort, improve turnaround times, and strengthen operational controls.
• Collaborate with reinsurance accounting, finance, actuarial, employee benefits, stop‑loss, and other internal teams.
• Communicate clearly with reinsurers, captive managers, and other external stakeholders.
• Work independently to investigate discrepancies, identify root causes, and recommend solutions.

Job Requirements

• 5-8 years of experience in insurance, finance, actuarial, accounting, operations, reinsurance administration, or a related field.
• Experience with reinsurance operations or administration, preferably involving group, ceded, or stop‑loss reinsurance.
• Advanced Microsoft Excel proficiency, including complex formulas, large datasets, multi‑tab workbooks, pivot tables, and VBA.
• Strong ability to troubleshoot data, reporting, and system issues independently.
• Solid understanding of reinsurance concepts, including group ceded reinsurance structures such as coinsurance and YRT.
• Ability to interpret reinsurance treaties and understand the obligations and requirements of both ceding companies and reinsurers.
• Demonstrated ability to work effectively with large datasets and structured reporting materials.
• Experience using automation or AI tools to improve processes and operational efficiency.
• Familiarity with AI tools and the ability to develop effective prompts and apply AI to workflow improvement.
• Strong analytical skills with the ability to understand both detailed data and broader business drivers.
• Highly organized with exceptional attention to detail and a strong focus on accuracy.
• Confident, inquisitive, and comfortable asking questions and providing constructive process feedback.
• Ability to work independently with minimal direction.
• Strong written and verbal communication skills, including the ability to communicate clearly with internal and external stakeholders.
• Collaborative, patient, and team‑oriented approach.
• Experience with Dataiku, SQL, Python, or R is preferred.
• Experience with employee benefits products such as life, disability, health, or stop‑loss is preferred.
• Experience in medical stop‑loss, group benefits, supplemental health, or ceded reinsurance is preferred.
• Actuarial experience or an actuarial‑style analytical background is preferred.

Education

• Bachelor's degree in Finance, Business, Actuarial Science, Mathematics, or a related field.

About Equiliem

Equiliem believes in empowering success. It's our job to cultivate relationships that connect people and employers in a way that is inclusive, intelligent, and allows both to thrive.

Across the U.S., leading companies in healthcare, government, engineering, manufacturing, professional services, and energy rely on us for their workforce solutions. Our recruiting and HR services include contract and direct hire staffing, Payrolling/EOR, Independent Contractor Compliance, and Managed Services.

For almost 30 years, we've helped shape our industry. Today, we continue to research, ask questions, and continuously enhance the candidate journey and client experience.

Benefits

We offer a comprehensive benefits package to our employees, which includes:

• Medical Insurance
• Vision & Dental Insurance
• Life Insurance
• Matching 401(k)
• Commuter Benefits
• Employee Discounts & Rewards
• Payroll Payment Options

Future Communication Consent

By applying, you are providing consent for Equiliem to engage with you via phone calls, AI‑generated calls, AI‑generated text messages, standard text messages, and/or emails to share job opportunities. Consistent with our Privacy Policy, information obtained will not be shared with third parties for marketing or promotional purposes. Message frequency may vary for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You may reply STOP to cancel or HELP for assistance.

EEO Employer

Equiliem is an equal opportunity employer. We do not discriminate or allow discrimination based on race, color, religion, creed, sex, age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Equiliem will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [emailprotected] or [phone].