Operations Analyst

Manulife/John Hancock; Boston (MA); Hybrid; USD 90,000 - 167,000; Full time

Benefits offered by this job

Health insurance

401(k) plan

Paid holidays

Job summary

John Hancock Life Insurance Company (USA) is seeking an Operations Analyst in Boston. The role focuses on designing, automating, and maintaining Power BI and PAIR reporting to improve visibility into access controls, risk, and compliance.

You will expand data models and automate data integration across Azure and Identity platforms. You will work in a hybrid environment from the Boston office, contributing to migration, testing, and deployment cycles while collaborating with cross-functional

Qualifications

• Master’s degree or equivalent in a related field with 1 year of analyst experience.
• Minimum 1 year of BI development using Power BI.
• Experience ETL processing with MS SQL Server and Azure Data Lake.
• Experience owning multiple high-stakes deliverables and working with cross-functional teams.

Responsibilities

• Design, automate, and maintain Power BI and PAIR reporting to enhance access controls and compliance visibility.
• Develop dashboards to automate KRI calculations and standardize reporting frameworks.
• Expand PAIR data models with new fields and compliance filters for ACL policy tracking.
• Automate data integration across Azure, Active Directory, and other sources to improve data synchronization.
• Collaborate to implement data processing logic and support release cycles in Azure environments.

Skills

Power BI

SQL

ETL processing

Project management

Data analysis

Power Platform

Education

Master’s degree or foreign equivalent in Computer Science/IT/Management/Data Analytics

Tools

MS SQL Server

Azure Data Lake

Qualys

HashiCorp Vault

CyberArk

Azure Key Vault

Power BI PAIR

Job description

Employer

John Hancock Life Insurance Company (USA)

Mission and Vision

We’re on a mission to make decisions easier and lives better. Better is what drives us. It’s what inspires us to find new ways to support customers and colleagues in living longer and healthier lives. It’s the reason we’re dedicated to investing in digital innovation and industry-leading AI, and accelerating a sustainable and economically inclusive future.

Job Site

200 Berkeley Street, Boston, MA 02116

Job Title

Operations Analyst

Job Duties

Design, automate and maintain Power BI and PAIR reporting to enhance visibility into access controls, risk ratings, entitlements, and compliance while supporting data quality, audit readiness; Design and deploy Power BI dashboards and visualizations to automate Key Risk Indicator (KRI) calculations, improve reporting efficiency, and standardize reporting frameworks to improve consistency, performance, and usability across dashboards; Enhance server-to-segment and account-to-segment mappings and expand PAIR data models with additional fields and compliance filters to support ACL policy tracking and audit requirements; Develop automation solutions for data integration and reporting including integration of Azure and Active Directory permissions into PAIR to eliminate manual processes and improve data synchronization; Develop ACL segment analysis methodologies for RR2 and enhance Risk Rating (RR1–RR7) frameworks by integrating Azure entitlements and enterprise group data across multiple platforms including Unix, SQL, MongoDB, Cosmos DB, PaaS, and mainframe; Identify and resolve data feed issues including Qualys, address inventory gaps, and ensure accurate data ingestion into PAIR; Integrate new data sources into PAIR model and perform account analysis to identify disabled, revoked, and non-compliant accounts, and develop comparison reports to validate new vs. legacy data structures; Design compliance dashboards integrating APIs from HashiCorp Vault, CyberArk, and Azure Key Vault to track non-compliant accounts, and create Safes and manage account integration to support CyberArk onboarding; Test and validate production updates and support deployment into production, and contribute to migration of production, user acceptance testing and development environments to Azure to ensure system stability and data integrity; and Collaborate with cross-functional teams to implement data processing logic including multi-home servers, perform end-to-end testing, and support release cycles including quality assurance, scheduling, and deployment.

Work Arrangement requirement

Hybrid from Boston office (3 days from office, 2 days from home)

Salary

$112,861 per year

Minimum Requirements

• Master’s degree or foreign equivalent in Computer Science, Information Technology and Management, Information Systems, Data Analytics, or a closely related field and 1 year of experience as a Systems Analyst or Operations Analyst.
• 1 year of BI development experience using Power BI;
• 1 year of ETL data processing experience using data sources including data sets, data flows, MS SQL Server, and Azure Data Lake.
• 1 year of project management experience including owning multiple high-stakes business deliverables across hundreds of requests.
• 1 year of experience conducting business analysis to identify trends, security risks, and areas for improvement.
• 1 year of experience developing queries and code for in-depth data analysis using SQL.
• 1 year of experience performing functional, regression and integration testing including developing and executing test plans, identifying defects, and collaborating with development teams to ensure delivery of high-quality deliverables.
• 1 year of experience validating data feeds and system integrations while supporting release management, and contributing to automation initiatives to streamline quality assurance processes.
• 1 year of experience using identity and access management systems, and risk management frameworks for compliance reporting.
• 1 year of experience with Microsoft Power Platform including Power Apps, Power Automate, Power Query, and Power BI Workspaces.

Salary range

Referenced Salary Location Boston, Massachusetts Working Arrangement Hybrid Salary range is expected to be between $90,160.00 USD - $167,440.00 USD Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance.

Benefits

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

Know Your Rights

• Family & Medical Leave
• Employee Polygraph Protection
• Right to Work
• E-Verify

Recent awards

• 2026 Gallup Exceptional Workplace Award Winner
• Manulife Named one of Forbes World’s Best Employers 2025
• Financial Times World’s Best Employers Asia-Pacific 2026
• We’ve been recognized as one of Canada’s Top 100 Employers 2026
• #1 Life Insurer for AI Maturity by Evident 2026

Employer information

To learn more about us, visit https://www.manulife.com/en/about/our-story.html.

Opportunity Statement

We’ll recognize and support you in a flexible environment where well-being and inclusion are more than just words. And as part of our global team, you’ll help shape the future you want to see – and discover that better can take you anywhere you want to go.

Contact for reasonable accommodation

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 [e-mail].