PlanSmart Data Analyst

About the Role and Company

Join MetLife, the largest non-medical group insurance carrier in the nation, serving over 55,000 customers and more than 50 million employees and their families. As part of the Group Benefits team, you will help deliver innovative solutions in life, disability, dental, vision, and voluntary benefits tailored to modern employers and their workforces. Collaborate with customers, brokers, and partners to expand offerings and enhance digital experiences. MetLife is dedicated to supporting customers when they need assistance most.

Opportunity Overview

The PlanSmart Data Analyst plays a pivotal role supporting a designated book of business by validating and transforming data, managing workflows to ensure regulatory compliance around conversion and portability notifications for group customers. This role is essential for enabling timely, accurate participant outreach through consolidating and clarifying data from multiple sources.

Key Responsibilities

• Handle daily operational tasks including processing, managing inbox traffic, performing file audits, data reconciliation, and executing end-of-day protocols.
• Evaluate incoming files to verify accuracy, completeness, and compliance with regulations.
• Develop and update file configuration documents to onboard and integrate new customers effectively.
• Produce reporting outputs that initiate outreach actions for PlanSmart Specialists.
• Detect operational inefficiencies and spearhead continuous improvements to systems, processes, and workflows ensuring scalability.
• Act as a workflow Subject Matter Expert by collaborating with internal teams to identify and resolve data discrepancies.

Qualifications

• Experience in roles involving data analysis, processing, or operational reporting.
• Advanced skills in Microsoft Excel, including use of formulas, lookups, and data manipulation techniques.
• Ability to analyze complex datasets with great precision and attention to detail.
• Strong analytical problem-solving abilities combined with a mindset geared towards continuous improvement.
• Comfortable operating multiple systems, tools, and databases concurrently.
• Skilled in critical thinking to assess data, gauge impacts, and make decisions that optimize workflows.
• Preferred: Bachelor's degree or equivalent relevant experience.
• Preferred: Experience handling large datasets and automating workflows using tools like Power Automate or reporting software.
• Preferred: Background in operational or process improvement initiatives.
• Preferred: Project coordination capabilities to manage timelines and deliverables efficiently.
• Preferred: Excellent communication skills, including the ability to convey data insights clearly to leadership and stakeholders.

Location and Work Arrangement

This position is hybrid, requiring at least three days per week onsite in Charlotte, NC.

Compensation and Benefits

The anticipated salary range is $54,100 to $72,100 annually. This role may also qualify for annual short-term incentive bonuses and stock-based long-term incentives, subject to plan terms. MetLife offers comprehensive benefits addressing physical, mental, financial wellbeing, and family support. Benefits include medical, prescription drug, vision and dental coverage, disability insurance at no cost, company-paid life insurance, legal services, retirement pension fully funded by MetLife, 401(k) with company matching, voluntary insurance discounts (auto, home, pet, critical illness, hospital indemnity, accident), Employee Assistance Program, mental health resources, parental leave, volunteer time off, tuition assistance, and more.

Equal Employment Opportunity and Compliance

MetLife is an Equal Opportunity Employer committed to fair hiring without regard to race, gender, sexual orientation, religion, disability, veteran status, and other protected categories. Accommodations for disabilities during the application process are available upon request and handled confidentially. The company maintains a drug-free workplace and complies with all employment laws, including Massachusetts regulations prohibiting lie detector tests as employment conditions.