Projects Technology Analyst

Cushman & Wakefield•Ashburn, VA

About The Position

The Projects Technology Analyst plays a critical role in supporting our top 4 US banking financial services client’s real estate organization by managing, validating, and communicating the technology related cost estimates associated with the BCID 793 capital program. This role serves as the operational and analytical hub between Real Estate Leadership, Project Execution, Technology, Finance, Workplace Strategy, and third-party vendor partners—ensuring that all program applicable projects are accurately captured, validated, prioritized, and reported. The analyst is responsible for overseeing monthly estimate updates, performing rigorous data quality control, identifying and explaining variances, and preparing executive ready reporting used for governance and capital planning decisions. The role also leads weekly cross functional working sessions, reviews of new projects, and helps refine processes that govern project tracking, ROM estimating, and budget alignment. This is not a traditional financial analyst position. Instead, it requires a highly organized, detail oriented professional who excels in Excel based reconciliation, thrives in an environment with evolving systems and processes, and brings strong communication skills to bridge gaps between multiple operational groups. Success in this role depends on analytical rigor, proactive issue identification, comfort with ambiguity, and the ability to translate complex project and technology data into clear, actionable insights for leadership.

Requirements

Technical Skills
Advanced Excel proficiency , including:
Lookup formulas (VLOOKUP, XLOOKUP)
Data reconciliation and comparison
Filtering, sorting, pivoting
Merging datasets from SharePoint feeds
Strong PowerPoint skills for building clean, executive‑ready visuals.
Comfort working with enterprise systems such as SharePoint , SAP or similar project management/data systems.
Ability to interpret project schedules, work types, start/end dates, and ROM/HLE estimates.
Understanding of capital vs. expense classification modeling and depreciation schedules.
Experience Background in project management , cost control , construction/real estate operations , or technology coordination strongly preferred.
Experience coordinating across functional teams.
Vendor or client‑service experience beneficial.
Soft Skills
Highly organized with exceptional attention to detail.
Data‑driven and QC‑oriented ability to spot discrepancies quickly.
Curious and proactive ; comfortable digging into incomplete information.
Strong communicator able to collaborate with PMs, tech teams, finance, and leadership.
Resilient and adaptable ; able to navigate ambiguous and evolving systems, shifting priorities, and process gaps.
Diplomatic and professional , especially when delivering difficult findings.

Nice To Haves

Familiarity with banking, financial services, or large enterprise environments.
Experience working with data feeds or automated reconciliation logic.
Exposure to multi‑vendor project delivery environments.
Success in This Role Looks Like
Accurate, timely monthly reporting with clean data and defensible variance explanations.
Minimal missing or uncaptured applicable projects due to strong QC processes.
Leadership has clear visibility into forecast changes and budget risks.
Strong relationships across Real Estate, Tech, and Finance.
Improved alignment between project schedules, estimates, and budget constraints.
Integration of program reporting across overall capital plan workstream.

Responsibilities

Estimate Tracking & Monthly Budget Reconciliation Manage estimate‑level technology costs for applicable projects across annual budgets.
Compare monthly SharePoint and Project Management system data feeds to prior periods and identify cost variances, often across hundreds of projects.
Investigate and document the reasoning for estimate changes by coordinating with Project Managers, Technology Coordinators, and Finance.
Maintain a complete, accurate list of all applicable projects; identify missing or miscoded projects and resolve gaps.
Data Quality Control (QC) & Issue Resolution Detect data anomalies such as missing dates, incorrect work types, unassigned coding, or incomplete project records.
Prepare for and lead weekly reviews of new projects feeds to validate whether projects are applicable.
Prepare for and lead reviews of new projects with workplace strategy and construction execution leads to validate project prioritization and accuracy.
Support improvements to filters, SharePoint logic, and data governance processes.
Cross‑Functional Coordination Serve as a liaison among: Real Estate Leadership Project Execution Leads Technology Finance SharePoint Data Administrators Vendor teams
Escalate and help resolve project discrepancies through proactive outreach.
Lead weekly and monthly working sessions to troubleshoot data or process issues across teams.
Reporting & Governance Prepare monthly PowerPoint decks summarizing forecast changes, variances, and trends for senior leadership.
Present findings in governance meetings and communicate “bad news” diplomatically and clearly.
Scenario analysis (e.g., deferrals needed to align to an annual budget cap).
Process Design & Continuous Improvement Help refine the intake and ROM estimating process for new applicable projects, including leadership approvals and sequencing.
Contribute to shaping the future workflows between Technology, Real Estate, and Finance.
Support creation of documentation, SOPs, and onboarding materials.