Business Analytics Specialist

We are a leading financial services provider committed to making decisions easier and lives better for our customers and colleagues around the world. From our environmental initiatives to our community investments, we lead with values throughout our business. To help us stand out, we help you step up, because when colleagues are healthy, respected and meaningfully challenged, we all thrive. Discover how you can grow your career, make impact and drive real change with our Winning Team today.

Hybrid

Job Description

Business Analytics Specialist | GB Business Analytics & Advice – Sponsor Analytics/Insights as a Product

The Insights as a Product team is responsible for providing accurate data, visualization, and business analytics across the Group Benefits organization and our customers. The Business Analytics Specialist will play a key role in defining data driven solutions to tackle business area problems, tracking down & understanding new data sources, while having the opportunity to collaborate with members of a highly engaged Agile Kanban Business Analytics squad in Group Benefits.

The Business Analytics Specialist will be accountable for understanding the business needs of our Product & Platforms team, translating requirements into agile stories, data views, insightful dashboards that tell a story, while applying BI/UX standard methodologies. They will be actively engaged in our analytics development cycle from an ideation/requirements/testing perspective, while also investigating data issues and answering data inquiries from our business partners. These interactive solutions will range from simple one-page dashboards to multi-page story telling packages with complex benchmarking.

Responsibilities

• Design and define requirements for Power BI solutions (simple to complex) with multiple data source connections including Azure data lake & SSAS
  • Create user stories
  • Test/validate newly developed Power BI items

• Develop Proof of Concept Business Analytics reports/dashboards, gathering feedback for enhancements
• Become a data domain authority while expanding Group Benefits eye for business
  • Investigate & analyze new data sources and how they connect to existing data models
• Collaborate/coordinate with the Agile Kanban squad and business partners to deliver the Sponsor Analytics roadmap
• Support steady-state Power BI reports
• Develop and update user documentation
• Support adhoc requests for data & visualization when required
Assist with end-user training as needed

• 
  

What motivates you?

• You obsess about customers, listen, engage and act for their benefit
• You think big, with curiosity to discover ways to use your agile approach and enable business outcomes
• You thrive in teams and enjoy getting things done together
• You take ownership and build solutions, focusing on what matters
• You do what is right, work with integrity and speak up
• You share your humanity, helping us build a diverse and inclusive work environment for everyone

What we are looking for

• Demonstrable experience in a Business Analytics / Business Analyst role; 3+ years of innovative Power BI report development
• University/College in computer science, information technology, math or a related field
• Experience in creating user stories & requirements in an Agile environment
• Experience transforming chaotic reporting processes into understandable Business Analytics solutions
• Advanced proficiency in SQL
• Experience with data visualization, storytelling, data modeling & UX standard methodologies
• Experience with Microsoft BI stack (including Analysis Services, Paginated Reports, Data Gateway, Power Pivot & Azure SQL)
• Experience with Microsoft Power Query, M, DAX & SQL
• Experience with Data Lakes, Data Warehousing & Data Marts
• Experience with RLS & Embedded Power BI is an asset
• Experience working with SSAS data models is an asset
• Experience with SSRS development is an asset
• Proven abilities to take initiative and be innovative
• Analytical mind with a problem-solving proficiency
• Capable of adapting quickly, managing multiple demands & competing priorities, while delivering to deadlines
Experience and business knowledge in Financial Services and/or Group Benefits is a valuable asset

• 
  

What can we offer you?

• A competitive salary and benefits packages
• A growth trajectory that extends upward and outward, encouraging you to follow your passions and learn new skills
• A focus on growing your career path with us
• Flexible work policies and strong work-life balance
• Professional development and leadership opportunities

Hybrid Role in Waterloo/Toronto, Ontario

Attributes

• Curious, creative & innovative
• Excellent oral and written communication skills
• Customer service focused
• Learn and adapt quickly
• Strong analytical and problem-solving skills
• Strong multi-tasking skills, receptive to change
• Strong leadership and influencing skills
• Works well under time constraints/pressure
• Attention to details and quality
• Highly collaborative and results-oriented
• Ability to work independently, and with others in a flexible environment

Location: Waterloo/Toronto, Ontario

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services group that helps people make their decisions easier and lives better. With our global headquarters in Toronto, Canada, we operate as Manulife across our offices in Asia, Canada, and Europe, and primarily as John Hancock in the United States. We provide financial advice, insurance, and wealth and asset management solutions for individuals, groups and institutions. At the end of 2022, we had more than 40,000 employees, over 116,000 agents, and thousands of distribution partners, serving over 34 million customers. At the end of 2022, we had $1.3 trillion (US$1.0 trillion) in assets under management and administration, including total invested assets of $0.4 trillion (US $0.3 trillion), and segregated funds net assets of $0.3 trillion (US$0.3 trillion). We trade as ‘MFC’ on the Toronto, New York, and the Philippine stock exchanges, and under ‘945’ in Hong Kong.

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 recruitment@manulife.com .

The annual base salary for this role is listed below.

Waterloo, Ontario

Salary range is expected to be between

$74,270.00 CAD - $137,930.00 CAD

If you are applying for this role outside of the primary location, please contact recruitment@manulife.com 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 recruitment@manulife.com for more information about U.S.-specific paid time off provisions.