A

Apex Group

Global fund administration and related services

Senior PMO Tooling and Automation Analyst

Business IntelligenceConfirmed live in the last 24 hours
Full-timePune, Maharashtra, IndiaNo salary listedIn-person

About the Job

Requirements

  • A minimum of 7 years of relevant experience across PMO, portfolio reporting, project controls, data analytics, tooling, or automation roles, including at least 4 years building or administering PMO technology solutions.
  • Demonstrable experience designing and delivering portfolio and executive reporting solutions in a complex enterprise environment.
  • Advanced Microsoft Excel capability, including Power Query, PivotTables, Power Pivot, and complex formulas.
  • Advanced Power BI experience, including data modelling, Power Query, DAX, dashboard design, row-level security, publishing, and refresh management.
  • Strong hands-on Azure DevOps experience, including Boards configuration, work-item customisation, queries, dashboards, permissions, process templates, and reporting integration.
  • Hands-on ServiceNow experience configuring or supporting workflows, forms, approvals, notifications, queues, and reports.
  • A strong understanding of PMO disciplines, including governance, demand intake, stage gates, milestones, RAID, dependencies, resource planning, and portfolio reporting.
  • Proven experience automating reporting and governance processes using Power Automate or comparable workflow technologies.
  • Experience integrating data across Azure DevOps, ServiceNow, Power BI, and Microsoft 365 sources using APIs, connectors, OData, dataflows, or controlled extracts.
  • Ability to convert ambiguous business requirements into maintainable technical solutions and clear user stories.
  • Strong analytical, troubleshooting, and problem-solving capability, with rigorous attention to data accuracy and solution reliability.
  • Ability to work independently, manage a tooling backlog, and deliver multiple priorities in a fast-paced environment.
  • Fluency in spoken and written English.

Responsibilities

  • Partner with PMO leadership, Portfolio Leads, Project Managers, Technology teams, and business stakeholders to design, build, and optimise tooling and automation that strengthens PMO control, improves portfolio visibility, and reduces manual effort.
  • Own the design and continuous improvement of integrated PMO tooling solutions, including workflow automation, data integration, executive dashboards, governance controls, and self-service reporting.
  • Design, build, administer, and drive adoption of PMO tools and automated solutions across Azure DevOps, Power BI, ServiceNow, Power Automate, SharePoint, Excel, and related Microsoft technologies.
  • Design, build, and maintain portfolio, programme, and project dashboards for operational and executive audiences; develop decision-focused management information for governance forums and senior stakeholders.
  • Define standard key performance indicators, reporting logic, drill-through views, and reusable dashboard templates; provide actionable insight on portfolio health, delivery confidence, risks, issues, milestones, demand, capacity, and dependencies.
  • Automate enterprise reporting cycles and implement controls to improve accuracy, consistency, and timeliness.
  • Translate PMO and portfolio requirements into practical tool designs, workflows, data structures, dashboards, and automated controls.
  • Configure and enhance Azure DevOps boards, work-item types, fields, states, queries, dashboards, permissions, and portfolio reporting structures.
  • Configure or support ServiceNow workflows, forms, queues, approvals, notifications, and reporting relevant to demand, project, change, and governance processes.
  • Build semantic models, measures, and interactive Power BI reports using Power Query and DAX.
  • Establish tooling standards, release controls, user guidance, and support arrangements; train and coach PMO and delivery users to improve adoption, data quality, and self-service capability.
  • Monitor and improve data quality across Azure DevOps, ServiceNow, Power BI, and connected PMO data sources; design automated validation rules, exception reports, reconciliation checks, and data-completeness controls.
  • Identify data gaps, duplicates, inconsistencies, and reporting anomalies, and drive corrective action with accountable owners.
  • Define portfolio data standards, field definitions, ownership, access controls, and governance processes; maintain reporting definitions, metric logic, lineage documentation, and data dictionaries.
  • Perform trend and variance analysis to identify emerging portfolio risks, bottlenecks, and improvement opportunities; support capacity planning, utilisation analysis, demand forecasting, and resource decision-making.
  • Develop forward-looking reporting and scenario analysis; analyse schedule, milestone, resource, financial, demand, and delivery data from multiple systems; present evidence-based recommendations to PMO leadership and portfolio stakeholders.
  • Design, document, and maintain automated data extraction, transformation, and refresh processes; integrate or orchestrate data across Azure DevOps, ServiceNow, Power BI, SharePoint, Excel, and other approved enterprise platforms.
  • Create Power Automate workflows, alerts, approvals, and scheduled reporting processes that reduce manual intervention; automate governance, assurance, status reporting, demand intake, action tracking, and exception-management activities.
  • Develop maintainable data models and reusable components with appropriate error handling, logging, and support documentation.
  • Partner with PMO, Technology, Data, ServiceNow, and delivery teams to prioritise and deliver tooling enhancements; manage a backlog of tooling improvements, defects, automation opportunities, and technical debt.
  • Maintain solution documentation, process maps, operating procedures, repositories, and knowledge articles; provide practical support, root-cause analysis, and resolution for PMO tooling and reporting issues.
  • Build cross-functional capability through training, demonstrations, office hours, and reusable guidance; support reporting and information-management processes across the PMO community.
  • Develop and maintain automated reporting solutions using Power Automate, Power BI, and other approved technologies; identify and prototype responsible AI-assisted reporting, summarisation, forecasting, and risk-identification use cases while maintaining human oversight and auditable controls.
  • Design solutions enabling consistent drill-down from enterprise portfolio views to programme and project detail; improve data readiness and metadata quality to support advanced analytics and future AI capabilities.
  • Apply appropriate security, data access, change control, and responsible-use standards to automation solutions; measure solution adoption, reliability, cycle-time reduction, and realised efficiency benefits.
  • Proactively identify and deliver improvements to PMO reporting, controls, user experience, and operational efficiency; evaluate emerging platform capabilities and recommend practical applications.
  • Contribute to PMO transformation, tooling roadmaps, and portfolio data-maturity improvements; champion automation, standardisation, and data-driven decision-making.

Desired Qualifications

  • Experience within Financial Services or another regulated, data-sensitive industry.
  • Experience working within an Enterprise PMO, Portfolio Management Office, or transformation function.
  • Working knowledge of SQL, Python, REST APIs, JSON, OData, or advanced analytics techniques.
  • Microsoft certifications relevant to Power BI, Power Platform, Azure DevOps, or data analytics; ServiceNow certification is advantageous.
  • Experience implementing AI-assisted reporting, Copilot-enabled workflows, or intelligent automation with responsible-use controls.
  • Exposure to portfolio financial management, resource forecasting, demand management, and benefits tracking.
  • Relevant qualifications in Data Analytics, Information Systems, PMO, Project Management, Business Analysis, or a related discipline.
  • Experience with ServiceNow demand, project portfolio, or strategic portfolio processes is strongly preferred.

About the Company

Apex Group

Global fund administration and related services

Apex Group provides a single-source suite of financial services, including fund administration, corporate services, banking, custody, depositary services, and ManCo offerings, with digital onboarding and ESG advisory for private markets. Its platform lets clients choose individual services or an integrated package that covers the whole value chain, all supported by technology and data. The company differentiates itself through its global scale, reach, and growth through numerous acquisitions that expand capabilities and local expertise while keeping a single-provider experience. Its goal is to deliver high-quality, consistent client service worldwide with local delivery and to advance its integrated offering in private markets, tokenization, and cross-asset support.

Company size
5,001-10,000
Company stage
Debt Financing
Total funding
$1.5B
Headquarters
Hamilton, Bermuda
Founded
2003

Recently Posted Jobs

Explore more opportunities at Apex Group

See more jobs