Hybrid BI & Data Operations Analyst (Power BI)

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

Job summary

John Hancock Life Insurance Company (USA) seeks an Operations Analyst to design, automate, and maintain Power BI and PAIR reporting, enhancing visibility into access controls and compliance. The role supports data quality, audit readiness, and KPI development across Azure and enterprise data sources.

The ideal candidate will have a Master’s degree and 1 year of experience in BI development, ETL processing, and project management, with strong SQL skills and familiarity with Power Platform tools.

Qualifications

• Master’s degree or foreign equivalent in Computer Science, Information Technology and Management, Information Systems, Data Analytics, or a closely related field.
• 1 year of experience as a Systems Analyst or Operations Analyst.

Responsibilities

• 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 KRI calculations, improve reporting efficiency, and standardize reporting frameworks to improve consistency, performance, and usability across dashboards.
• Enhance server-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.
• Develop ACL segment analysis methodologies for RR2 and enhance Risk Rating frameworks by integrating Azure entitlements and enterprise data across multiple platforms.
• Identify and resolve data feed issues including Qualys, address inventory gaps, and ensure accurate data ingestion into PAIR.

Skills

Power BI development

ETL processing

Project management

Business analysis

SQL

Testing

Data quality and audit readiness

Identity and access management

Compliance reporting

Education

Master’s degree in Computer Science / IT / Analytics

Tools

Power BI

Azure

Active Directory

HashiCorp Vault

Azure Key Vault

CyberArk

SQL Server

MongoDB

Cosmos DB

Unix

Mainframe

Power Apps

Power Automate

Power Query

Power BI Workspaces

Azure Data Lake

Job description

John Hancock Life Insurance Company (USA) seeks an Operations Analyst to design, automate, and maintain Power BI and PAIR reporting, enhancing visibility into access controls and compliance. The role supports data quality, audit readiness, and KPI development across Azure and enterprise data sources.

The ideal candidate will have a Master’s degree and 1 year of experience in BI development, ETL processing, and project management, with strong SQL skills and familiarity with Power Platform tools.