Data Analyst

Manulife; Montreal; On-site; CAD 69,000 - 117,000; Full time

Job summary

A leading financial services provider in Montreal is seeking a Data Analyst to manage and analyze data within their retirement solutions. Ideal candidates will have a degree in a related field and at least 5 years of experience. Proficiency in SQL and familiarity with Power BI are essential. This hybrid role offers competitive salary and a wide range of benefits.

Benefits

Health and dental benefits

Retirement savings plans

Generous paid time off

Qualifications

• 5 years’ experience in a data analysis/data engineering role preferred.
• Strong knowledge of SQL and data management practices.
• Ability to work both independently and collaboratively.

Responsibilities

• Build and manage data feeds for the Group Retirement systems.
• Develop automation processes to ensure data integrity.
• Produce dynamic reports to highlight customer insights.

Skills

Analytical thinking

Problem-solving skills

Bilingualism (English and French)

Education

Degree in Computer Science, Information Systems or related field

Tools

SQL (SSMS)

Power BI

Microsoft Azure

Job description

The Data Solutions Team, which primarily focuses on Manulife Canada's retirement data within Global Wealth and Asset Management, is seeking an analytical, proactive, and strategic thinker to join their team as a Data Analyst. Reporting to the director of Data Solutions.

The successful candidate will be responsible for extracting, managing, structuring and analyzing data used by Manulife's group retirement solutions. This role supports both existing and new initiatives and measures their long-term benefits to the business. Additionally, the candidate will play a crucial role in promoting data usage and availability, suggesting improvements, and supporting multiple data feeds.

Position Responsibilities

• Build and manage data feeds for the Group Retirement systems (MPS, Salesforce and more)

• Continually evolve understanding of information available in systems by working with key users of those systems.

• Support various business partners with data solutions that relate to key initiatives and test-and-learn activities

• Develop automation processes to extract, transform, and load the data to be used for customer behaviours and insights, ensuring data integrity and quality

• Produce dynamic reports (using data warehouse) highlighting customer insights to better drive sales, facilitate sales campaigns, and to be used in statistical analysis to identify key areas of opportunity across various inside sales teams

• Ad hoc automation, data extraction, and reporting projects as required

• Support the team in other activities: strategy, prioritization, data solutions, etc.

Required Qualifications

• Degree in Computer Science, Information Systems, or a related field / experience

• 5 years’ experience or more in a data analysis/data engineering role is preferred

• Advanced knowledge of SQL (SSMS),abricks

  >

Preferred Qualifications

• General knowledge of SSIS and/or other analytics languages (R, Python) would be an asset

• Expertise toward Canada retirement product.

• Knowledge of Microsoft Power Bi

• Familiar with Microsoft azure product

• Back-end knowledge of Manulife administrative system MPS (schema, tables, location of data points, process flow)

• Excellent analytical and problem-solving skills

• Ability to work both independently and closely with other squad members

• Proactive and inquisitive mindset, constantly looking for ways to improve existing processes and streamline activities

• Superior organizational skills: demonstrated ability to take initiative and establish priorities

• Excellent interpersonal and communication skills (verbal + written)

• Ability to work under deadlines

• Good project management skills

• Aptitude to accurately identify problems, assess business impact and suggest alternate courses of actions

• Bilingualism (English and French) is an asset. If the successful candidate is in Québec, proficiency in both languages will be required to support clients from various provinces outside of Quebec.

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.

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

$69,750.00 CAD - $116,250.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.