Business Analyst - Actuarial System and Data

The Actuarial System Data and Reporting team is seeking a highly skilled and motivated Business Analyst to join our group. This person will partner closely with the US Reporting Steward and act as a key liaison between the US Actuarial teams and the Global Systems & Data organization to ensure our reporting needs are met.

This role is responsible for managing and tracking change‑management tickets and implementations, supporting prioritization discussions, and partnering with developers to assess business requirements for ongoing system enhancements. It also involves working with data tools such as SQL, QlikView, and Power BI to query the data warehouse, perform meaningful analyses, and develop solutions that strengthen Valuation processes during Quarter‑End and Year‑End cycles. The ideal candidate brings strong project‑coordination and communication skills, a solid understanding of enterprise data structures and data‑warehouse concepts, proficiency with SQL and business intelligence tools, and a passion for improving processes, automating workflows, and generating insights that drive operational excellence.

Position Responsibilities:

• Serve as a coordination point between Actuarial Associates, business partners, and technical teams, ensuring actuarial data requirements are clearly understood, documented, and translated into actionable technical specifications.

• Support the change‑management process, including collecting enhancement requests, validating business needs with actuarial collaborators, organizing requirements, and ensuring proper documentation.

• Manage and track JIRA tickets end‑to‑end, from intake, requirements clarification, and developer assessment through to prioritization, testing, and final implementation, while maintaining clear communication with actuarial teams.

• Collaborate closely with development teams (ETL, data engineering, reporting, QA) to clarify requirements, and accurate delivery of data solutions.

• Support SIT (System Integration Testing), UAT (User Acceptance Testing), and regression testing by preparing test cases, coordinating with actuarial reviewers, validating results, and tracking defects through closure.

• Develop, optimize, and maintain SQL queries or python programs to extract, validate, and transform actuarial data from the data warehouse for analysis, testing, and issue investigation.

• Design and maintain analysis dashboards in Power BI or any realted tools to enhance access to actuarial metrics, and provide better analytical insights.

• Continuously improve actuarial data processes and best practices, promoting consistency, reducing manual effort, and strengthening data accuracy, integrity, and governance.

Required Qualifications:

• University degree in Finance, Business, Computer Science, Mathematics, or a related field

• 2–4 years of experience in project coordination or project management, including hands‑on experience managing Jira or similar change‑management tools

• Demonstrated ability to work effectively with multiple cross‑functional teams, including actuarial, systems, and data engineering groups

• Effective communication and collaboration skills, with the ability to support Actuarial Associates and other business partners

• 2–3 years of practical experience with SQL, including writing complex queries and working with large datasets

• Experience with data visualization tools such as QlikView or Power BI to develop and maintain reporting dashboards

• Strong analytical and problem‑solving skills with the ability to derive insights and support decision‑making

• Ability to work independently while contributing effectively in a team environment

Preferred Qualifications:

• Experience with Python or R for data analysis is preferred but not required

• Knowledge of data warehousing concepts, ETL workflows, and data modeling best practices 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

If you are applying to this role in Massachusetts, please note the salary range is $61,875 - $103,125 USD. Additionally, employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance.

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

Salary range is expected to be between

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.