Data and Systems Analyst

Manulife; Waterloo; Hybrid; CAD 75,000 - 141,000; Full time

Job summary

A leading financial services provider in Waterloo is seeking an experienced professional to join their Finance Data team. The role involves managing data flows for actuarial processes and ensuring data accuracy. The ideal candidate has 7-10 years in financial services and strong skills in SQL and data analysis. This position offers a hybrid work environment and competitive compensation in Canada, with a salary range between CAD 75,880 and CAD 140,920.

Benefits

Health and dental benefits

Mental health and wellness benefits

Generous paid time off program

Qualifications

• Minimum 7-10 years of experience in the financial services industry.
• Proactive and results oriented with a focus on accountability.

Responsibilities

• Provide ad hoc data support to troubleshoot data quality issues.
• Perform quality assurance and testing with cross-functional teams.
• Support quarterly ETL production processes generating financial data.

Skills

Strong analytical and problem solving skills

Strong knowledge of SQL

Ability to communicate effectively

Excellent organization and time management skills

Highly collaborative working style

Education

Bachelor's degree

Tools

Power BI

Qlik

Job description

The Finance Data team is responsible for managing the data flow required to support actuarial modeling, reserve valuation, experience analysis and in-force management activities for Long Term Care (LTC) and Fixed Products (FP).

This individual will work with IT professionals and John Hancock actuaries on projects and processes that deliver high quality and reliable data that meets business needs. The main priorities are to ensure data accuracy, minimize data delivery time, and enhance quality control infrastructure.

Position Responsibilities:

• Provide ad hoc data support to troubleshoot data quality issues, perform systems analysis and workflow analysis, identify root causes, and evaluate and communicate alternative solutions.

• Perform quality assurance and testing, working collaboratively as a part of large cross-functional teams, ensuring business requirements and specifications are fulfilled.

• Support quarterly ETL production processes generating financial data and reporting. Build, improve and execute data quality validation, lineage research, and impact analysis.

• Act as liaison between multiple internal areas - actuarial, operations, and IT - for the development and implementation of new processes and systems, and the enhancement of existing ones.

• Translate business and user requirements into technical requirements, develop business requirement documents and specifications, mainly in SQL.

• Succinctly summarize findings from data analysis, document business issues, and communicate with stakeholders to arrive at optimal solutions.

Required Qualifications:

• Minimum 7-10 years of experience in the financial services industry.

• Bachelor’s degree.

• Strong analytical and problem solving skills.

• Strong knowledge of a data querying language such as SQL, Power BI, Qlik or similar reporting tools.

• Strong desire to improve processes.

• Ability to communicate effectively with actuaries and IT professionals.

• Outstanding ability to manage competing priorities in a dynamic, fast-paced environment while demonstrating sound judgment.

• Excellent organization and time management skills.

• Energetic personality with positive, can-do attitude.

• Role model of ethics and integrity who builds a culture of respect.

• Highly effective change agent who leads and embraces change.

• Proactive and results oriented; highly focused on accountability.

• Demonstrates a commitment to delivering excellent service balanced with appropriate risk management.

• Highly collaborative working style.

Preferred Qualifications:

• Prior knowledge of Long Term Care or Fixed products / life insurance industry preferred.

When you join our team:

• As part of our global team, we’ll support you in shaping the future you want to see.

• 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.

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

Toronto, Ontario

Working Arrangement

Hybrid

Salary range is expected to be between

$75,880.00 CAD - $140,920.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.