Data Analyst Business Intelligence Developer

The Actuarial Systems Data & Reporting team is looking for a Business Intelligence Analyst to help support US actuarial reporting data analysis and reporting modernization work. This role will work closely with the US Reporting Steward Actuarial teams and Global Systems & Data partners to understand business needs investigate data issues and deliver practical reporting solutions.

The work will include querying and analyzing data using SQL Qlik and Power BI; improving existing reports and controls; and helping build new solutions that support Quarter-end and Year-end valuation processes. The role will also help manage change requests by supporting intake prioritization tracking and follow-up through JIRA.

Position Responsibilities:

Technical (Data Analytics and Reporting)

Write review and optimize SQL queries to pull transform and validate large datasets from warehouse and data lake environments
Review Quarter-end and Year-end valuation data to identify trends explain variances and investigate data anomalies
Build and maintain data models that support QlikView and Power BI reporting
Create and improve dashboards used for reporting reconciliations and variance analysis
Validate and reconcile data across source systems reporting layers and downstream outputs
Help automate recurring data checks and controls to improve accuracy and reduce manual effort
Troubleshoot data issues by tracing logic across ETL steps source data and reporting dependencies
Support SIT and UAT by validating results documenting findings and confirming that business requirements are met
Document data lineage and source-to-target mappings so logic is clear traceable and audit-ready
Work with platforms such as Azure SQL Data Lake and Databricks as part of reporting and data analysis work
Use Python where helpful for analysis automation or repeatable data checks

Project / Change Management / Coordination

Work with business and technical teams to turn reporting needs into clear actionable requirements
Help manage enhancement requests in JIRA including intake prioritization tracking and follow-up
Participate in Agile ceremonies such as backlog refinement sprint planning and status updates
Coordinate SIT and UAT activities with business users developers and other partners
Communicate data issues clearly explain the impact and help identify practical next steps
Support release readiness deployment validation and post-release checks
Look for opportunities to simplify reporting processes reduce manual work and improve controls
Keep documentation current for requirements testing decisions and governance needs

Required Qualifications:

Technical Skills & Experience
Bachelors degree in Computer Science Finance Mathematics or a related field
25 years of hands-on experience writing SQL queries and working with large datasets
Good understanding of data warehousing concepts ETL processes and how data moves through reporting layers
Experience building or supporting reports in QlikView Power BI or similar BI tools
Ability to analyze data investigate issues and explain findings clearly
Exposure to Azure SQL Data Lake or Databricks is helpful
Python or a similar scripting language is preferred especially for automation or repeatable analysis
Comfortable turning business questions into data analysis reporting logic or dashboard requirements

Project Collaboration & Delivery
Strong communication skills and ability to work with both business and technical partners
Experience working in an Agile environment or supporting sprint-based delivery
Familiarity with JIRA or a similar tool for tracking work and managing requests
Experience supporting SIT UAT or other testing and validation cycles
Ability to manage multiple priorities especially during Quarter-end and Year-end reporting periods
Proactive practical and willing to look for better ways to get the work done

Preferred Qualifications:

Exposure to actuarial finance or regulatory reporting environments
Experience supporting data modernization or reporting transformation initiatives
Understanding of data governance controls audit requirements or traceability needs

When you join our team:

Well empower you to learn and grow the career you want.
Well recognize and support you in a flexible environment where well-being and inclusion are more than just words.
As part of our global team well support you in shaping the future you want to see.

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 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 .

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 for the salary range for your location.

Manulife/John Hancock 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/401(k) savings plans and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in the U.S. includes up to 11 paid holidays 3 personal days 150 hours of vacation and 40 hours of sick time (or more where required by law) each year and we offer the full range of statutory leaves of absence.

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.

Know Your Rights I Family & Medical Leave I Employee Polygraph Protection I Right to Work I E-Verify