|
Actuarial Analyst II-EMCNL - Des Moines Iowa
Company: EMC Insurance Companies Location: Des Moines, Iowa
Posted On: 04/27/2024
At EMC, you'll put your skills to good use as an important member of our team. You can count on gaining valuable experience while contributing to the company's success. EMC strives to hire and retain the best people by engaging, developing and rewarding employees.**This position can be performed remotely for candidates who reside in ME, VT, NH, MA, CT, PA, WV, VA, NC, SC, GA, AL, FL, TN, KY, OH, IN, IL, WI, MI, MN, IA, MO, AR, LA, ND, SD, NE, KS, OK, TX, AZ, UT, NV, ID.**Summary:Serves as the EMCNL actuarial data steward, managing large and complex actuarial databases, including the maintenance of documentation and infrastructure. Performs assigned valuation and financial projections. Maintains the integrity of calculations within the sales illustration system. Completes and validates periodic reporting. Represents the actuarial team on various cross functional teams.Essential Functions: - Performs and updates all changes to the actuarial team SQL databases
- Maintains documentation of the actuarial team SQL databases and how data flows through the database, and the reasoning for the design
- Maintains the data infrastructure (tables, keys, schema, etc.) in a precise, consistent way
- Leads the data driven aspects of product pricing, assumption setting, and modeling
- Identifies ways to improve the data infrastructure. Makes recommendations to actuarial leadership and implements changes
- Runs the actuarial software to calculate reserves
- Runs the actuarial software to calculate asset and liability durations
- Builds and updates reports of actuarial reserves in SQL
- Validates the accuracy of actuarial valuation and financial projection work using Excel
- Serves as a subject matter expert and maintains the sales illustration system by continuously checking the accuracy of calculations and adding new products to the system as they are developed
- Collaborates with Management Information Systems and Marketing Communications to ensure the illustration runs smoothly and the wording is accurate
- Produces periodic reports and analysis including reports of reserve calculations for reinsurers, recommends rates for interest sensitive products for the interest rate team, and death claims analysis
- Represents the EMCNL actuarial team on various cross functional teams such as reinsurance and product implementation and chairs the interest rate team
- Coordinates internal and external auditsEducation & Experience:
- Bachelor's degree in actuarial science or statistics or related field
- Two year of actuarial experience
- Three actuarial exams or equivalent relevant experience
- Additional experience, exams, or graduate level coursework may be considered in meeting the requirementsKnowledge, Skills & Abilities:
|
|