Actuarial Contractor Location: Whitehouse Station, NJ/Hybrid Duration: 5-6 months Description: Summary: Claims Actuarial Insights Department, strives to empower claims professionals with actionable intelligence. The team works closely with senior leaders to provide reporting and ultimate loss projections for current and prior year catastrophes. This role will be asked to apply critical thinking to refresh, improve, and expand the catastrophe projection process for North America. Job Responsibilities: This role will be focused on updating and revamping the North America catastrophe projection process. Responsibilities include: Pull, transform, and reconcile an updated historical dataset Using the historical dataset, select factors and measures by event type and other attributes Develop solutions to current challenges with the process Build additional capabilities to address gaps in the process Perform testing and validation to ensure the updated process works well Document and communicate updates and changes to the process and their impact Skills Required: Fully Proficiency in Excel and working knowledge of VBA (Visual Basic Application). Proficiency in SQL server; Working knowledge of R or Python is a plus Strong analytical skills with the ability to work independently and effectively overcome challenges Strong project and time management skills. Will take ownership of project. Able to maintain good documentation and record keeping Able to provide clear and concise verbal and written communications to non-actuarial business leaders Desire to work in a fast-paced, fluid environment Education/Experience: Bachelor's degree FCAS or ACAS credential 5+years of experience in property/casualty actuarial disciplines About the Team: Claims Insight Actuarial team. Focused on Catastrophe projection. Focused on claims side, what happens if Catastrophe hits. Looking for a person to help improve Catastrophe projection models. Develop models and improve it than it what currently is. Looking for someone who can point out challenges, that team doesn’t even recognize right now Education Experience: Requires 5 years’ experience. FCAS, ACAS highly preferred, willing to look at profiles without ACAS, someone who is taking exams is also fine P&C (Property and Casualty) experience required; Health insurance not work. Required Skills: Full Proficiency in Excel(Vlookup and Pivot tables), VBA working knowledge Proficiency in SQL Server Working knowledge in R or Python is a plus Good written and verbal communication skills