Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

This role supports US actuarial reporting, data analysis, and reporting modernization. You will collaborate with business and technical teams to understand needs, investigate data issues, and deliver practical reporting solutions, including querying data, improving reports, and building new solutions for valuation processes. You will also manage change requests through JIRA.

Responsibilities

• Write, review, and optimize SQL queries to pull, transform, and validate large datasets.
• 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 for reporting, reconciliations, and variance analysis.
• Validate and reconcile data across source systems, reporting layers, and downstream outputs.
• 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 business requirements are met.
• Document data lineage and source-to-target mappings for clarity, traceability, and audit readiness.
• Work with platforms such as Azure SQL, Data Lake, and Databricks for reporting and data analysis.
• Use Python for analysis, automation, or repeatable data checks.
• Turn reporting needs into clear, actionable requirements by working with business and technical teams.
• 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 their impact, and help identify practical next steps.
• Support release readiness, deployment validation, and post-release checks.
• Identify opportunities to simplify reporting processes, reduce manual work, and improve controls.
• Keep documentation current for requirements, testing, decisions, and governance needs.

Requirements

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

Skills

• SQL
• Qlik
• Power BI
• JIRA
• Azure SQL
• Data Lake
• Databricks
• Python
• Agile

Location

• Boston, Massachusetts

Work Type

• Hybrid

Experience Level

• 2-5 years

Education Level

• Bachelor's degree

Salary/Compensations

• $80,625.00 USD - $134,375.00 USD

Benefits

• Health insurance
• Dental insurance
• Mental health insurance
• Vision insurance
• Short-term disability coverage
• Long-term disability coverage
• Life insurance
• AD&D insurance coverage
• Adoption benefits
• Surrogacy benefits
• Wellness benefits
• Employee/family assistance plans
• Retirement savings plans (pension/401(k))
• Global share ownership plan with employer matching contributions
• Financial education resources
• Financial counseling resources
• Up to 11 paid holidays
• 3 personal days
• 150 hours of vacation
• 40 hours of sick time
• Statutory leaves of absence

About the Company

• Manulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better.
• John Hancock Life Insurance Company (U.S.A.)

Equal Opportunity

• 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 hr@manulife.com.