Operations Data & BI Analyst - Automation & Azure

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

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