Loading
Client Problem:
A tier-1 bank operated across risk, finance, treasury, AML, and retail lines of business
with
fragmented definitions (e.g., “customer,” “exposure,” “net interest income”). Ownership
was unclear,
lineage was incomplete, and audit evidence for BCBS 239/SOX/privacy took weeks to
compile. The client
needed a Collibra-based catalog with clear stewardship, automated lineage, and workflows
that enforce
policy with measurable SLAs.
Steps to Solve the Problem:
Workshops across Risk/Finance/Data Office; identified critical data elements (CDEs) and high-value use cases.
Defined a phased roadmap prioritizing customer, product, exposure, and finance domains.
Established stewardship roles and RACI; glossary conventions; certification/attestation cadence.
Baseline policies for quality, access/privacy, and retention aligned to regulatory needs.
Configured communities/domains, SSO/SCIM groups, and least-privilege entitlements.
Set admin guardrails, audit logging standards, and adoption KPIs.
Onboarded EDW/lakehouse, core banking, AML, and BI platforms via Collibra Edge/scanners with schedules.
Applied classifications/tags for PII/sensitivity and standardized curation templates.
Imported lineage from SQL/dbt/ETL and stitched raw → curated → semantic layers; linked to CDEs.
Introduced quality KPIs and issue workflows tied to business impact and SLAs.
Built BPMN workflows for data-usage approvals, attestations, onboarding, and issue management.
Enabled Data Marketplace for request routing, escalations, and evidence capture.
Role-based enablement for stewards/admins/analysts; runbooks and hypercare; enhancement backlog.
Published monthly operational reports on adoption, scan coverage, and SLA performance.
How We Achieved Success:
Unified glossary and stewardship improved audit readiness; automated lineage accelerated impact analysis for regulatory change.
Attestations and workflow evidence reduced time to compile audit packages from weeks to days.
Self-service catalog and Marketplace cut dataset discovery time; clear SLAs reduced email loops.
Usage dashboards increased transparency across lines of business.
Repeatable onboarding patterns accelerated integration of new sources and domains.
Runbooks and KPI tracking established a sustainable governance operating rhythm.
Delivering a production-grade Collibra platform with workflows, lineage, and a robust operating model enabled faster, trusted analytics and confident regulatory reporting.