Data Consultant, Pension Risk Transfer

Pension Risk Transfer Operations

Full-Time (Hybrid Office – Springfield, MA)

The Opportunity

As a Data Consultant, Pension Risk Transfer, you will play a critical role in evaluating, cleansing, and validating annuitant-level data for new business onboarding and contract execution. You will transform complex data from multiple sources into trusted, decision-ready outputs that support due diligence, risk review, implementation, and ongoing operations. This is an opportunity for a highly analytical, detail-oriented professional to apply deep data expertise in a fast-paced environment, partner across business functions, and help improve how we scale a high-growth business.

The Team

The Pension Risk Transfer (PRT) New Business Team is responsible for supporting the successful onboarding and execution of new PRT business. The group plays a critical role in managing the end-to-end new business lifecycle—from deal close through implementation—ensuring accuracy, readiness, and a seamless transition into ongoing operations.

The team works cross-functionally with partners in pricing, legal, enforce administration, and technology to ensure new cases are set up correctly, complex requirements are addressed, and operational processes are executed efficiently. Their work often includes coordinating data readiness, resolving issues, supporting system configuration, and driving process improvements to enhance scalability in a growing business

The Impact

• Lead detailed scrubbing, validation, and analysis of annuitant-level data for new Pension Risk Transfer transactions to ensure completeness, consistency, and usability.

• Translate raw data from one or more sources into accurate, decision-ready reports, reconciliations, and databases used for due diligence, implementation, and operational setup.

• Perform rigorous quality checks, balancing, and control reconciliations to confirm the integrity of both inbound and outbound data.

• Identify, investigate, and resolve data discrepancies, exceptions, and missing information with speed, sound judgment, and strong documentation.

• Document assumptions, corrections, findings, and unresolved issues clearly to support transparency, auditability, and handoff readiness.

• Partner closely with sales, operations, implementation, technology, and other stakeholders to clarify data questions, improve readiness, and support successful onboarding.

• Support ad hoc reporting, analysis, and issue resolution across the broader operations organization as business needs evolve.

• Recommend and help implement process improvements that strengthen data quality, reduce rework, and improve efficiency across the new business pipeline.

The Minimum Qualifications

• High school diploma

• 5+ years of experience in data analysis, data consulting, operations analytics, or a related role requiring high accuracy and strong problem solving.

• 3+ years of experience with advanced Excel skills and demonstrated experience working with large, detailed datasets from multiple sources.

The Ideal Qualifications

• Bachelor’s degree

• 7+ years of relevant experience, including work in Pension Risk Transfer, defined benefit plans, retirement operations, insurance operations, or complex financial services environments.

• Experience with annuitant-level data, pension administration data, onboarding new business, or data readiness for implementations.

• Proficiency in SQL, Python, or other data manipulation and automation tools.

• A track record of identifying process improvements, influencing partners, and helping teams scale through better data practices.

• Strong attention to detail with the ability to detect anomalies, reconcile discrepancies, and deliver high-quality outputs under deadlines.

• Excellent analytical and critical thinking skills, including the ability to interpret data, identify root causes, and recommend practical solutions.

• Experience organizing data into clear, usable outputs for business partners and decision makers.

• Strong written and verbal communication skills, with the ability to document findings clearly and collaborate effectively across functions.

• Ability to manage multiple priorities in a fast-paced environment while maintaining strong quality standards.

What You Can Expect at MassMutual
MassMutual offers the opportunity to do meaningful work within a purpose-driven organization that values long-term impact over short-term outcomes. In this role, you can expect:

• Clear areas of ownership and accountability, with work that connects directly to company and customer outcomes

• A collaborative environment where perspectives are welcomed

• Access to learning, development, and internal networks that support continuous growth and skill-building over time

• Employee-led communities and forums that foster connection, learning, and inclusion across the organization

• A culture grounded in integrity, responsibility, and stewardship—supported by a company with a strong legacy and a future-focused mindset

#LI-MM1

Salary Range:

At MassMutual, we focus on ensuring fair equitable pay, by providing competitive salaries, along with incentive and bonus opportunities for all employees. Your total compensation package includes either a bonus target or in a sales-focused role a Variable Incentive Compensation component.

Why Join Us.

We’ve been around since 1851. During our history, we’ve learned a few things about making sure our customers are our top priority. In order to meet and exceed their expectations, we must have the best people providing the best thinking, products and services. To accomplish this, we celebrate an inclusive, vibrant and diverse culture that encourages growth, openness and opportunities for everyone. A career with MassMutual means you will be part of a strong, stable and ethical business with industry leading pay and benefits. And your voice will always be heard.

We help people secure their future and protect the ones they love. As a company owned by our policyowners, we are defined by mutuality and our vision to put customers first. It’s more than our company structure – it’s our way of life. We are a company of people protecting people. Our company exists because people are willing to share risk and resources, and rely on each other when it counts. At MassMutual, we Live Mutual.

MassMutual is an equal employment opportunity employer. We welcome all persons to apply.

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

At MassMutual, we focus on ensuring fair, equitable pay by providing competitive salaries, along with incentive and bonus opportunities for all employees.  Your total compensation package includes either a bonus target or in a sales-focused role a Variable Incentive Compensation component.  For more information about our extensive benefits offerings please check out our Total Rewards at a Glance.