Data Analyst, Plan Member Administration (PMA)

Manulife; Kitchener; Hybrid; CAD 58,000 - 98,000; Full time

Job summary

A leading financial services provider is seeking a detailed-oriented Data Analyst in Kitchener, Canada. The role involves managing and optimizing data processes for plan sponsor onboarding and administration. Candidates should have 3-5 years of experience in data analysis and a strong proficiency in Microsoft Excel. A flexible hybrid work environment and comprehensive benefits are offered.

Benefits

Health insurance

Dental insurance

Mental health benefits

Retirement savings plans

Paid time off

Qualifications

• 3–5 years of experience in data analysis or data management.
• Experience working with large datasets and data cleaning.
• Strong Excel skills including pivot tables and data validation.

Responsibilities

• Clean and organize incoming plan member data.
• Collaborate with clients to clarify data requirements.
• Conduct audits and data comparisons for accuracy.
• Troubleshoot data-related issues during onboarding.
• Improve data workflows with internal teams.

Skills

Data analysis

Data management

Microsoft Excel

Communication skills

Education

Post-secondary education in Data Analytics or related field

Job description

The Plan Member Administration (PMA) team is seeking a detail-oriented and technically skilled Data Analyst to support the team in managing and optimizing data processes for plan sponsor onboarding and ongoing administration. This role plays a critical part in ensuring data integrity and operational excellence, directly contributing to our mission of delivering high-quality service to our clients. You’ll work in a dynamic, collaborative environment where your expertise in data and communication will help shape the future of PMA operations.

Position Responsibilities

• Clean, validate, and organize incoming plan member data from plan sponsors to ensure readiness for system ingestion.
• Collaborate with clients to clarify data requirements and provide guidance on formatting and submission standards.
• Conduct audits and data comparisons across multiple systems to ensure consistency and accuracy.
• Support troubleshooting and resolution of data-related issues during onboarding and amendment processes.
• Partner with internal teams to improve data workflows and contribute to process enhancements.

Required Qualifications

• Minimum 3–5 years of experience in data analysis or data management roles.
• Proven experience working with large datasets and data cleaning processes.
• Advanced proficiency in Microsoft Excel (e.g., pivot tables, formulas, data validation).
• Post-secondary education in a related field (e.g., Data Analytics, Business, Information Systems).
• Strong verbal and written communication skills, with experience in client-facing roles.

Preferred Qualifications

• Experience in Group Benefits or insurance industry.
• Familiarity with data ingestion processes and system integrations.
• Knowledge of data auditing and reconciliation techniques.
• Ability to manage multiple priorities and meet tight deadlines.
• Demonstrated initiative, problem-solving skills, and attention to detail.

When you join our team

• We’ll empower you to learn and grow the career you want.
• We’ll recognize and support you in a flexible environment where well-being and inclusion are more than just words.
• As part of our global team, we’ll support you in shaping the future you want to see.

#LI-HYBRID

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better. To learn more about us, visit https://www.manulife.com/en/about/our-story.html.

Manulife is an Equal Opportunity Employer

At Manulife/John Hancock, we embrace our diversity. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies. To request a reasonable accommodation in the application process, contact [e-mail].

Referenced Salary Location

Montreal, Quebec

Working Arrangement

Hybrid

Salary range is expected to be between

$58,275.00 CAD - $97,125.00 CAD

If you are applying for this role outside of the primary location, please contact [e-mail] for the salary range for your location. The actual salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance.

Manulife offers eligible employees a wide array of customizable benefits, including health, dental, mental health, vision, short- and long-term disability, life and AD&D insurance coverage, adoption/surrogacy and wellness benefits, and employee/family assistance plans. We also offer eligible employees various retirement savings plans (including pension and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in Canada includes holidays, vacation, personal, and sick days, and we offer the full range of statutory leaves of absence. If you are applying for this role in the U.S., please contact [e-mail] for more information about U.S.-specific paid time off provisions.