PMO Analyst

About the Role We are seeking a PMO Analyst to design, build, and maintain a PJM PMO Reporting Dashboard in Power BI as the single source of truth for all PJM data and updates. You will integrate and model data from Kahua, Excel, Smartsheet, and related systems to produce trusted, executiveu2011ready portfolio and project insightsu2014supporting monthly PMO cycles, executiveu2011level portfolio reviews, clientu2011facing reporting, audit responses, and process improvement initiatives. Youu2019ll collaborate closely with the PMO Director and crossu2011functional partners to standardize metrics, improve data quality, and drive adoption of PMO tools and processes. This person must be able to work onsite in San Antonio, TX. What Youu2019ll Do Portfolio Reporting & Analytics + Design & own the PJM PMO Power BI dashboard that unifies data from Kahua, Excel, Smartsheet, Tableau, Vantage (and other enterprise systems) into a cohesive, refreshable model. + Build and maintain semantic models (Power Query/M, DAX, dataflows) supporting executive reports, clientu2011facing views, and portfolio health. + Establish governance for data definitions, metric standards, lineage, and refresh cadence across PMO datasets. + Create drillu2011through pages for project health, cost vs. budget, change orders, milestones, risks/issues, action items, and forecast accuracy. + Enable rowu2011level security (RLS) and appropriate access controls for internal and client audiences. PMO Operations & Collaboration + Partner with the PMO Director on monthly PMO reporting cycles, executive portfolio reviews, audit responses, quality checks, and process improvements. + Facilitate enterprise portfolio dashboards and crossu2011functional KPI development with Finance, IT, Engineering, and Operations. + Maintain and improve tools, templates, and systems used by all PJMs; lead standards training and enablement sessions. + Consolidate resource capacity planning data, integrating headcount, allocations, and demand signals into portfolio views. + Coordinate change management (communications, training, adoption KPIs) for new reports, templates, and processes. Data & Systems Integration + Connect to Kahua (project controls/capital projects), Smartsheet (plans, risk logs), Excel (interim trackers), SharePoint/OneDrive, and other enterprise sources. + Implement refresh pipelines (Power BI Service) with robust validation and audit trails. + Create data quality checks and exception reporting; drive remediation with data owners. Required Qualifications + 3u20135+ years in PMO/Portfolio Analytics, Business Intelligence, or Project Controls reporting (clientu2011facing or executive reporting preferred). + Power BI expert: Advanced DAX, Power Query (M), modeling/star schemas, dataflows, RLS, bookmarks, drillu2011through, metrics (Scorecards), and Power BI Service administration fundamentals. + Proven systems integration experience with Kahua (or similar project controls/capital program platforms), Capital Planner, Smartsheet, Excel, SharePoint/OneDrive. + Strong KPI design for portfolio health: schedule, cost, scope, risk, change, benefits, resource capacity/utilization, forecast accuracy. + Solid understanding of PMO processes: intake, prioritization, gating, financial tracking, risks, change control, and audit readiness. + Advanced Excel (Power Query, Pivot, complex formulas) and Smartsheet (formulas, reports, control center preferred). + Applicants must be currently authorized to work in the United States without the need for visa sponsorship now or in the future Preferred Qualifications + Experience with Kahua data structures (budgets, commitments, change orders, schedules, RFIs, submittals) and API/exports. + Familiarity with resource capacity planning tools/processes (kill inventories, demand vs. supply modeling). + Knowledge of data governance practices (definitions, stewardship, lineage). + Exposure to Power Automate for workflow/refresh notifications; Azure AD for access management. + Relevant certifications (Power BI Data Analyst Associate (PLu2011300), PMIu2011ACP, CBIP) are a plus. What Youu2019ll Need: + High School Diploma or GED with up to 2 years ofjob-related experience. + Ability to follow basic work routines andstandards in the application of work. + Communication skills to exchange straightforwardinformation. + Working knowledge of Microsoft Office products.Examples include Word, Excel, Outlook, etc. + Strong organizational skills with an inquisitivemindset. Why CBRE? We value a culture of respect, integrity, service andexcellence that crafts our approach to every opportunity We are guided by theneeds of the cities we inhabit, the communities we build, and the world wethrive in. Competitive pay and benefits including Medical, Dental,Vision, PTO, 401k, and more that start 1st of the month. Internal advancementavailable after 6-month mark. FORTUNE Most Admired Company #1 in real estate for thirdconsecutive year; Ten years in a row on the list. Forbes Named one of the best large employers in America andone of the World's Best Employers Disclaimers Applicants must be currently authorized to work in theUnited States without the need for visa sponsorship now or in the future. CA Residents: CBRE carefully considers multiple factors to determine compensation, including a candidateu2019s education, training, and experience. The salary range for this position is $63,000 - 70,000 annually. The compensation that is offered to a successful candidate will depend on the candidateu2019s skills, qualifications, and experience. This role will provide the following benefits: 401(K), Dental insurance, Health insurance, Life insurance, and Vision insurance. Equal Employment Opportunity: CBRE is an equal opportunity employer that values diversity. We have a long-standing commitment to providing equal employment opportunity to all qualified applicants regardless of race, color, religion, national origin, sex, sexual orientation, gender identity, pregnancy, age, citizenship, marital status, disability, veteran status, political belief, or any other basis protected by applicable law. Candidate Accommodations: CBRE values the differences of all current and prospective employees and recognizes how every employee contributes to our companyu2019s success. CBRE provides reasonable accommodations in job application procedures for individuals with disabilities. If you require assistance due to a disability in the application or recruitment process, please submit a request via email at or via telephone at +1 866 225 3099 (U.S.) and +1 866 388 4346 (Canada).CBRE, Inc. is an Equal Opportunity and Affirmative Action Employer (Women/Minorities/Persons with Disabilities/US Veterans)

Created: 2026-03-09