## Data Governance Design and Implementation Recommendations

A robust Data Governance Design and implementation plan provides a structured approach for managing organization's data assets, ensuring data quality, security and compliance with regulations.

#### Purpose ‼️

The purpose of this document is to provide DG Program Framework and Design recommendations to align with customer's data operations with the recommended policy.

#### Scope

>[!Note]

This Design Document applies to all Company offices, departments and operating entities.

#### Roles and Responsibilities

1.1. Current State ✅

==Customer currently has informal roles and responsibilities in their information lifecycle management practice. Each department (data domain) is responsible for creating and storing their data in company approved locations with some help from central IT team==

==The data design, storage, us and archival, destruction processes are not forma;lized at an enterprise level.Each department is responsible for these processes, if they are implementing them.==

> [!CAUTION]
Implication: without official roles for the approval and issue resolution process, data quality may be at stake.

1.2 Future State 🔮

`Customer should establish Data Governance Framework that utilizes formal roles in the information management lifecycle to ensure safe and reliable data. The following roles should be established.`

### General Data Governance Organizational Framework

>[!Important]

*The guiding body for data governance is the Data Governance Council, which defines and oversees the governance frameowk, data owners, data stewards and subject matter experts enact the governance framework in practice and report back to the governance council.*

#### Data Governance Council

| Data Owner | | Data Owner | | Data Owner | | Data Owner | |
|:------------:| --- |:------------:| --- |:------------:| --- |:------------:| --- |
| Data Steward | SME | Data Steward | SME | Data Steward | SME | Data Steward | SME |

> [!TIP]Take a look at the flow chart

###### Data Governance Council

---

graph TD;
    A{Data Owner} --> B(Data Steward);
    A --> C[SME];
    B --> D[Master Information];
    C --> E[Master Information];
    D --> F[Data Custodians];
    E --> F;

<style>
.blue {color: purple;}
</style>

### <span class="blue">**Responsibilities**</span> 🧑‍🏫

#### Data Governance Council

- Structures and oversees governance
- Creates and drives policy
- Monitor legal and regulatory compliance
- Resolve conflicts
- Approves business change porposals
____________

#### Data Owner

- Accountable for the data
- Set standards for policies
- Operates governance processes
- Reports singificant risks to DG council

____________

#### Data Steward

- Implements policies and standards
- Ensures users follow policies
- Identifies and manages risk

____________

#### Subject Matter Expert (SME)

- Aides in the classification of data
- Supports ongoing profiling activities
- Identifies quality isusues for resolution

____________

| Title | What | Who |
|:-----------------------:|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------:|:--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------:|
| Data Governance Council | A Data Governance Council (DGC) is a group of people within an organization that sets and enforces policies, standards and procedures for data management and governance. | The council should be made up of experts and key stakeholders from IT, legal, compliance, and representatives from working groups. There shoudl be one data governance council for the enterprise. |
| Data Custodian | A team that is responsible for protecting data, managing systems and servers, providing secure infrastructure, and implementing policies set forth by the data governance council. | This team should be comprised of data analysts and managers with technical acumen in data management and administration. Data custodian should be a central team. |
| Data Stewards | A data steward is responsible for protecting data, managing systems and servers, providing secure infrastructure, and implementing policies set forth by the data governance council. | This team should be comprised of data analysts and managers with technical acumen in data management and administration. Data custodian should be a central team. |
| Data Owners | In conjunction with working groups and the Data Governance Council, data owners are responsible for defining data access permissions, ensuring data accuracy and integrity, determining data usage policies, and overseeing compliance and relevant regulations and internal standards. | Each Domain should have data owner. This individual should have decision making authority and ability for regular meetings with data custodians, stewards and councils. |
| Working Groups | Data Governance working groups are responsible for ensuring data governance policies are implemented within their relevant departments and ensuring commonly used data and templates is approved across all relevant departments. | Customer can form working gorups based on data that is commonly shared among data domains. See below for working group recommendations. |

#### Data Governance Roles Interaction

Working groups are comprised of data owners and stewards to implement data policies, ensure data quality, and put forth templates that are to be reviewed. These groups have a regular review cadence with the data governance council and data custodians to report any ongoing data issues and/or request new data governance initiatives to ensure the enterprise data is secure and relevant to the strategic goals of the business departments, or data domains. The data governance council reports any issues and initiative requests to the board and c suite stakeholders via an identified executive sponsor. The data governance council should utilize the established governance process for reporting relevant material to committees, boards, and executive sponsors.

1.3 Working Groups

Below are proposed working groups for customer. These domains share and access much of the same data on a regular enough basis to necessiate regular working sessions regarding data governance policy implementations and data design.

==Example of Financial and Family Services for ABC Client==

>[!Note]

This is just sample ⚠️

graph TD;
    A[**Data Governance Council** - *Senior level leadership representing the data domains and steering commitee.*] --> B[**Data Governance Working Group** - *Representatives from reltaed domains that share a large amount of data*];
    B --> C[Family Services Director];
    B --> D[Tax Director];
    B --> E[Accounting Director];
    B --> F[Treasury Director];
    B --> G[Trusts Director];
    B --> H[Foundations Director];
    C --> I[Analyst];
    I --> J{{SharePoint/OneDrive}};
    D --> K[Analyst];
    K --> L{{SharePoint}};
    K --> M{{Dynamics}};
    E --> N[Analyst];
    N --> R{{Dynamics/Advent}};
    N --> W{{SharePoint}};
    F --> O[Analyst];
    O --> S{{IRS TAx Software}};
    G --> P[Analyst];
    P --> T{{SharePoint}};
    H --> Q[Analyst];
    Q --> U{{Dynamics}};
    ;

==Data Custodians==

#### Data Governance RACI

The data governance RACI establishes responsibilities of each role/group in the proposed Data Governance Framework. It covers a range of tasks from one-time meetings, ongoing efforts, and a large scale implementation.

This is just sample ⚠️

| Responsibility | Data Governance Council | Data Steward | Data Owner | Data Custodian | Data User |
|:-------------------------------------------------------------------------------:|:-----------------------:|:------------:|:----------:|:--------------:|:---------:|
| Design Storage Solutions | RA | IC | IC | C | I |
| Implement storage solutions | A | IC | IC | RA | I |
| Assess new technologies or storage solutions for data domains | RA | C | IC | R | I |
| Establish Data Quality Standards | C | RA | C | I | I |
| Implement new technologies or storage solutions for data domains | A | IC | IC | RA | I |
| Create data policy including those based on regulatory and compliance standards | RA | C | C | C | I |
| Design Domain Data | IC | RA | A | I | I |
| Create Domain Data | I | RA | A | I | R |

:::info
:information_source: Info
:::

==Sample of Recommendations Implementation Timeline==

gantt
    title Timeline and Implementation Roadmap
    dateFormat  MM-DD
	axisFormat  %m-%d
		
section Foundational Initiatives
    Timeline : crit, done, plan, 05-15, 30d
    Identify candidates to fullfill DG Framework : active, work, after plan, 95d
    DG Council review policies : test, 08-20, 60d
	Assess and Design : A and D, 10-10, 45d
    Def Council rev cycle: DG Council, 08-20, 55d
    Est Info Man Workfl: Info, 09-20, 45d
    
section Data Architecture
    Assess & Design ShareP and Dyn FS:b1, 06-29, 95d
    Tool Implem :b2, 09-25, 30d
    Migration Planning : after b2, 40d
    
section Data Storage & Ops
    Stewards Impl policies and workflows: active, wire, 06-29, 95d
    Tool Assess: implement, after wire, 24d
    Impl DG: implement, 10-15, 20d   
    SharePoint Migration: crit, uxt, after implement, 45d