- The submitter follows the troubleshooting steps in Best Practices for Reporting Data Quality Issues (linked on the ).
- The submitter completes and submits the Data Quality Issue Consultation Form, which creates a ticket in ServiceNow.
- The Data Governance Office (DGO) triages the issue to determine if it should be sent to the data steward.
- The DGO assigns the issue to the appropriate data steward(s) and/or delegate(s).
Next Steps
Within three to five business days, the DGO will coordinate and schedule a meeting with:
-
The submitter
- The Data Governance Manager
- Relevant data steward(s) and/or delegate(s)
If the issue is confirmed as a true data quality issue, the Data Governance Manager will collaborate with stakeholders to complete the , including an . The results will be shared with the submitter and data steward(s).
*The timeline for the following steps will be determined by the data steward based on their prioritization of the need and data quality.
The data steward(s) and/or delegate(s) will assess the issue and will gather information to support root cause analysis from both business and technical perspectives.
Business Perspective
- How is the data captured? Who enters it?
- What is the business process?
- Is this the original data, or has it been transformed/manipulated?
- Are there timing issues (e.g., should the data be real-time but is frozen instead)?
Technical Perspective
- What is the data lineage?
- Are there data transformations?
- What is the data life cycle?
The data steward(s) will also:
- Assess the business impact.
- Determine the resources and effort required.
- Prioritize the issue for resolution planning.
DGO Support: The DGO will assist in the research process as needed.
Available Tools: and the can aid in documentation.
The data steward(s) and/or delegate(s) will identify the root cause by analyzing:
- People: Are manual data entry errors occurring?
- Process: Is the issue caused by process inefficiencies (e.g., late data entry)?
- Technology: Are there system errors (e.g., batch job failures)?
- Other Factors: Is there a combination of issues or an overlooked cause?
Validation: Has the data been verified?
Methodology: The Five Whys technique is recommended to be used for root cause analysis.
DGO Support: The DGO will assist and provide root cause analysis materials.
The data steward(s) and/or delegate(s) will determine and implement a solution, addressing:
- How to correct the issue.
- Implementation steps and required resources.
- Short-term and long-term solutions.
- Priority and feasibility of resolution.
Risk Assessment
If resolution costs are high and impact is low, the data steward may accept the risk of not resolving the issue.
Preventative Controls
Where feasible, safeguards will be added to prevent recurrence. Affected data will be corrected at the source when possible.
DGO Support: The DGO will assist in planning and implementation.
5. Communication and Measurement
Scorecards & Metrics
- Scorecards will track resolution progress using the Impact to Business metrics.
Stakeholder Communication
- The DGO will facilitate updates between data stewards and submitters.
- Submitters will be informed upon issue receipt, given an expected resolution timeline, and notified when the issue is resolved or if the steward has accepted the risk.
User Impact Communication
- The DGO and data steward(s) will determine how to notify affected users.