Financial Analyst Job in Los Angeles 90024, California US
Analyst performs a variety of administrative duties, within the Funding Administration Department.
Essential Functions:
Uploads verifies investment prices in the recordkeeping system.
Uploads and verifies dividends in the system on a daily basis.
“Market Timing” oversight and reporting
Historical Performance of Investment Choice (HPIC) reporting.
Administration of corporate owned life insurance (COLI) plans on a proprietary database.
Responsible for the premium-crediting program, including preparation of the premium listings, following up as necessary to ensure monies have been received, and credited. Reconciles and updates weekly records of premiums paid between company and the carriers.
Determines policy capacity with each premium payment. Performs general analysis to determine if and when 7-pay capacity will run out.
Proficient in asset reallocation administration, implementation and execution.
Proficient in Asset Value Reporting (AVR) to include carrier extraction, auditing and report preparation.
Able to create and update all versions of the policy analyses.
Creation of asset/liability templates for delivery to CRM’s, consultants and client service team, to include COLI data extraction and obtaining liability values from Client Services.
Generate and confirm accuracy of a variety of spreadsheets, reports and correspondence, as required.
Ensure compliance with plan rules and regulations as well as client directed funding strategies.
Provide exceptional customer service to internal and external customers via phone, mail and electronic media.
Coordinate activities of client, plan participants, trustee insurance companies and other affiliates.
Respond proactively to ad hoc requests from clients and management.
Formulate and maintain valued relationships with clients, carriers, peers and associates.
Other Responsibilities:
Participate in company, department, team and individuals goals, special projects and task forces.
Participate in development and mentoring of less experienced staff.
Promote improvement of department processes, procedures and work product.
Education, Experience and Skills Required:
Basic financial acumen with strong math skills.
Undergraduate degree in related field and/or relevant experience.
Knowledge of qualified or non-qualified benefit plan administration, life insurance, finance, accounting, financial modeling or other technically oriented benefits-related field is preferred.
Ability to anticipate needs and take effective action.
Detail oriented, analytical self-starter with a motivation to expand knowledge, skills and responsibility.
Knowledge of Excel spreadsheet database and Microsoft Word.
Ability to manage and prioritize projects and take an active role in problem solving/decision making.
Ability to meet deadlines and work both independently and as a team member.
Excellent verbal and written communication skills.
Utilizes reasoning ability to define problems, collect data, establish facts and draw conclusions.
Excel experience required
Detail oriented