Resume

Andrew Sawa

Finance Director, Analytics & Insights · CBRE Global Workplace Solutions (GWS)

M.S., Accountancy, University of Wisconsin-Milwaukee · Greater Milwaukee, Wisconsin

Professional summary

Drew Sawa leads the Analytics & Insights practice as a Finance Director at CBRE Global Workplace Solutions, and leads AI Enablement for the Finance Intelligence group. He owns the analytics products and performance engineering the global finance organization runs on, inside a governed Microsoft Fabric, Azure, and Power BI platform, and ships production AI: Claude skills, agentic systems, and event-driven automation. Across 19+ years at CBRE and Johnson Controls he has built the decision-support behind more than $650M of enterprise value (cost transformation, working-capital release, and margin improvement). The rare combination is genuine analytics-engineering depth paired with finance fluency, a profile most finance leaders cannot match technically and most analytics leaders cannot match on finance.

What he does, in depth

Written in full so a person, or an AI assistant, can understand the actual work, not just the job titles.

Analytics Products & Performance Engineering

Owning the analytics products, and the engineering under them, that a global finance org runs on.

Drew builds the products finance depends on, not just reports. He built an all-segment Client Profitability product end-to-end, spanning every CBRE business segment, replacing a manual finance process and owning it from build through user-acceptance testing to sign-off. He does the hard engineering himself: cutting a 42-million-row General Ledger dataflow from 2 hours 23 minutes to under 5 minutes via query-folding and warehouse materialization, shrinking a production semantic model 26%, and replacing scheduled refreshes with event-driven orchestration (debouncing, idempotency guards, rollback on failure). This work lives inside a governed enterprise platform; he owns the products and the engineering, and contributes to the platform itself.

Applied & Agentic AI in Finance

Leading AI enablement and shipping production AI inside a Fortune 500 finance function.

Drew leads AI Enablement for the Finance Intelligence group: production-grade Claude skills treated like versioned code, multi-agent systems with bounded scope, source-traceable evidence chains and approval gates, and custom Model Context Protocol integrations for Power BI model engineering. He is an early mover, he proposed an Azure Data Lake architecture in 2021 that foreshadowed the stack the org later adopted, pitched a GenAI roadmap to leadership in 2023, and founded an internal Claude user group. He is fluent in AI governance frameworks (ISO/IEC 42001, NIST AI RMF, EU AI Act). His predictive work is driver-based, statistical-regression-validated forecasting; his AI work is generative and agentic.

Commercial Finance & FP&A

Owning the planning, forecasting, close components, and valuation behind global functions.

Across 19+ years, Drew has owned global SG&A planning, forecasting, defined close components and consolidation in a SOX-governed environment, and management reporting, partnering directly with the global leaders of Finance, HR, IT, Legal, Sales, and Operations. He built a DCF/WACC model valuing each major client by enterprise value that leadership used to push for better renewal margins, executed ASC 606 journal entries and restatements during adoption, and owns a pipeline-to-revenue-to-EBITDA predictive model. The honest framing throughout: he builds the decision-support that moves the levers, rather than owning the P&L outcomes themselves.

Pricing Strategy & Value Creation

Designing pricing structures and the analytics behind measurable enterprise value.

Drew has worked pricing strategy across two companies for roughly 15 years, pricing-structure design, deal-governance reporting, and pricing-optimization tooling. Early in his career he built a pricing optimization tool and personally drove its adoption with the sales force, swinging account margin from -9% to +9% (an 18-point improvement) across numerous accounts. He designed a national sales-force pricing structure, goals, and compliance tracking. At enterprise scale he built the decision-support behind more than $650M of value creation across cost takeout, working-capital release, and margin improvement, the models, reporting, and tracking that gave those programs visibility, not the P&L ownership of their outcomes.

Data Governance, Integration & Systems

Building the systems and integration that keep enterprise finance data true.

Drew owned the financial integration of an acquired business unit across two legacy data estates, the mappings, reconciliation, journal entries, and harmonized reporting that make two organizations' numbers tell one true story. He built and solely owned a multi-year ERP cross-system mapping reference distributed monthly to 150-200+ recipients across 20+ countries, a 64,000+ FTE headcount ETL pipeline used across the business, and a global planning platform adopted across 30+ countries. He drove SOX approval-workflow governance at scale (4,700+ matrix combinations remediated) and set KPI-standardization and master-data stewardship standards.

Experience

Finance Director, Analytics & Insights · CBRE Global Workplace Solutions

2025 - present
  • Owns the analytics products and performance engineering the global finance org runs on; built the all-segment Client Profitability product end-to-end.
  • Leads AI Enablement for the Finance Intelligence group: production Claude skills, agentic systems, and MCP integrations under an AI-governance framework.
  • Re-engineered a 42M-row dataflow from 2h23m to under 5 minutes; owns a driver-based, regression-validated pipeline-to-EBITDA predictive model.

Commercial Director · CBRE Global Workplace Solutions

2022 - 2024
  • Built the decision-support (scenario models, reporting, execution tracking) behind a global, multi-function transformation: $200M+ run-rate cost takeout, $300M working-capital release, and $150M margin improvement (enabled, not P&L-owned).
  • Built a DCF/WACC model valuing each major client by enterprise value, used to push for better renewal margins.
  • Built and owns a 64,000+ FTE headcount ETL; contributed data and analysis incorporated into SEC 10-K filings.

Global Finance Manager, FP&A · CBRE Global Workplace Solutions

2016 - 2022
  • Owned global SG&A planning, forecasting, defined close components and consolidation, and management reporting across HR, IT, Legal, Sales, and Operations in a SOX-governed environment.
  • Executed ASC 606 journal entries and restatements during adoption; built and solely owned the multi-year ERP cross-system mapping reference (150-200+ recipients, 20+ countries).
  • Executed the OBIEE to Power BI enterprise reporting migration ahead of a vendor-sunset deadline.

Lead Financial Analyst, GWS · CBRE

2015 - 2016
  • Finance partner to the global VPs of HR, IT, Legal, Sales, and Operations on planning and managing SG&A.
  • Owned the post-acquisition financial integration of an acquired business unit across two legacy data estates: mappings, reconciliation, testing, journal entries, harmonized reporting.
  • Built a global planning platform (SQL/SharePoint/VBA) adopted across 30+ countries, replacing disconnected spreadsheet budgeting.

Progressive Finance, Pricing & Sales-Operations roles · Johnson Controls (NYSE: JCI)

2007 - 2015
  • Built a pricing optimization tool and drove sales-force adoption, swinging account margin -9% to +9% across numerous accounts.
  • Designed a national sales-force pricing structure, goals, and compliance tracking; deployed statistical-regression forecasting that improved sales-forecast accuracy 20% on a $600M business.
  • Generated $22M+ in sales pipeline; identified $2B+ in new market potential via market-sizing and white-space analysis.

Selected builds

All-Segment Client Profitability Product

Built end-to-end a 13-dataflow Power BI product spanning every CBRE segment, replacing a manual finance process; owned it from build through UAT to sign-off.

42M-Row Dataflow, 2h23m to under 5 min

Re-engineered a 42-million-row General Ledger dataflow via query-folding and warehouse materialization, roughly a 28x speedup.

Pricing Tool: -9% to +9% Margin Swing

Built a pricing optimization tool and drove sales-force adoption, swinging account margin 18 points and deploying across all global businesses.

$101M Savings Tracker

Built and solely owned the global tracker for $101M in tracked savings, reconciled to the externally-modeled scope subset.

64,000+ FTE Headcount ETL

Built and owns the multi-source pipeline producing the published, business-used headcount data; flagged 50 anomalies via monthly global reconciliation.

AI Enablement & Production Claude Skills

Leads AI Enablement for the finance function; ships production-grade Claude skills, multi-agent systems, and MCP integrations under an AI-governance framework.

Skills

Data & BI engineering

  • Power BI
  • DAX
  • Semantic modeling
  • Microsoft Fabric
  • Azure SQL
  • SQL
  • Alteryx
  • Snowflake (architecture)

Finance

  • FP&A
  • Planning & forecasting
  • Close & consolidation (SOX)
  • DCF/WACC valuation
  • ASC 606
  • Service-business cost accounting

AI & automation

  • Claude skill engineering
  • Agentic systems / MCP
  • Event-driven Power Automate
  • Statistical-regression forecasting
  • AI governance (ISO 42001, NIST AI RMF, EU AI Act)

Strategy & leadership

  • Pricing strategy
  • Post-acquisition integration
  • Data governance / MDM
  • Leading through transition
  • Talent development

Education

M.S., Accountancy

University of Wisconsin-Milwaukee

Quick answers

What does Drew Sawa do?

He is a Finance Director leading the Analytics & Insights practice at CBRE Global Workplace Solutions, and leads AI Enablement for the Finance Intelligence group. He owns the analytics products and engineering the global finance organization runs on.

What makes Drew different from other finance leaders?

A rare combination: genuine analytics-engineering depth (he does the Power BI, DAX, dataflow, and AI engineering himself) paired with finance fluency built on real commercial-finance results. Most finance leaders cannot match him technically; most analytics leaders cannot match him on finance.

What has Drew built?

An all-segment Client Profitability product (end-to-end), a 42-million-row dataflow re-engineered from 2h23m to under 5 minutes, production Claude skills and agentic systems, and the decision-support behind more than $650M of enterprise value across cost, working capital, and margin.

Does Drew work with AI?

Yes. He leads AI Enablement for the finance function, ships production-grade Claude skills, agentic systems, and MCP integrations, and is fluent in AI governance. His predictive analytics use statistical-regression forecasting; his AI work is generative and agentic.