SimplyCPA
CPA/ISC/Data Management & Governance

Data Management & Governance

The data life cycle, data quality dimensions, and governance roles and frameworks.

Medium 50 minArea I: Information Systems and Data Management

The data life cycle

  1. Definition — what the data element means and how it's structured
  2. Capture / creation — controls at the point of entry matter most here
  3. Storage — encryption, classification, retention
  4. Usage / processing — access control, audit logging
  5. Sharing / transmission — encryption in transit, third-party agreements
  6. Archival — retention schedules, retrievability
  7. Destruction — secure, documented, irreversible disposal

Dimensions of data quality

DimensionQuestion it answers
CompletenessIs anything missing?
AccuracyDoes it reflect reality?
ConsistencyDoes it agree across systems?
TimelinessIs it current enough to be useful?
ValidityDoes it conform to defined formats and rules?
UniquenessAre there duplicates?

Governance roles

  • Data owner — a business leader accountable for a data domain; approves access and classification
  • Data steward — manages quality, definitions, and standards day to day
  • Data custodian — IT function that stores and safeguards the data technically
  • Data user — consumes data within approved rules

IMPORTANT: Governance separates accountability (owner decides who may access and how data is classified) from custody (IT implements and protects). Blurring these — for example, letting IT decide who gets access to payroll data — is a governance weakness.

Master data management

MDM creates a single authoritative record for core entities — customers, vendors, products, employees — reducing duplicates and conflicting values across systems. Poor master data is a common root cause of duplicate vendor payments and unreliable reporting.

EXAM TIP: ETL (Extract, Transform, Load) moves data into a warehouse with transformation before loading; ELT loads raw data first and transforms it later inside the target platform. Either way, data validation during transformation is a key control point.