By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    football analytics
    The Role of Data Analytics in Football Performance
    9 Min Read
    data Analytics instagram stories
    Data Analytics Helps Marketers Make the Most of Instagram Stories
    15 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    What to Know Before Recruiting an Analyst to Handle Company Data
    6 Min Read
    AI analytics
    AI-Based Analytics Are Changing the Future of Credit Cards
    6 Min Read
    data overload showing data analytics
    How Does Next-Gen SIEM Prevent Data Overload For Security Analysts?
    8 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Five Attributes for the Data Quality Analyst
Share
Notification Show More
Aa
SmartData CollectiveSmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Mining > Five Attributes for the Data Quality Analyst
Data Mining

Five Attributes for the Data Quality Analyst

DataQualityEdge
Last updated: 2009/03/05 at 9:46 PM
DataQualityEdge
6 Min Read
SHARE

In my years working in data quality I have seen many skills and attributes of what a good data quality analyst must have under their belt.

As a result I believe a data quality analyst must…

Be proactive: Many times the media catches a snip-it of some disastrous event which was the result of bad data quality. Or the masses that are your company’s customers have congregated on Facebook to strike down the corporate beast you work for, because of bad billing or bad customer service.

One must ask…why is there bad billing or bad customer service? One fundamental reason is…

More Read

data mining

Data Mining Technology Helps Online Brands Optimize Their Branding

Can Data Mining Aid with Off-Page SEO Strategies?
3 Data Mining Tips for Companies Trying to Understand their Customers
5 Data Mining Tips to Leverage the Benefits of Surveys
Perform Data Mining With Web Scrapers to Track Prices


In my years working in data quality I have seen many skills and attributes of what a good data quality analyst must have under their belt.

As a result I believe a data quality analyst must…

Be proactive: Many times the media catches a snip-it of some disastrous event which was the result of bad data quality. Or the masses that are your company’s customers have congregated on Facebook to strike down the corporate beast you work for, because of bad billing or bad customer service.

One must ask…why is there bad billing or bad customer service? One fundamental reason is the fact that the data is not quality data. Ultimately, if you bill someone more then they should be billed, you will have a bad reputation and be considered to have poor customer service. It’s all about perception. So what to you do to prevent such things. Be proactive, don’t sit back and wait for someone to say “I think the order provisioning system has bad data?” or “We billed the Smith family $3000.00 when we should have billed them $30.00!” You don’t want those statements to come to you. You want to be proactive and look for the bad data, you want to trend the data so when it finally breaks the trend you know you have something worth looking into. You want to look at the ETL that project ABC is bringing into your data warehouse. You want to review the data dictionary and ensure that all the “t’s” are crossed and “i’s” dotted. You want to establish quality checks up front, before the data is loaded. You want to be proactive.

Be relentless: When a data issue emerges tackle it. Be ruthless, be relentless, when the developers say they don’t know the business and the business says they don’t know the script or code. Bring the two together and resolve the issue. They’ll be a time when someone passes the buck or tries to brush you off. Don’t take no for an answer. Escalate if you want to get answers. Be relentless.

Be technically savvy: Knowing basic SQL in a data warehouse environment is worth your weight in gold. At the least you must know a little SQL so that you can look at the data in different patterns and omit specific values to perform a better analysis of the data to ensure it’s quality. You do not want to rely entirely on a predefined report that someone created before your arrival. Data is always changing and you must be able to adapt and change with it. You must have some basic SQL skills and be technically savvy. Eventually your expertise will increase.

Be personable: You might ask why if I worked with data do I have to be personable? Let’s face it. You are a data quality analyst, if you are questioning the data coming into the data warehouse from the orders department, do you think they want to correct the issue for you. No they want you to fix the problem. So be personable! Scratch a few backs and someone will scratch yours. It’s all about being a team, no matter how large of an organization you are working in, you are all part of the same team, with the same goal and that is to succeed.

Know the business: A data quality analyst who isn’t business oriented would be someone who really reads reports and says, “Ah! Bad data again! We’d better fix it.” An analytical data quality expert would be intimate with the data. They can look at the trends, outliers and more and have an understanding of what the data is saying about the business. So when there’s a quality threshold spike on a data object, you immediately know it’s related to what the business is doing. This will save you investigation time and money.

DataQualityEdge March 5, 2009
Share This Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

football analytics
The Role of Data Analytics in Football Performance
Analytics Big Data Exclusive
smart home data
7 Mind-Blowing Ways Smart Homes Use Data to Save Your Money
Big Data
ai low code frameworks
AI Can Help Accelerate Development with Low-Code Frameworks
Artificial Intelligence
data Analytics instagram stories
Data Analytics Helps Marketers Make the Most of Instagram Stories
Analytics

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

data mining
Data Mining

Data Mining Technology Helps Online Brands Optimize Their Branding

7 Min Read
data mining helps with offsite SEO
Data Mining

Can Data Mining Aid with Off-Page SEO Strategies?

10 Min Read
using data mining to learn more about customers
Big Data

3 Data Mining Tips for Companies Trying to Understand their Customers

6 Min Read
surveys data
Data Mining

5 Data Mining Tips to Leverage the Benefits of Surveys

11 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?