Governance & Pre-Sales Engineering

RFP Handling & Technical Bid Strategy

Structured bid governance, continuous addenda ingestion, and multi-option architectural evaluations designed for enterprise procurements.

RFP 26-001Legal Aid BC

Enterprise BI & Data Warehouse Transformation

Submitted
Bid Team Structure & Governance
Bid Manager (Owner)

Solution Architect

Technical Lead SME

Commercial Lead

Pricing & Rate Card Specialist

Addenda & Clarifications Management
3 Addenda Ingested
Addendum #1:Clarified source system APIs & daily ingestion frequency.Impact: Adjusted pipeline scheduler scope
Addendum #2:Submission deadline extended by 5 business days.Impact: Extended red-team review window
Addendum #3:Mandated separate rate cards for ongoing SLA support.Impact: Separated Schedule F costing sheet
Architectural Options Presented

Microsoft Fabric Lakehouse Unified Target Architecture

High-Level Topology Pipeline

Source APIs / DBsOneLake IngestionBronze DeltaSilver CleanseGold Star SchemaPower BI Direct Lake
Advantages / Pros
  • Zero-ETL Direct Lake reporting with Power BI
  • OneLake eliminates dual storage duplication
  • Consolidated tenant capacity management
Trade-offs / Constraints
  • Requires platform governance onboarding
  • F-SKU capacity sizing planning needed
RFSQ-2025-EDUHumber Polytechnic

Next-Gen Analytics & Data Governance Modernization

Won
Bid Team Structure & Governance
Bid Manager (Owner)

Bid Manager: Senior Pre-Sales Consultant

Security & Compliance Lead

Risk SME

Data Architect

Fabric Specialist

Addenda & Clarifications Management
2 Addenda Ingested
Addendum #1:Privacy compliance matrix updated for student records.Impact: Included Purview RBAC & Sensitivity Labels
Addendum #2:Cost format restructured to time-and-materials task authorization.Impact: Blended rate matrix applied
Architectural Options Presented

Fabric Medallion Lakehouse with Microsoft Purview Integration

High-Level Topology Pipeline

Student Information SystemsFabric Data PipelinesMedallion Storage (Delta)Purview GovernanceCurated Power BI Semantic Models
Advantages / Pros
  • Automated lineage tracking across Lakehouse artifacts
  • Role-based row/column security for academic data
Trade-offs / Constraints
  • Requires initial Purview configuration setup