What is a 'Golden Source' in this context?

A 'Golden Source' or Master Data Management (MDM) hub is the authoritative repository that ensures a single version of truth for instrument and client data across an entire organization.

Can this help with KYC and client onboarding systems?

Yes, it includes detailed data models for Client Master and Account Master systems, covering legal entities, regulatory identity data, and complex household relationships.

How does it handle pricing data validation?

The skill defines multi-source pricing hierarchies, stale price detection thresholds, and automated validation checks to prevent incorrect valuations from propagating to downstream systems.

What financial identifiers does this skill support?

It provides patterns and logic for mapping and managing major financial identifiers including CUSIP, ISIN, SEDOL, FIGI, and internal firm-generated IDs.

Reference Data & Security Master

Name: Reference Data & Security Master
Author: JoelLewis

byJoelLewis

•

Database Management

Designs and manages authoritative reference data systems including security masters, client models, and multi-source identifier mapping for financial services.

This skill provides specialized guidance for building and maintaining robust reference data infrastructure within financial institutions. It covers the architectural design of security, client, and account masters, alongside complex identifier mapping (CUSIP, ISIN, FIGI) and pricing validation workflows. By implementing these patterns, developers can establish a 'golden source' for data, ensuring consistency across trading, compliance, and reporting systems while managing the data lifecycle, vendor hierarchies, and governance protocols. It is essential for teams building investment management, trading, or fintech platforms that require high data integrity.

Key Features

01Security Master architecture and asset-class attribute modeling

02Client and Account Master data modeling for KYC and onboarding

03Multi-vendor identifier mapping (CUSIP, ISIN, SEDOL, FIGI)

04Reference data governance frameworks and audit trail implementation

0518 GitHub stars

06Pricing data management with validation and vendor hierarchy

Use Cases

01Building a centralized security master database for an asset management platform

02Resolving data quality issues caused by stale prices or inconsistent identifiers across systems

03Designing a Master Data Management (MDM) strategy for client and account onboarding

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add joellewis/finance_skills reference-data

For use in Claude.ai and ChatGPT

Download Skill