Job Description

- Investment Planning and Projections Function, Responsibility Level: Operations, Manager Reports to (Responsibility Level): Director - Fin Ops Supervises: Individual Contributor Global Grade: Grade 10 Cost Center (85 series): NA Complexity: C5T5 PID/s Load Mapping: NA Position Summary In this role within the Investments Finance team is principally responsible for supporting the Derivative Net Investment Income/Asset Planning and Projections. The team delivers results and analysis to the senior level officers on a regular basis on Financial instruments. Team members have extensive interaction with Investments Group as well as other departments across the Enterprise. Job Responsibilities Derivative Net Investment Income/Mark To Market Projection - Compile data from various sources (amounts and descriptive/enrichment data) to prepare a single attribution file of Current versus Prior data for all relevant comparisons. Amortization of Derivative Premiums - Summarize the various amortization schedules for the different derivative types (caps, floors, swap, options, CDS) that will be an input into the Derivatives GAAP and STAT Feeds. 10K/10Q Peer Analysis for Derivatives - pull derivative data from peer 10K/10Q reports to update spreadsheet with historical data. Analyze data and process flows to improve forecasting/modeling accuracy. Gain in-depth understanding of all outputs from the model and provide a detailed attribution of the results. Work closely with various partners across the enterprise to understand and implement required work for Investments planning and projections work. Perform sensitivity analysis. Prepare Realized Gain/Loss reporting & IMR Acquisitions Rating for RCGLs. Prepare Stat NII feeds and refresh reports. Should be able to handle large datasets of information. Should be able to gather, organize and understand information from 10-15 different excel files. Analyze and implement process improvements. Knowledge of Derivative and other various investment asset classes. Knowledge, Skills and Abilities Education CA, CPA, Experience 2-4 Years of experience in Finance/Accounting/Derivative/Investments background. 2-4 Years of experience working with Advanced Excel in a corporate setting, including the use of pivot tables and v-lookups. Knowledge of Alteryx/ SQL and MS Access. Knowledge and skills (general and technical) Insurance and/or Investment industry experience. US GAAP & STAT knowledge Excellent written and oral communication skills, including ability to communicate with all levels of management work effectively independently as well as with teammates. Ability to structure and conduct detailed, data-driven analyses. Aptitude in building and adjusting spreadsheet models/databases. Ability to identify the key financial drivers of any asset. Proven ability to independently manage multiple assignments and demonstrate initiative. Attention to detail, yet able to summarize and communicate complex issues effectively. Proficient use of MS Office (Advanced Excel, Access, Word and PowerPoint) and Business Intelligence Tools. Understanding of SQL queries. Knowledge of PeopleSoft, Essbase, Hyperion, COGNOS/CUBUS Knowledge of Life Insurance GAAP, Statutory accounting and RBC a plus. Other Requirements (licenses, certifications, specialized training - if required) Not applicable Working Relationships Internal Contacts (and purpose of relationship): Director for the purpose of settling issues and monthly evaluation of performance Associate Accountants for the purpose of seeking cooperation & clarification on process-related matters & providing assistance and support when required. Subject Matter Expert for the purpose of work thread related issues and escalated transactions. External Contacts (and purpose of relationship) - If Applicable SME / Trainers at stateside for training/follow up Different lines of businesses (as required) for follow-up work

foundit