Bachelor's degree in Bachelor's Degree in Business Administration, Computer Science, CIS or related field, or equivalent work experience.
5 years of experience working in a Data Quality Analyst or Data Analyst role in the Retail and/or CPG Industry
Very proficient in SQL, and variants (e.g. in different platforms).
Good understanding of, and ability to utilize, technical metadata present in database platforms.
Can effectively manipulate and analyze large amounts of data.
Ability to read, understand and assess data models.
Familiarity with types of data quality issues and approaches to their resolution.
Experience with common data analyst support tools
Experience with data mapping (Source to Target entity and attribute mapping).
Excellent communication skills, presentation and interpersonal skills are required.
Strong organizational skills and the ability to multi-task.
Ability to think creatively, is highly-driven and self-motivated.
Ability to present complex information in a simplified fashion to facilitate understanding.
Can demonstrate creative problem-solving skills.
Proficient with MS Office products.
Experience using automated data profiling and quality tools, such as Ataccama, SAS (Data Flux), Informatica, Trillium, Experian, Pitney Bowes, Talend etc, is a definite plus
Experience with a third-party Master Data Management platform, such as Profisee, Ataccama MDM, Orchestra Networks
Experience with data modeling tools such as Erwin or ER/Studio
Experience with Data Catalog, Business Glossary and/or Metadata Repository tools is a plus
Understanding of common data services, especially ETL, backup, restore, role-based security.
Advanced knowledge of the principles of data quality management, including metadata, lineage, and business definitions, implements data quality improvement procedures and policies. Evaluate processes for gaps and inefficiencies and provide recommendations for improvement.
Advanced knowledge of master data management concepts, principles and processes.
Ability to statistically survey (profile) and analyze data by both automated and manual means.
Ability to identify, catalog and assess data quality defects and anomalies, recommend alternatives for resolving the issues, and formulate remediation plans for executing approved recommendations.
Knowledge of industry data standards in the retail or CPG Industry, such as GS1, GDSN, and/or ARTS.
Ability to communicate source data issues to business users and stakeholders in business terms, so that the implications and impact of these issues can be understood.
Ability to collaborate with business and technical users in the resolution of ongoing data quality issues, assisting the drive towards root cause solutions.
Ability to configure and automate data profiling tools to survey master data sets.
Ability review to read and understand conceptual, logical, and physical data models, and communicate effectively with data modelers regarding data integrity issues.
Ability to capture metrics about data environments, such as frequency of different types of data quality issues, and to report effectively on these to business and IT stakeholders.
Ability to conduct manual data quality analysis when no formal data quality tool is included in project