Business Analytics Specialist

Manulife Financial; Toronto; Hybrid; CAD 83,000 - 134,000; Full time

Job summary

A leading financial services company in Toronto is seeking a Business Analytics Specialist to define data-driven solutions for critical business challenges. The role involves transitioning SQL Server technologies to Azure Databricks and Power BI while collaborating with Agile teams. Candidates should have a strong background in business analytics with advanced SQL skills, along with experience in data visualization tools. This position offers a competitive salary range and a supportive work environment focused on development and inclusivity.

Benefits

Health insurance

Dental coverage

Wellness benefits

Retirement savings plans

Qualifications

• 3+ years of experience in a Business Analytics / Business Analyst role.
• Advanced proficiency in SQL is required.
• Experience with SSIS and SSRS support and development.

Responsibilities

• Become a data domain subject matter expert.
• Investigate & analyze new data sources and their connection to data models.
• Collaborate within Agile Kanban squads to deliver the roadmap.

Skills

Business Analytics

SQL

SSIS

SSRS

Power BI

Analytical problem-solving

Communication

Education

University/College degree in computer science, information technology, math, or related field

Tools

Azure Databricks

Microsoft BI stack

Job description

The Data Value Stream team is responsible for providing accurate data 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 Agile Kanban Business Analytics squads. They will support and transition from SQL Server data technologies, including Stored Procedures, SSIS packages, and SSRS reports to Azure Databricks Platform and Power BI reporting. The Business Analytics Specialist will be accountable for understanding the business across Group Benefits, translating requirements into agile stories and data views. 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.

Position Responsibilities:

• Become a data domain subject matter expert while expanding Group Benefits business acumen
• Investigate & analyze new data sources and how they connect to existing data models
• Collaborate/coordinate within Agile Kanban squads and business partners to deliver the Data Value Stream roadmap
• Support steady-state Microsoft SQL Server datasets, SSIS packages and SSRS reports
• Transition data and reporting to Azure Databricks/Power BI reports
• Develop and update technical documentation
• Support adhoc requests for data & visualization when required

Required Qualifications:

• 3+ years of experience in a Business Analytics / Business Analyst role
• University/College in computer science, information technology, math, or a related field
• Advanced proficiency in SQL
• Experience with SSIS and SSRS support and development
• Experience with Microsoft BI stack (including Analysis Services, Paginated Reports, Data Gateway, Power Pivot & Azure SQL)
• Analytical mind with a problem-solving aptitude
• Capable of adapting quickly, managing multiple demands & competing priorities, while delivering to deadlines
• Strong communication skills with the ability to collaborate effectively with cross-functional teams and stakeholders

Preferred Qualifications:

• Experience and business knowledge in Financial Services and/or Group Benefits is a valuable asset
• Experience with RLS & Embedded Power BI is an asset

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

#LI-hybrid

關於宏利和恒康

宏利金融公司是一家業界領先的國際金融服務商，致力於幫助人們實現「輕鬆投資理財，樂享豐盛人生」。若要進一步了解我們，請瀏覽 https://www.manulifeim.com/institutional/tw/en。

宏利是平等機會僱主

在宏利／恒康，我們擁抱多元。我們致力於吸引、培養及挽留和所服務客戶同樣多元的員工，並從而營造包容的工作環境，接納文化和個體差異。我們矢志維持公平的招聘、挽留、晉升及薪酬制度，我們管理的所有實踐及項目不會因種族、血統、原籍地、膚色、族裔、國籍、宗教或宗教信仰、信仰、性別（包括懷孕及其相關情況）、性取向、遺傳特徵、退伍軍人身份、性別認同、性別表達、年齡、婚姻狀況、家庭狀況、殘疾或受適用法律保護的任何其他因素而區別對待。

我們的首要任務是消除障礙，為員工提供平等就業機會。人力資源部代表將盡力為應徵過程中提出要求的申請人提供合理協助。申請人要求提供協助所分享的信息將會按照適用法律及宏利／恒康政策儲存及使用。申請過程中如需協助，請聯絡 [e-mail]。

Referenced Salary Location

Toronto, Ontario

Working Arrangement

混合式

Salary range is expected to be between

$83,400.00 CAD - $133,400.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.