Business Analytics Specialist

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 acumenInvestigate & analyze new data sources and how they connect to existing data modelsCollaborate/coordinate within Agile Kanban squads and business partners to deliver the Data Value Stream roadmapSupport steady-state Microsoft SQL Server datasets, SSIS packages and SSRS reportsTransition data and reporting to Azure Databricks/Power BI reportsDevelop and update technical documentationSupport adhoc requests for data & visualization when requiredRequired Qualifications: 3+ years of experience in a Business Analytics / Business Analyst roleUniversity/College in computer science, information technology, math, or a related fieldAdvanced proficiency in SQLExperience 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 aptitudeCapable of adapting quickly, managing multiple demands & competing priorities, while delivering to deadlinesStrong communication skills with the ability to collaborate effectively with cross-functional teams and stakeholdersPreferred Qualifications: Experience and business knowledge in Financial Services and/or Group Benefits is a valuable asset Experience with RLS & Embedded Power BI is an assetWhen 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 About Manulife and John HancockManulife 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 EmployerAt 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.Referenced Salary LocationToronto, OntarioWorking ArrangementHybridSalary range is expected to be between$86,100.00 CAD - $136,100.00 CADIf 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.