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
•    Bachelor’s degree in Computer Science, Finance, Mathematics, or a related field
•    2–5 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: 

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

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

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