Job details
Job type full-time
Full job description
Job description summary
As part of the annuity and retirement actuarial area of the finance department, this position will focus on the modernization efforts to support the variable annuity valuation processesThis will include the creation and implementation of variable annuity inforce files as well as the conversion of current the admin systems to a new admin system.
Job description
Responsibilities
Completes significant and complex data manipulation as well as complex calculation using macros and other programs.
Defines system and functional requirements to support data input for valuation models.
Assists in preparation and testing of inforce files.
Develops automated tools for testing and analysis of inforce files.
Extracts and integrates data from various databases to analyze and reconcile conversions.
Writes and executes complex queries within a data warehouse and/or a relational database.
Maintains existing business tools supporting data correction and key controls.
Verifies and reconciles financial reporting data and ensures controls are completed.
Specializes in variable annuity product knowledge.
Analyze and measure the effectiveness of existing business processes and develop sustainable, repeatable and quantifiable business process improvements.
Collaborates with modernization, it, finance, actuarial and other areas throughout the company.
Other duties as assigned based on department needs.
Conforms with and abides by all regulations, policies, work procedures, instruction and all safety rules.
Exhibits regular, reliable, punctual and predictable attendance.
Qualifications
Bachelor’s degree in computer science, data analytics or related field
Five years of experience in process engineering, accounting, financial technology and quality control (or three years with graduate degree)
Experience with accounting, actuarial and it processes and systems
Effective verbal and written communication skills
Effective organizational and time management skills
Experience with alteryx and excel.
Experience with query languages like ms access, sql, hiveql, oracle, and impala
Preferred qualifications
Graduate degree
Experience working with asset liability management processes in insurance or banking.
Experience working with investment and insurance products
Working towards six sigma certification (i.e., master black belt, black belt)
Experience creating, using and monitoring controls
Working conditions
Hybrid employees will need to work at a company office location at times and a remote work location (cedar rapids, ia) at times.
Non-commuting remote employees will not be assigned to report to a company office location (although they may need to travel to a company office upon request) and will perform their work remotely.
**please note that the compensation information that follows is a good faith estimate for this position only and is provided pursuant to the colorado equal pay for equal work act and equal pay transparency rulesIt is estimated based on what a successful colorado applicant might be paidIt assumes that the successful candidate will be in colorado or perform the position from coloradoSimilar positions located outside of colorado will not necessarily receive the same compensation**
Compensation:
The salary for this position generally ranges between $84,000-$111,000This range is an estimate, based on potential employee qualifications, operational needs and other considerations permitted by lawThe range may vary above and below the stated amounts, as permitted by colorado equal pay transparency rule 4.1.2.
Bonus eligibility:
This position is also typically eligible for an annual based on the company bonus plan/individual performance and is at company discretion at a rate of 12.5%.
What you receive:
A comprehensive wealth + health packageIt’s our passion to empower people, and especially our employees, to add years to their lives and more life to their yearsThat means a healthy account balance and a healthy body to matchAs you’ll come to discover, wealth + health is a central part of everything we do!
Wealth benefits; competitive pay, bonus, and benefits package; pension plan, 401k match, employee stock purchase plan, tuition reimbursement, disability insurance, stock purchase plan, employee discounts, career training & development opportunities, certification sponsorship
Health and work/life balance benefits; be well company sponsored holistic wellness program which includes wellness coaching and reward dollars, parental leave, adoption assistance, employee assistance program, college coach program, back-up care program, paid time off to volunteer, employee matching gifts program, employee resource groups, inclusion and diversity programs, employee recognition program
Our commitment to inclusion & diversity means that we value differencesWe encourage the unique perspectives of individuals and are dedicated to creating a respectful and inclusive work environment.
