Operations Analyst

Manulife•Boston, MA

7d•$90,160 - $167,440•Hybrid

About The Position

The Operations Analyst designs, automates, and maintains Power BI and PAIR reporting related to access controls, risk ratings, entitlements, and compliance, with a focus on data quality and audit readiness. The role develops dashboards and visualizations, automates Key Risk Indicator calculations, standardizes reporting frameworks, enhances data models and mappings, and builds integrations to reduce manual processes and improve data synchronization. The analyst develops access-control segment analysis and risk-rating methodologies, identifies and resolves data-feed issues, integrates new data sources, and analyzes accounts for disabled, revoked, or non-compliant status. The role also creates compliance dashboards using APIs from HashiCorp Vault, CyberArk, and Azure Key Vault, and supports CyberArk onboarding. The position tests and validates production updates and supports deployments, environment migration to Azure, end-to-end testing, quality assurance, scheduling, and release cycles in collaboration with cross-functional teams. The role is hybrid, with three days per week in the Boston office and two days working from home.

Requirements

Master’s degree or foreign equivalent in Computer Science, Information Technology and Management, Information Systems, Data Analytics, or a closely related field.
At least 1 year of experience as a Systems Analyst or Operations Analyst.
At least 1 year of BI development experience using Power BI.
At least 1 year of ETL data-processing experience using data sources including data sets, data flows, MS SQL Server, and Azure Data Lake.
At least 1 year of project management experience owning multiple high-stakes business deliverables across hundreds of requests.
At least 1 year of business analysis experience identifying trends, security risks, and areas for improvement.
At least 1 year of experience developing queries and code for in-depth data analysis using SQL.
At least 1 year of experience performing functional, regression, and integration testing, including developing and executing test plans, identifying defects, and collaborating with development teams.
At least 1 year of experience validating data feeds and system integrations while supporting release management and contributing to quality-assurance automation initiatives.
At least 1 year of experience using identity and access management systems and risk management frameworks for compliance reporting.
At least 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 improve visibility into access controls, risk ratings, entitlements, and compliance while supporting data quality and audit readiness.
Design and deploy Power BI dashboards and visualizations to automate Key Risk Indicator calculations, improve reporting efficiency, and standardize reporting frameworks.
Enhance server-to-segment and account-to-segment mappings and expand PAIR data models with fields and compliance filters for ACL policy tracking and audit requirements.
Develop data integration and reporting automation, including integrating Azure and Active Directory permissions into PAIR.
Develop ACL segment analysis methodologies for RR2 and enhance Risk Rating (RR1–RR7) frameworks using Azure entitlements and enterprise group data across multiple platforms.
Identify and resolve data-feed issues, including Qualys issues, address inventory gaps, and ensure accurate ingestion into PAIR.
Integrate new data sources into the PAIR model, analyze accounts to identify disabled, revoked, and non-compliant accounts, and create reports comparing new and legacy data structures.
Design compliance dashboards integrating APIs from HashiCorp Vault, CyberArk, and Azure Key Vault to track non-compliant accounts.
Create Safes and manage account integration to support CyberArk onboarding.
Test and validate production updates, support production deployments, and contribute to migration of production, user acceptance testing, and development environments to Azure.
Collaborate with cross-functional teams on data-processing logic, including multi-home servers; perform end-to-end testing; and support quality assurance, scheduling, and deployment release cycles.