Demo

Reconciliation and Exposure Data Analyst

MassMutual
Boston, MA Full Time
POSTED ON 3/30/2025
AVAILABLE BEFORE 4/28/2025
Investment Operations, Investment Management

Full-Time

Boston, MA or Springfield, MA

The Opportunity

As the ideal Reconciliation and Exposure Data Analyst, you will own the monthly execution and reconciliation of the financial exposure reporting process between the Trial Balance to cash match process and evaluate and prepare results exceeding predetermined thresholds for financial impact review by Investment Controllership. You will understand how this data is compiled, transformed and processed, and be able to present Exposure to controllership, senior leadership and other stakeholders. You will be supporting data requests and providing detailed analysis of large data sets. This work includes working with controllership and other stakeholders across the investment operations organization. The nature of the work will require perseverance, accountability, and resourcefulness.

The Team

The Reconciliation and Exposure Data Analyst reports to the Director of Securities Data Management, part of the MassMutual Investment Operations team within the Investment Management division. The Securities Data Management team is agile and works independently, yet collaboratively with various teams across the enterprise. To be successful, you must have strong attention to detail, the ability to multitask and thrive in a fast-paced work environment.

The Impact

  • Manage monthly reconciliation and financial exposure impact reporting process, including presentation of financial impact to Investment Controllership and other stakeholders across the Investment Operations organization.
  • Lead root cause analysis and resolution of business investment data challenges demonstrating agility in managing multiple issues concurrently.
  • Create and enhance scalable Excel spreadsheets, utilizing VLOOKUPs, macros, and complex formulas to streamline data analysis and reporting and efficiency.
  • Understand the existing flows of data into the investment ecosystem including how data is sourced and aggregated to support the usage of investment data by all MassMutual stakeholders.
  • Proficient with the monthly-close process including journal entry preparation, variance analysis, financial reporting, and the creation of financial models and impact studies to analyze business data.
  • Partner with controllership team to ensure financial exposure thresholds breaks analysis and methodology is reflective of remediation efforts and initiatives.
  • Communicate and collaborate with internal and external partners to implement new or changing data needs.
  • Accountable for escalated and ongoing support for all users of data while ensuring appropriate documentation of processes is available and maintained.
  • Represent the Investment Data Integrity team on various remediation projects, process improvement initiatives and complex research items.

The Minimum Qualifications

  • Bachelor’s degree in accounting or equivalent experience is required.
  • 7 years of accounting experience with an understanding of financial exposure financial impact analysis.

The Ideal Qualifications

  • Knowledge of investment data accounting from ingestion of source data to end user reporting.
  • Ability to communicate across all levels of the organization, comfortable interacting with vendors, business partners, external managers and internal Investment and IT.
  • Ability to work across multiple priorities with limited guidance.
  • Ability to independently explore solutions to a problem and adapt quickly to changes.
  • Collaboration skills and the ability to work in a team-based environment.
  • Must be eligible to work in the US without sponsorship now or in the future.

What to Expect as Part of MassMutual and the Team

  • Regular meetings with the Collateral and Settlement Operations team
  • Focused one-on-one meetings with your manager
  • Access to mentorship opportunities
  • Networking opportunities including access to Asian, Hispanic/Latinx, African American, women, LGBTQ, Veteran, and disability-focused Business Resource Groups
  • Access to learning content on Degreed and other informational platforms
  • Your ethics and integrity will be valued by a company with a strong and stable ethical business with industry leading pay and benefits

MassMutual is an Equal Employment Opportunity employer Minority/Female/Sexual Orientation/Gender Identity/Individual with Disability/Protected Veteran. We welcome all persons to apply. Note: Veterans are welcome to apply, regardless of their discharge status.

If you need an accommodation to complete the application process, please contact us and share the specifics of the assistance you need.

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Reconciliation and Exposure Data Analyst?

Sign up to receive alerts about other jobs on the Reconciliation and Exposure Data Analyst career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$34,091 - $42,734
Income Estimation: 
$38,552 - $46,597
Income Estimation: 
$171,476 - $268,321
Income Estimation: 
$186,654 - $298,212
Income Estimation: 
$65,044 - $88,745
Income Estimation: 
$81,115 - $111,302
Income Estimation: 
$168,173 - $306,433
Income Estimation: 
$81,115 - $111,302
Income Estimation: 
$102,977 - $139,811
Income Estimation: 
$341,017 - $487,702
Income Estimation: 
$102,977 - $139,811
Income Estimation: 
$133,653 - $195,399
Income Estimation: 
$525,322 - $679,598
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at MassMutual

MassMutual
Hired Organization Address Springfield, MA Full Time
Accounting Corporate Close Process Manager Close and Consolidation Team Full-time Boston, MA or Springfield, MA The Oppo...
MassMutual
Hired Organization Address Boston, MA Full Time
Accounting Corporate Close Process Manager Close and Consolidation Team Full-time Boston, MA or Springfield, MA The Oppo...
MassMutual
Hired Organization Address Scottsdale, AZ Full Time
Flexibility and Control. And a business partner who gives you the freedom to have both. You’ve spent a good portion of y...
MassMutual
Hired Organization Address Springfield, MA Full Time
Job Details The Opportunity As Head of Variable Annuity Pricing you will play a key role in helping MassMutual responsib...

Not the job you're looking for? Here are some other Reconciliation and Exposure Data Analyst jobs in the Boston, MA area that may be a better fit.

Reconciliation Analyst

Dexian, Boston, MA

Reconciliation Analyst

Signature Consultants, Boston, MA

AI Assistant is available now!

Feel free to start your new journey!