Our Fortune 500 client is seeking an Excel guru who has insurance/reinsurance experience. The perfect candidate MUST have knowledge in formulas, pivot tables, v look up, import export data from excel, Knowledge of insurance/reinsurance concepts and terms for developing submissions, reviewing contract wordings, and reinsurance experience. This is an excellent opportunity!!

Responsibilities will include:

Placement Support

• Review client data submitted during the placement/renewal process and update annual renewal exhibits as requested.
• Set up / renew program, create submission, select approved markets, send submissions, download quotes, send FOTs, download authorizations/declinations, send signed lines, finalize in GCMP making sure all information is accurately reflected.
• Track placement status of assigned accounts. Follow-up with broker for updates and information as necessary.
• Communicate with client and/or markets during the placement process as requested.
• In the absence of the broker, act as a liaison with reinsurers through phone calls and emails to obtain following lines on a placement and respond to routine questions.
• Using Company templates and disclaimers, when applicable, draft and secure broker sign off of the initial request for renewal information, marketing list, placement process updates, final binding of the reinsurance program and postplacement client books/communications, as requested.
• Provide the broker with assistance including researching financial statements, product lines, geographic exposures, and current reinsurance program. information using available resources as required.
• Interface with other Departments to provide client data to be used for modeling, research claim or premium issues and facilitate contract wording negotiation flow as necessary.
• Coordinate the research, processing and resolution of difficult and complex client issues (i.e., accounting, claims, LOC, and contract wordings) including follow up and final resolution and provide information to brokers, as necessary.
• Review, package and transmit contract documents to Reinsurers according to procedure, upon instructions from Contract Analyst/Associate.
• Assist Contract drafters by having primary responsibility for obtaining properly signed contract documents from reinsurers and aggressively pursuing by phone, e-mail, letter, etc., until all executed documents have been received. Escalate in accordance with procedure and input contract status data on the document tracking system as required.
• Provide status reports according to procedure and upon request.
• Scan/upload and name all contract documents as received from reinsurers, Clients and/or Analysts/Associates and transmit completed signatures.
• Utilize Contracts Dashboard and/other legacy tracking tools to manage contract performance.
• Assist with scheduling of reinsurer audits and visits with client, attending if requested.

Business Knowledge

• Maintain broad understanding of the environment in which the client operates and the marketplace in which the transactions that Guy Carpenter handles take place.
• Using the Market Reference Guide, develop an understanding of the differences between the reinsurer who bears the risk on the contract versus the parent or group entity to ensure proper legal reinsurer name is entered in systems and correct financials and NAIC codes are accurately communicated to clients.
• Participate in team meetings and activities to share opinions, ideas, knowledge and solutions; maintain strong working relationships and participate in initiatives and/or contribute where required to deliver outcomes. Seek opportunities to increase own understanding and improve the services provided.

Compliance and Regulatory Review

• Ensure all records/forms for assigned accounts are properly completed and stored in accordance with policy.
• Understand all best practice procedures and compliance policies. When new procedures are provided, understand and adopt new procedures as rolled out, take required training and speak up with any question or concerns uncovered in your role at Guy Carpenter.
• Follow all best practice procedures and compliance requirements, including but not limited to building a complete placement file as the placement progresses to minimize errors & omissions.

Client Services

• Provide client and broker with comprehensive meeting book for marketing trips and convention attendance.
• Respond to client requests for information (reinsurer, financial reports, industry issues, etc.), as directed by senior broker, coordinating with Market Information and other departments as necessary, and clearing with senior broker.
• Attend external client meetings as requested.

Other

• Attend visiting reinsurer meetings, as necessary
• Provide assistance with training

Qualifications

Education:

• Associate's Degree and applicable or transferrable experience preferred

Experience:

• 3-5 years related experience in insurance/reinsurance industry.

Knowledge and skills:

• Knowledge of insurance/reinsurance concepts and terms for developing submissions, reviewing contract wordings.
• Basic knowledge and understanding of insurance/reinsurance accounting and claims handling.
• Strong interpersonal skills for establishing and maintaining good internal relationships and interactions with clients and reinsurers.
• Strong verbal and writing skills for internal and external communications with clients, reinsurers, GC colleagues at various levels.
• Strong ability to prioritize workload according to volume, urgency, etc.
• Strong organizational skills and the ability to pay attention to detail and multi-task.
• Good problem-solving skills to identify problems and to begin to formulate resolutions and recognize when to escalate to manager.
• Good computer skills. Proficient in Microsoft Products.
• Strong excel skills