Business Intelligence Developer

Manulife; Toronto; On-site; CAD 71,000 - 120,000; Full time

Job summary

A global financial services provider in Toronto is seeking a Data and Reporting Analyst to enhance their data ecosystem. The successful candidate will collaborate closely with business partners, utilize tools like SQL and PowerBI, and drive data-driven decision making. Offering a hybrid work arrangement, this role provides the opportunity to work on strategic projects that add long-term value to the organization.

Benefits

Customizable health and dental benefits

Retirement savings plans

Generous paid time off

Qualifications

• Must have experience with SQL server and business intelligence tools.
• Proficiency in Microsoft Excel is required.
• Ability to communicate professionally across all levels of the organization.

Responsibilities

• Conduct business analysis and develop use cases to support decision making.
• Contribute to the design and build of data models for reporting.
• Collaborate with business partners to understand their needs.

Skills

SQL server

Business intelligence tools

Microsoft Excel

Salesforce

Agile experience

French language

Tools

Tableau

PowerBI

Qliksense

Alteryx

Job description

John Hancock Manulife Investment Management is a world-class provider of asset management and investment strategies.The Global Business Intelligence Team, as part of the wider Global Retail Sales Enablement Function, is responsible for providing in-depth analysis, commentary and reporting solutions that can surface insight for a variety of key partners across the business, including senior management, sales leadership, wholesalers, marketing, product and finance.

We support a range of analytics initiatives and right now we are modernizing how data flows into, through and around our reporting environment, to enable a scalable, sustainable data‑eco system -underpinning insight and decision making across the business.

The Role

This role will be primarily responsible for helping shape the future of our data and reporting eco system by understanding the business needs and assessing the processes, means and solutions to achieve this. You’ll work closely with our key partners and consumers data, as well as collaborating with our technology teams, to scope and understand the requirements and play a key role in establishing the design and approach for the appropriate delivery method or solution. As part of this end‑to‑end delivery, the BI developer and Analyst on our team will build out the data pipelines, processes or full reporting solutions depending on the needs of the project.

You will work across transformation projects to structure, model and integrate data into a coordinated framework and data model that can enable the detailed sales and CRM reporting supported by the team. In some cases you will take ownership of development; in others you will be supported by SMEs in the technology and AI teams as well - to deliver solutions aligning to the business’s strategic data roadmap. Ultimately, your work will help connect business needs, data sources, processes and reporting together into a solid foundation that will create long term value in the business.

The Successful Candidate

The successful candidate for this position will be an analytical thinker, that can combine technical ability with curiosity and problem‑solving instinct. Have a general understanding of financial services /operations, and strive to deliver solutions that drive commercial impact. You’ll be proactive and adaptable, with ability to understand the business context of the data and the technical delivery of solutions, asking the right questions and exploring how data and process improvements can contribute value.

Confident of learning an evolving business environment, where transformation is ongoing and technology can help shape business operations by becoming data driven. Strong partner engagement and a focus on delivering value will be key to prioritizing high impact work, building relationships with our partners and owning projects.

Position Responsibilities

Discovery & Analysis

• Business Analysis and Use Case Development for Identifying where data can support decision making
• Understand where improvements can be made to existing workflows and close data gaps
• Work with BI manager and analysts to understand business operations and assess data struggles and opportunities
• Comfortable with ambiguity and possess a “figure it out” mentality

Design & Development

• Contribute to the design, build and maintenance of efficient data models / datasets to be used in PowerBI, salesforce, Tableu
• Developing reusable KPIs in our data and enable self service capabilities for dashboard and reporting solutions

Partnering & Collaboration

• Collaborate and build strong working relationships with business partners/vendors
• Understand what the various business functions we support need and work with tech on delivering solutions.
• Ability to influence and negotiate to meet project deadlines

Required Qualifications

• SQL server and/or business intelligence reporting tools (Tableau, PowerBI, Qliksense, alteryx)
• Microsoft Office, particularly with Excel, as well as Visio and other process mapping tools
• Salesforce and Agile expereince.
• Must be able to communicate and interface professionally vertically and horizontally across the organization
• Knowledge of French can be beneficial for collaborating with French‑speaking sales regions

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

Toronto, Ontario

Working Arrangement

Hybrid

Salary range is expected to be between

$71,925.00 CAD - $119,875.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.