Position Summary: In this role within the Investments Finance team is principally responsible for supporting the Derivative Net Investment Income/Asset Planning and Projections. RBC and support in the management of daily activities. Team members have interaction with Investments Group as well as other departments across the Enterprise
Job Responsibilities
All tasks require above average excel skills, including pivot tables and vlookups
1. Data Inputs
a. Pulling required reports from PAM (ACN1, ACN3, ODBC, etc.)
b. Pulling monthly ledger reports from Essbase
c. Running defined scripts to populate PAR feeds (TimeZero, roll off, cash flows, etc.)
2. Modeling Process
a. Create projection instances
b. Load feeds into the model
c. Fix unassigned buckets in CAB reports
d. Fix erroneous yields for portfolios
e. Prepare various topsides
i. Foreign Bond income topside
ii. Prepare Preferred Stock Projection income
iii. P&C Inverse Floater Topside
iv. FHLB Dividend Topside
v. Gables Loan Income Topside
vi. Policy Loans Income Topside
f. Submit calculation / cube processes
g. Run monthly rate sensitivities (vs. prior, vs. prior, rates, spreads)
h. Run monthly STAT projections
i. Run quarterly STRESS projections
3. Data Outputs
a. Roll forward and refresh BI reports pulled from PAR
b. Create submission templates for Int'l Reporting database
c. Load feeds into Int'l Reporting database
Education
- BCom in Accounting or Finance.
- 1-2 Years of experience working with Advanced Excel in a corporate setting, including the use of pivot tables and v-lookups.
Skills:
- • 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.
- • Advanced Excel skills.
- • Strong communication & analytical skills required.
- • Ability to handle multiple tasks, prioritize, solve problems and ability to meet deadlines are required.
- • Must be able to work with multiple departments in the compilation of data and the reporting of financial information.
- • Knowledge of Alteryx very helpful.
About MetLife
Recognized on Fortune magazine's list of the "World's Most Admired Companies" and Fortune World's 25 Best Workplaces™, MetLife, through its subsidiaries and affiliates, is one of the world's leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East.
Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by our core values - Win Together, Do the Right Thing, Deliver Impact Over Activity, and Think Ahead - we're inspired to transform the next century in financial services. At MetLife, it's #AllTogetherPossible . Join us!
#BI-Hybrid
Skills Required
- 1-2 Years of experience working with Advanced Excel
- BCom in Accounting or Finance
- Insurance and/or Investment industry experience
- Knowledge of US GAAP & STAT
- Knowledge of Alteryx
What the Team is Saying
.png)
.png)
What We Do
We're honored to be No. 10 on Great Place to Work's World's Best Workplaces and recognized in the Fortune 100 Best Companies to Work For® list in 2025. At MetLife, we're leading the global transformation of an industry we’ve defined for over 157 years. At MetLife, every innovation and line of code is a lifeline for our customers and their families—from victims of natural disasters to people living with disabilities and beyond. With operations in more than 40 markets and leading positions across the globe, MetLife fosters an inclusive culture where our people are energized and inspired to deliver for our customers and communities. Join our remarkable journey—one in which you help write the next century of innovation in financial services—because with MetLife, making the world a better place is All Together Possible.
Why Work With Us
At MetLife, you’ll be working for a company whose purpose is to help customers throughout their life’s journey, and often in their most critical time of need. You’ll be a part of developing leading-edge platforms that will have a lasting impact on the lives and well-being of tens of millions of customers.
Gallery
MetLife Teams
MetLife Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
MetLife's current workplace policies classify roles as Office, Hybrid or Virtual based on the nature of work, encouraging new ways of working together
