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, executive‑ready portfolio and project insights-supporting monthly PMO cycles, executive‑level portfolio reviews, client‑facing reporting, audit responses, and process improvement initiatives. You'll collaborate closely with the PMO Director and cross‑functional 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 You'll 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, client‑facing views, and portfolio health. + Establish governance for data definitions, metric standards, lineage, and refresh cadence across PMO datasets. + Create drill‑through pages for project health, cost vs. budget, change orders, milestones, risks/issues, action items, and forecast accuracy. + Enable row‑level 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 cross‑functional 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** + 3-5+ years in PMO/Portfolio Analytics, Business Intelligence, or Project Controls reporting (client‑facing or executive reporting preferred). + Power BI expert: Advanced DAX, Power Query (M), modeling/star schemas, dataflows, RLS, bookmarks, drill‑through, 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 (PL‑300), PMI‑ACP, CBIP) are a plus. **What You'll Need:** + High School Diploma, GED, or trade school diploma with 4-5 years of job-related experience. In lieu of a diploma, a combination of experience and education will be considered. Prior shift manager or supervisory experience preferred. Journeyman or EPA Universal License required. + Meet the physical requirements of this role including stooping, standing, walking, climbing stairs/ladders, and the ability to lift/carry heavy loads of 50 lbs. or more. + Ability to exercise judgment based on the analysis of multiple sources of information. + Willingness to take a new perspective on existing solutions. + In-depth knowledge of Microsoft Office products. Examples include Word, Excel, Outlook, etc. + Organizational skills with an advanced inquisitive mindset. **Why CBRE** When you join CBRE, you become part of the global leader in commercial real estate services and investment that helps businesses and people thrive. We are dynamic problem solvers and forward-thinking professionals who create significant impact. Our collaborative culture is built on our shared values - respect, integrity, service and excellence - and we value the diverse perspectives, backgrounds and skillsets of our people. At CBRE, you have the opportunity to chart your own course and realize your potential. We welcome all applicants. **Our Values in Hiring** At CBRE, we are committed to fostering a culture where everyone feels they belong. We value diverse perspectives and experiences, and we welcome all applications. **Disclaimers** Applicants must be currently authorized to work in the United States without the need for visa sponsorship now or in the future. Include any other disclaimers that are applicable for the role that are not automatically populated in Talent Source. Delete this section if not applicable. Examples of relevant disclaimers include U.S. state pay transparency requirements, sponsorship eligibility, COVID-19 requirements, etc. **Applicant AI Use Disclosure** We value human interaction to understand each candidate's unique experience, skills and aspirations. We do not use artificial intelligence (AI) tools to make hiring decisions, and we ask that candidates disclose any use of AI in the application and interview process. **About CBRE Group, Inc.** CBRE Group, Inc. (NYSE:CBRE), a Fortune 500 and S&P 500 company headquartered in Dallas, is the world's largest commercial real estate services and investment firm (based on 2024 revenue). The company has more than 140,000 employees (including Turner & Townsend employees) serving clients in more than 100 countries. CBRE serves clients through four business segments: Advisory (leasing, sales, debt origination, mortgage serving, valuations); Building Operations & Experience (facilities management, property management, flex space & experience); Project Management (program management, project management, cost consulting); Real Estate Investments (investment management, development). Please visit our website at . CBRE carefully considers multiple factors to determine compensation, including a candidate's education, training, and experience. The minimum salary for the Union Operating Engineer position is $26 per hour and the maximum salary is $30 per hour. The compensation that is offered to a successful candidate will depend on the candidate's 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 company's 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 recruitingaccommodations@ 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-04-02