PMO Reporting Specialist

Aezion, Inc; Bengaluru; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A leading PMO consulting firm is seeking a PMO Reporting Specialist with 8-10 years of experience in Excel-driven operational reporting. The role involves consolidating data from various sources, ensuring accurate and timely reporting for leadership decision-making. The ideal candidate will have expert-level proficiency in MS Excel, strong PMO knowledge, and the ability to manage cross-functional teams effectively. This position is based in Bengaluru, India and requires a detail-oriented professional with a strong understanding of KPIs and governance processes.

Qualifications

• 8-10 years of experience in PMO reporting and operational reporting.
• Expert-level proficiency in MS Excel, including pivot tables and advanced formulas.
• Strong knowledge of PMO governance and Agile/Waterfall methodologies.

Responsibilities

• Own Excel-driven operational reporting across delivery, resourcing, and financial KPIs.
• Ensure accurate, timely reporting for leadership decision-making.
• Consolidate data from multiple sources and maintain a single source of truth.

Skills

Advanced Excel operational reporting

Multi-source data consolidation

Reporting-to-system alignment

Project setup and tool administration

System hygiene and data integrity

Dashboards and analytics tools

Strong KPI understanding

Stakeholder management

PMO methods and governance

Tool SME mindset

Tools

Power BI

Job description

Overview

We are seeking an experienced PMO Reporting Specialist (8–10 years) to join our PMO team. This role sits within the PMO and is responsible for owning Excel-driven operational reporting across delivery, resourcing, and financial KPIs—ensuring leadership has accurate, timely, and readable reporting for decision-making. A key expectation is to own operational reporting end-to-end in Excel (including pulling and consolidating data from multiple sources) and to ensure the same reporting truth is reflected in PM systems/tools through strong governance, data quality enforcement, and consistent updates across project plans, resourcing, and financial tracking.

Must Have Technical/Functional Skills

Must Have Technical/Functional Skills

• Advanced Excel operational reporting (expert): Expert-level MS Excel (pivot tables, Power Query, Power Pivot, advanced formulas) with proven ability to extract, consolidate, cleanse, and transform data from multiple sources (PM tools, timesheets, finance trackers, resourcing sheets, CSV exports) and deliver clear, leadership-ready operational reporting.
• Multi-source data consolidation: Strong ability to merge data from different systems, reconcile inconsistencies, and maintain a single source of truth reporting view.
• Reporting-to-system alignment: Ability to ensure Excel reporting outputs are accurately reflected back into PM systems/tools by driving updates, standardizing fields/structures, and enforcing consistent data capture across teams.
• Project setup and tool administration: Hands-on expertise setting up projects in enterprise PM/PPM tools (project creation, templates, calendars, codes, workflows, access, assignments).
• System hygiene and data integrity: Strong discipline in ensuring systems are always up to date (owners, dates, dependencies, statuses, assignments) and driving compliance across teams.
• Dashboards and analytics tools: Experience with tools such as Power BI and working with structured datasets.
• Strong KPI understanding (financial + delivery): Strong working knowledge of PMO and delivery KPIs, including gross margin calculation, budget maintenance, forecasting, variance tracking, and margin tuning/improvement, and ability to translate these into actionable reporting.
• Stakeholder management: Ability to work across global, cross-functional teams; communicate clearly; unblock teams quickly; drive follow-through.
• PMO methods and governance: Strong understanding of PMO standards, templates, governance cadences, and Agile/Waterfall/Hybrid delivery environments.
• Tool SME mindset: Comfortable acting as a go-to person for tool/process questions, troubleshooting, training, and creating SOPs/guides.
• Own weekly/monthly Excel-based operational reporting across portfolios: project health roll-ups, milestone delivery tracking, utilization/capacity, budget burn, forecasting, and KPI trend analysis—formatted for leadership consumption.
• Pull and consolidate data from multiple sources (PM tools, resourcing trackers, financial inputs, timesheets, operational logs), reconcile inconsistencies, and publish a single source of truth reporting view.
• Ensure reporting is reflected in PM systems/tools: drive the updates needed in PM tools so Excel-reported milestones, dates, ownership, utilization, and financial tracking are consistently captured and aligned across systems.
• Own end-to-end project setup in PMO tools: create projects, configure templates, calendars, codes, and standard structures.
• Manage user access, roles, permissions, and assignments to ensure teams can start and execute work without tool-related delays.
• Drive PMO tool governance: standardize naming conventions, structures, and update hygiene across projects/programs.
• Ensure project information is current and accurate in systems; perform periodic checks and coordinate corrections with project teams.
• Support PMO operating cadence: planning sessions, governance checkpoints, action tracking, RAID logs, decision logs, and meeting enablement (from a reporting/tooling lens).
• Act as the PMO Tools SME: troubleshoot issues, support adoption, create SOPs/quick guides, and conduct enablement sessions.
• Partner with PMO leadership to identify process/tool gaps and implement improvements (automation, templates, workflow enhancements, reporting optimization).