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
Didn't find what you're looking for? Search again!
Loading more jobs...