02 April 2015


Shaun Russell - Informatica

10Posts 21,294Views 0Comments

Data Stewardship: the holistic approach

27 March 2014  |  1239 views  |  0

Nine years ago, it seemed like data quality was primarily focused on algorithms and cleansing technology.  Data went in, and the “best” solution was the one that could do the best job of fuzzy matching the data and cleaning more data than the other products.  Of course, no data quality solution could clean 100% of the data so “exceptions” were dumped into a file that were left as an “exercise for the user” to deal with on their own. 

As a result, it was very much left to the user to handle, correct and amend in a spreadsheet , then someone would write an SQL query to write the corrections back into the database. Obviously, this is a hugely laborious and manual process, with little “effective” governance on data quality.

The problem with this is that just in a few companies there are roles dedicated to stewarding and managing data integration effectively.  Employers need to recognise that time and dedication is needed to ensure there is an effective way of consolidating data, and making the appropriate changes. In the end, data quality is a business issue, supported by IT, but the business facing part of the solution has long been missing.

But that is about to change.  There are solutions which can help to provide scalable ways to handle data quality management and integration processes. These solutions can provide a completely governed process for managing remediation of data exceptions by business data stewards. This allows organisations to create their own customised process with different levels of review.  Additionally, it makes it possible for business users to create their own data quality rules, describing the rules in plain language – with no coding necessary.

Great data is not an accident.  Great data happens by design.  And for the first time, data cleansing can now be combined with a holistic data stewardship process, allowing business and IT to collaborate in order to create quality data that supports critical business processes.



Comments: (0)

Comment on this story (membership required)
Log in to receive notifications when someone posts a comment

Latest posts from Shaun

What’s Driving Core Banking Modernisation?

24 March 2015  |  1240 views  |  0  |  Recommends 0

Scary Times For Data Security

11 December 2014  |  2313 views  |  0  |  Recommends 0 TagsSecurity

Recognise and empower the best customer-facing staff

07 October 2014  |  1946 views  |  0  |  Recommends 0 TagsPaymentsTransaction banking

3 Data Challenges That Frustrate Chief Risk Officers

30 July 2014  |  1792 views  |  0  |  Recommends 1 TagsTrade executionRisk & regulation

6 steps for data quality competency for an underwriter

30 June 2014  |  2953 views  |  0  |  Recommends 0 TagsRisk & regulation

Shaun's profile

job title Head of Financial Services UK&I
location London
member since 2014
Summary profile See full profile »

Shaun's expertise

What Shaun reads
Shaun writes about
Shaun's blog archive
March 2015 (1)2014 (9)

Who's commenting on Shaun's posts

Paul Love
Alex Johnson