Operations Analyst

Manulife John Hancock; Boston (MA); Hybrid; USD 102,000 - 124,000; Full time

Job summary

John Hancock Life Insurance Company (USA) in Boston is seeking an Operations Analyst to design, automate, and maintain Power BI/PAIR reporting, enhancing access controls, risk ratings, and audit readiness. You will build dashboards, expand data models, and integrate sources across platforms.

The role requires 1 year of BI/ETL experience, strong SQL skills, and project management capability, with hybrid work arrangements (3 days in office, 2 from home). Salary is $112,861 per year.

Qualifications

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

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 across dashboards;
• Enhance server-to-segment mappings and expand PAIR data models with additional fields and compliance filters;
• 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 RR1-RR7 frameworks by integrating Azure entitlements and enterprise data;
• 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 non-compliant accounts;
• Design compliance dashboards integrating APIs from HashiCorp Vault, CyberArk, and Azure Key Vault;
• Test and validate production updates and support deployment into production, and contribute to migration of environments to Azure;
• Collaborate with cross-functional teams to implement data processing logic including multi-home servers, perform end-to-end testing, and support release cycles.

Skills

Power BI

ETL processing

SQL queries

BI development

Project management

Business analysis

Data quality

Release management

IAM systems

Azure

Education

Master's degree in CS/IT/IS/Data Analytics

Tools

Power Apps

Power Automate

Power Query

Power BI Workspaces

Azure Data Lake

Job description

Employer: John Hancock Life Insurance Company (USA)

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.

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better. To learn more about us, visit https://www.manulife.com/en/about/our-story.html .

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