Quantitative Consultant
MassMutual
The Opportunity
MassMutual is seeking a Quantitative Consultant to join our Product Modeling team within the Annuity Product Department. In this role, you will collaborate with cross-functional teams to define product calculation requirements for new and existing products, and develop Excel-based models to support and validate those requirements, ensuring accurate and reliable values for our MassMutual customers. You will also support existing products during administration system conversions between administrative systems, maintaining data integrity and process continuity. Additionally, you will provide defect analysis and resolution to address system or calculation issues efficiently.
The Team
Our team blends advanced Excel modeling, annuity product expertise, actuarial knowledge, and strong communication and problem-solving skills. We prioritize critical thinking and process efficiency to stay focused on core responsibilities. By streamlining workflows and anticipating challenges we accelerate speed to market and resolve customer issues quickly. Through effective system solutions and empathetic solution-oriented communication we enhance customer experience and ensure timely delivery.
The Impact:
In this role, you will drive efficiency, collaboration, and innovation to improve speed to market and deliver exceptional customer outcomes. Key responsibilities include:
Own the development of models and requirements to ensure MassMutual customers receive accurate values from our systems and operational processes.
Take accountability for deliverables, working collaboratively with team members to complete tasks accurately and on time while following established coding structures and standards for Excel model development.
Plan and communicate effectively when multiple team members are working in the same excel model, ensuring coordination to avoid conflicts and maintain model integrity.
Communicate clearly with business partners, translating technical and non-technical information clearly and keeping stakeholders informed of status and deliverables.
Apply actuarial and statistical methods, leveraging tools and peers to when needed to enhance everyday work
Reduce costs through process improvements, automation, and strategic handoffs to business partners.
Navigate complexity and ambiguity. exploring multiple solutions while balancing the needs of the customer, actuarial functions, product, systems, operations, the field, legal, and compliance.
The Minimum Qualifications
BA or BS with a quantitative focus (e.g., Mathematics, Actuarial, Finance, Economics or related major)
5+ years of relevant work experience in insurance or financial services industry.
1+ years of Excel experience, including formulas (e.g., XLOOKUP), data validation.
The Ideal Qualifications
Completion of 1 or more actuarial exams
In-depth knowledge of MassMutual annuity products
Excel VBA
Experience writing SQL queries
Ability to optimize workflows for large data sets through advanced Excel techniques, macros or integration with other tools.
Experience supporting requirements and business testing for administrative system conversions.
Ability to take ownership of deliverables and collaborate effectively within a team environment.
General knowledge of annuity or related financial services industry products and practices.
Ability to work at both strategic and tactical levels, and switch between them as needed.
Strong business acumen, analytical, problem-solving, decision-making, and presentation skills.
What to Expect as Part of MassMutual and the Team
Regular meetings with the Product Modeling Team
Focused one-on-one meetings with your manager
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 nosiness with industry leading pay and benefits
#LI-ST1
Salary Range:
$121,800-$159,800At 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.