At EMC, we’re all about working together to make an impact. As part of our team, you’ll have the opportunity to grow, contribute, and gain experience that matters. We strive to be caring leaders, close partners, and responsive experts—always supporting each other to do our best work. Join us, and let’s improve lives together.
Under close supervision, assists the EMCNL actuarial data steward with the data warehouse. Performs assigned valuation and financial projection tasks, maintains the integrity of calculations within the sales illustration system, completes and validates periodic reporting, and participates on various cross functional teams.
Essential Functions:
Maintains documentation of the actuarial team SQL databases and how data flows through the database
Maintains the data infrastructure (tables, keys, schema, etc.)
Supports the data driven aspects of product pricing, assumption setting, and modeling
Identifies ways to improve the data infrastructure
Runs reports of actuarial reserves in SQL
Validates the accuracy of the valuation and financial projection work using Excel
Maintains the sales illustration system by continuously checking the accuracy of calculations and adding new products to the system as they are developed.
Produces periodic reports and analysis including reports of reserve calculations for reinsurers, summarizes rates for interest sensitive products for the interest rate team, and death claims analysis.
Participates on various cross functional teams such as reinsurance, interest rate, and product implementation. Provides assistance with internal and external audits.
Education & Experience:
Bachelor's degree in actuarial science or statistics or related field
Knowledge, Skills & Abilities:
Knowledge of statistics and probability
Good knowledge of various computer software, such as Excel and Word
Knowledge of database computer software (Access, SQL, etc.) SQL preferred
Strong analytical, investigation and problem-solving abilities
Strong verbal and written communication skills
The hiring salary range for this position will vary based on geographic location, falling within either of the following:
$60,813 - $84,038 or $67,200 - $92,395A hiring range represents a subset of the full salary range. The actual salary will depend on several factors, including relevant education, skills, and experience of an applicant, geographic location, and business needs.
For information relating to the benefits EMC Team Members receive as part of a comprehensive rewards package, please visit www.emcins.com/careers.
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.
Similar Jobs
What We Do
EMC Insurance Companies is among the top 60 insurance organizations in the country based on net written premium, and we have more than 2,500 employees. The company was organized in 1911 to write workers’ compensation protection in Iowa. Today, EMC provides property and casualty insurance products and services throughout the United States and writes reinsurance contracts worldwide. Operating under the trade name EMC Insurance Companies, Employers Mutual Casualty Company and one or more of its affiliated companies is licensed in all 50 states and the District of Columbia.
