Join our LCG Operations & Strategy analytics team to build, enhance and maintain the analytics, dashboards and data foundations teams and leaders use to run the business every day. You’ll turn complex data from our Azure data lake into clear, automated Power BI visualizations and insights that drive decisions, unlock efficiencies, and strengthen governance. In this role, you’ll own end‑to‑end solutions—from designing new tables and SQL logic to managing permissions across Power BI and SharePoint—while applying Python for deeper analytical and forecasting methods. You’ll also explore and apply emerging Generative and Agentic AI tools to accelerate insight generation, automate repeatable analytics tasks, as well as enhance dashboard and data development and quality assurance workflows. You’ll gain broad exposure to senior stakeholders, modern Azure tooling, and best‑in‑class delivery practices in a supportive, global hybrid work environment.
Position Responsibilities:
Partner with Stakeholders to develop intuitive, user-based solutions that resonate with and are embraced by non-technical users. Leveraging strong communication skills and a growth mindset to ensure solutions address both macro and micro perspectives is critical. Specific elements of these solutions include:
Building, enhancing, and automating advanced Power BI dashboards, optimizing data models/DAX, refresh pipelines, and deployment pipelines; implement and maintain row‑/object‑level security.
Adapting dashboards based on stakeholder’s analytics needs and continuous maintenance of the analytics and technology stream assets.
Performing data preprocessing, transformation, and analysis across multiple sources/datasets to develop comprehensive, insight‑driven dashboards that support effective decision‑making for senior leadership.
Designing and creating new tables and views; write performant SQL to model, transform, and validate data sourced from the Azure data lake (e.g., ADLS Gen2) for analytics use.
Developing reliable automations (e.g., data refresh orchestration, parameterized datasets, alerting) and establish monitoring to ensure dashboard/data SLAs.
Managing permissions and access controls across Power BI workspaces/datasets/reports and SharePoint sites/libraries to meet least‑privilege and audit requirements.
Using Python (pandas, scikit‑learn, notebooks) for advanced analytics such as forecasting, segmentation, anomaly detection, and feature engineering, package findings into reusable assets.
Leveraging Generative AI tools (e.g., Copilot, Azure OpenAI) to accelerate analysis, generate documentation, support exploratory analytics, and streamline development workflows.
Identifying opportunities to embed GenAI-driven automation into data pipelines, reporting processes, and stakeholder deliverables.
Using GenAI-based assistants to enhance SQL, Python, and Power BI development efficiency while maintaining governance and quality standards.
Developing and leading requirements gathering, workshops and training sessions for the development and implementation of relevant solutions that incorporate change enablement and user design principles
Required Qualifications:
4 - 5 years of professional experience in data analytics or business intelligence.
4+ years building advanced Power BI solutions (data modeling, complex DAX, Power Query, RLS/OLS, deployment pipelines).
4+ years writing SQL (joins, window functions, performance tuning) and 3+ years working in an Azure data lake environment.
Demonstrated experience creating new tables/views and preparing curated datasets for reporting and analysis.
Proven track record automating dashboards (e.g., scheduled refreshes, pipeline‑based deployments, alerts) and managing permissions at workspace/dataset/report levels.
Experience administering SharePoint sites and managing permissions (site/library access, groups, links, sensitivity).
Proficiency with Python for analytics (data wrangling, modeling, visualization) and documenting code/notebooks.
Bachelor’s degree in data/computer science, Engineering, Analytics, or a related field.
Familiarity with Generative AI tools and workflows (e.g., Microsoft Copilot, Azure OpenAI, ChatGPT) to accelerate analytics, prototyping, or documentation.
Demonstrated stakeholder management and engagement skills: translating business needs and questions into data and analytical requirements and delivering clear, actionable visualizations and insights.
Flexibility to work outside of regular work hours as required to accommodate needs of global stakeholders
Preferred Qualifications:
Experience with Azure analytics services (e.g., Fabric, Synapse, Databricks), Delta/Parquet formats, and lakehouse patterns.
Familiarity with data governance and cataloging (e.g., Purview), data quality validation, and lineage documentation.
CI/CD practices for BI (source control with Git/Azure DevOps, environment promotion, release management).
Exposure to Power Automate or orchestration tools for BI/ops automation, comfort with REST APIs for admin tasks.
Experience using GenAI tools to enhance BI development, create automated documentation, or accelerate code and data model generation.
Understanding of prompt engineering concepts and how to safely apply GenAI in enterprise data environments.
Experience designing centralized solutions that address the needs of global teams with differing constraints and perspectives
When you join our team:
We’ll empower you to learn and grow your skills. You'll gain hands‑on exposure to enterprise‑grade GenAI as we integrate GenAI into our analytics operating model.
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 a future oriented operating model.
#LI-Hybrid
The role being advertised is an existing vacancy.
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 [email protected] .
Referenced Salary Location
Toronto, Ontario
Hybrid
Salary range is expected to be between
$62,850.00 CAD - $104,750.00 CAD
Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance. 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. If you are applying for this role outside of the primary location, please contact [email protected] for the salary range for your location.
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 [email protected] for more information about U.S.-specific paid time off provisions.
We use data and analytics technologies, such as artificial intelligence (AI), and automated processing tools, to analyze and process the information you provide to us or third parties in the application process. For more information, please refer to our personal information collection statement .
