Data and Systems Analyst

Company 1; Toronto; Hybrid; CAD 75,000 - 141,000; Full time

Job summary

A leading financial services provider in Toronto is seeking an experienced finance data professional to manage data flow for actuarial processes. The role involves troubleshooting data issues, performing quality assurance, and collaborating with IT and finance stakeholders. Candidates should have at least 7-10 years of industry experience and strong skills in SQL and data visualization tools. Flexible work arrangements are available, and the salary ranges from CAD 75,880 to CAD 140,920.

Benefits

Health insurance

Retirement savings plans

Mental health benefits

Flexible work arrangements

Qualifications

• Minimum 7-10 years of experience in the financial services industry.
• Ability to communicate effectively with technical and finance professionals.
• Demonstrates a commitment to delivering excellent service.

Responsibilities

• Provide ad hoc data support to troubleshoot data quality issues.
• Perform quality assurance and testing in cross-functional teams.
• Translate business requirements into technical requirements.

Skills

Strong analytical and problem solving skills

Strong knowledge of SQL

Data visualization tools (Power BI, Qlik)

Proactive and results oriented

Excellent organization and time management

Education

Bachelor's degree

Tools

Microsoft Access

Tableau

SAS

Job description

Overview

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.

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.
• Bachelors 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 a 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 will support you in shaping the future you want to see.

We will empower you to learn and grow the career you want.

We will 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 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 .

Salary and Location

Location: Toronto, Ontario (Hybrid)

Salary range: 75880.00 CAD - 140920.00 CAD

If you are applying for this role outside of the primary location, please contact 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.

Benefits

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 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 for more information about U.S.-specific paid time off provisions.

Key Skills

Data Analytics, Microsoft Access, SQL, Power BI, Qlik, Tableau, Data Visualization, Data Management, Data Mining, SAS, Data Analysis Skills, Analytics

Employment Details

Employment Type: Full-Time

Experience: years

Vacancy: 1