Financial Business Analyst - Reinsurance

Description

M Financial Group is a community of leaders comprising the best and brightest minds in our industry. By combining individuals' expertise and skill, M Financial Group has become a powerful force committed to advancing the interests of our industry, communities, and clients for over 40 years. M's solutions are rooted in the diverse expertise of our team, our collaborative approach to innovation and our comprehensive support.

We embrace a progressive, dynamic mindset for every role. M Financial Group provides a professional community that actively supports individuals with diverse backgrounds and perspectives who come together to build and support best-in-class solutions. If you're looking to be a part of a high performing, collaborative, and dedicated team, M Financial Group is in search of our next Financial Business Analyst to join our team.

As a key member of the Finance and Reinsurance teams, this position will be responsible for various statistical reports and internal tools related to life reinsurance administration. Additionally, this position will assist with monthly and quarterly life reinsurance reporting including premium billings and claims processing; SQL database management; and data management support for Accounting and Member Firm Compensation Plan (MFCP) administration.

RESPONSIBILITIES

Support Reinsurance Team

  • Design and implement robust processes for reinsurance administration and financial reporting
  • Develop tools for administration and reporting using Excel, Python, and SQL
  • Support collaboration by maintaining relevant documentation
  • Work effectively with the actuarial teams on various research projects
  • Work effectively with internal underwriters to assess available capacity on the placement of new life insurance cases
  • Support internal Reinsurance and Finance Teams with quarterly financial reporting, external audits, and internal controls initiatives
  • Cross-train new employees reinsurance reporting and assist in development of projects for summer interns

TAI Reinsurance Administration

  • Perform retention management and billing in the TAI reinsurance administration system - process reinsurance claims, code legal contract terms within TAI system, and manage monthly financial reporting deadlines
  • Collect and format carrier data feeds, perform consistency checks across other data sources, run monthly TAI cycles, prepare reports summarizing/analyzing output, communicate results to management, and recommend action to be taken
  • Manage reinsurance billings and coordinate transactions with the Accounting Team
  • Manage life reinsurance claims by collecting notices and proofs, notify partner counterparties of claims, and request monetary reimbursements
  • Review legal contracts and coordinate terms within TAI system
  • Develop and maintain SQL database including management of code changes and regular TAI audits
  • Work with internal M teams and outside consultants on maintaining current TAI system; lead a project to upgrade system
  • Maintain TAI budget forecasting and track expenses

Support MFCP Team

  • Support the maintenance and operation of the MFCP SQL administration system
  • Assist in the allocation process of the annual MFCP by participant and provide analysis for ongoing MFCP maintenance
  • Other projects as assigned

QUALIFICATIONS

  • Bachelor's degree in Finance, Accounting or Business; or equivalent experience
  • Minimum of three years of related experience, with a preference for reinsurance administration or Actuarial work
  • Strong computer proficiency including installing software, using command line programs, and scheduling tasks
  • Experience automating repetitive tasks and analyzing data, preferably using Python and SQL
  • Experience with version control systems, preferably Git
  • Demonstrated ability to prepare technical documents and reports
  • Ability to establish and maintain effective working relationships with Member Firms, Carriers and fellow M Team Members
  • Excellent interpersonal skills with an aptitude for customer service
  • Ability to work independently, demonstrate initiative, drive, orientation to goal accomplishment
  • Exceptional organizational skills, with the ability to follow through on tasks
  • Excellent written and verbal communication skills; and problem-solving skills
  • Demonstrated ability to prepare technical documents and reports
  • Previous life insurance or reinsurance systems (TAI) experience preferred, but not required
  • Designations also preferred including FLMI, ARA or ACS

JOB CONDITIONS AND ENVIRONMENT

  • Normal office environment/desk assignment
  • Extensive close work with spreadsheets, databases and data management reports
  • Light/occasional travel

This position description is not intended to be and should not be construed as an all-inclusive list of responsibilities, skills or working conditions associated with this position. While this description is intended to accurately reflect the position's activities and requirements, management reserves the right to modify, add or remove duties as necessary.






Category

Management Analysts


Education

Bachelor's Degree


Experience

3 to 20+ years


Job type

Full time

Posted
10/02/2021
Salary Range
$50,000.00 - 96,000.00
per Year
Salary range estimated by
Location
Hartford, CT 06112, US
Apply Now