BCI is seeking a qualified Microsoft Solutions Partner to provide expert-level data engineering, analytics support, and data privacy auditing. The goal of this engagement is to transition our current data landscape from a Azure environment to a unified Microsoft Fabric architecture while providing continuous support for internal integration projects and ensuring robust GDPR compliance.

Background

Our current infrastructure relies on Azure SQL Data Warehouse and Power BI for reporting and analytics. We have identified Microsoft Fabric F64 as our future-state platform to take advantage of its unified “OneLake” architecture and the elimination of individual Power BI Pro licenses for content consumers. We require a partner who understands the unique financial and operational constraints of the non-profit sector to act as an extension of our internal data team.

Scope of Work

The selected partner will be responsible for the following workstreams:

• Fabric Migration:
  • Key Responsibilities: Planning and executing the migration of Azure SQL Data Warehouse workloads to Fabric Data Warehouse/Lakehouse, including schema conversion and asset inventory.
  • Output:
    • Detailed Migration Roadmap & Inventory of assets
    • Validated Medallion Architecture (Bronze, Silver, Gold)
    • Technical Decommissioning Report for legacy Azure DW (Also called CottonCloud at BCI)

• Ongoing Data Integration:
  • Key Responsibilities: Proactive monitoring of existing Salesforce-to-Fabric pipelines; BCP-to-Fabric pipelines (BCP is our Supply Chain & Traceability system) managing API limits, handling sync errors, and field mapping updates.
  • Expected Outputs:
    • Monthly Integration Health & Performance Logs.
    • Updated Data Dictionary & API Usage Report.
    • Automated error-alerting framework for daily syncs
  • New Integration Projects:
    • Key Responsibilities: Engineering new ingestion pipelines using REST APIs and middleware (Azure Logic Apps/Functions) for other source systems (both internal and external)
    • Expected Outputs:
      • Technical Design Documents (TDD) for each new pipeline.
      • Functioning ELT/ETL pipelines with 99.5% uptime SLA.
      • Documented API authentication and pagination logic.
    • Data Privacy & Governance:
      • Key Responsibilities: Conducting quarterly data privacy audits, exploring & reviewing the need for implementation of Microsoft Purview for automated data classification, and ensuring all architectures meet GDPR and other local data privacy standards.
      • Expected Outputs:
        • Quarterly RAG (Red/Amber/Green) Audit Reports.
        • Remediation & Risk Mitigation Plan.
        • Data Lineage & Sensitivity Maps in Microsoft Purview. (If Purview emerges as a potential solution for our existing data governance needs)

• Analytics Support:
  • Key Responsibilities: Developing advanced Power BI dashboards and providing technical recommendations for performance tuning within the F64 capacity to prevent “usage creep”.
  • Expected Outputs:
    • Library of Live, governed PowerBI dashboards
    • Quarterly capacity Optimisation & tuning report
    • Hands-on skills transfer workshops for internal staff