Actuarial Analyst II-EMCNL

Company: EMC Insurance Companies
Location: Des Moines
Posted on: April 25, 2024

Job Description:

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:
    • Strong knowledge of statistics and probability
    • Strong knowledge of various computer software, such as Excel and Word
    • Strong knowledge of database computer software (Access, SQL, etc.) preferred
    • Excellent analytical, investigation and problem-solving abilities
    • Strong verbal and written communication skills Our employment practices are in accordance with the laws that prohibit discrimination due to race, color, creed, sex, sexual orientation, gender identity, genetic information, religion, age, national origin or ancestry, physical or mental disability, medical condition, veteran status, active military status, citizenship status, marital status or any other consideration made unlawful by federal, state, or local laws.All of our locations are tobacco free including in company vehicles.To learn more about why you're gonna love it here, watch the video below.

Keywords: EMC Insurance Companies, Ankeny , Actuarial Analyst II-EMCNL, Professions , Des Moines, Iowa