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.

Referenced Salary Location
Boston, Massachusetts

Working Arrangement

Hybrid

Salary range is expected to be between
$80,625.00 USD - $134,375.00 USD

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 [redacted] 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.

Company: John Hancock Life Insurance Company (U.S.A.)