Governing an 18-month, fixed-fee data warehouse modernization program for a US FinTech enterprise.
A multi-project program migrating a legacy SQL Server data warehouse to the Modern Data Stack (Snowflake, dbt, Tableau). Designed around three non-negotiables: fixed term, fixed consultancy fees, and zero scope drift — defended by formal gateways, a parking-lot system, and an explicit change-control process.
RoleProgram Manager
Duration18 months
EngagementFixed-fee
Constituent ProjectsMultiple
Program ManagementModern Data StackSnowflake · dbt · TableauGovernanceChange ControlRAID ManagementC-level Stakeholder
01 — Strategic Objective & Key Results
One mandate. Three non-negotiables.
Migrate the data warehouse to the Modern Data Stack — and do it within the agreed 18 months and consultancy fees. Everything else in the program is in service of those three constraints.
< 5%
Cost variance
Budget/Cost Variance against the total agreed fees.
100%
Milestone rate
Completion across the macro-schedule phases.
> 98%
Data validation
Validation rate during the mandatory UAT phase.
0
Unmanaged scope
All scope additions routed through the formal CCP.
02 — Program Lifecycle
Three phases. Each ends at a contractual gateway.
The program is structured around the standard lifecycle — Initiation, Delivery, Closure — but with one twist: every phase boundary is also a formal control point. No phase advances until its deliverables are signed off, locking the scope behind it.
I.
Initiation
Define the boundary
Formal program kick-off, scope definition, and the crucial 18-month fixed-term acknowledgement. Core activity: data source mapping and dependency analysis.
Migration begins with PoC to validate the approach and refine estimates, then iterates through agile cycles. Mandatory UAT with client Data Analysts gates every release.
Formal sign-off against the fixed mandate. Success is defined narrowly: full migration to Snowflake/dbt/Tableau within 18 months and within the agreed fees.
Each gateway represents a formal sign-off — the prior phase's scope is locked, and the next phase cannot begin without it.
03 — Governance Framework
A way-of-working built in four deliberate steps.
Before execution begins, the rules of execution are defined, presented, signed off, and then operated. Governance is not the byproduct of program management — it is the first deliverable of program management.
Infochart 02 · Way-of-Working Setup
From shared rules to enforced execution
04 — Change Control
How scope additions are handled — and how the fixed-fee contract is defended.
A fixed-fee, fixed-term program lives or dies by its change-control discipline. The program operates a strict three-step CCP, backed by a Parking Lot to capture anything ambiguous and Formal Gateways that lock prior phases against retroactive rework.
Infochart 03 · Change Control Process (CCP)
From scope-add request to sponsor decision
05 — Performance Monitoring
Four KPIs the C-level cares about — and nothing else on the dashboard.
Operational telemetry stays in the working teams. What rises to the sponsor is exactly what informs sponsor-level decisions: financial adherence, schedule adherence, quality, and the leading indicator of scope stress.
Infochart 04 · Executive KPI Dashboard
What the Head of Data sees, monthly
06 — Stakeholder Management
Communicating with the sponsor means filtering, not flooding.
The Head of Data does not need standup blockers. The Head of Data needs to know whether the program is strategically on track, financially on track, and that the top risks are being handled. The communication model is built around that distinction.
Infochart 05 · Stakeholder Tiers
Who hears what, and how often
07 — Program Deliverables
The artifacts that carry the program — and the contract.
In a fixed-fee engagement, every artifact serves two audiences: the delivery team that operates against it, and the contract that's protected by it. Each output below was designed with both in mind.
Program Charter & Kick-off Pack
Formal program objectives, premises, the 18-month fixed-term constraint, and acknowledged contractual boundary.
Migration Assessment & Strategy
Data source map, dependency analysis, and the strategy document that defines the fixed contract boundary.
Four KPIs only: Cost Variance, Milestone Rate, Data Validation Rate, Change Request Frequency.
Stakeholder Management Plan
Three-tier model with defined cadence, content, and escalation criteria for each tier.
“
A program with a fixed term and fixed fees has exactly one job: protect both. Governance, change control, and stakeholder discipline are not overhead — they are the program.