Job Description :
Job Role: Data Quality Analyst / Metadata Analyst
Job Location: Tampa, FL (Remote until Pandemic)
Job Duration: 6months
Generic Skills
Performs data profiling and analysis of incoming data sources in scope for the MDM project and prepare reports of findings to share with MDM program and project team members.
Identifies and tracks data quality issues that adversely affect either data integration or data reporting and analytics, conduct impact analysis activities, and recommend actions to mitigate risk to project or solution goals.
Works with client stakeholder groups, such as Data Governance, Data Quality and Enterprise Data Architecture to escalate any issues of global (corporate-wide) significance.
Creates and maintains data mappings between data sources and the MDM platform, to include data transformation rules
Education/ Expertise :
Bachelor's degree from an accredited university or college in computer science, information systems or related discipline
5-7 years’ work experience as a data quality analyst or in a related field.
4 years as a data quality analyst or data analyst in BI or DW environment
Product Knowledge/Tech Skills
Ability to profile data from multiple sources and assess the quality of the data
Ability to prepare and data quality assessment reports
Ability to classify data quality defects and track their progress until resolution.
Ability to work with stakeholders to assess potential risks of data quality issues and prepare remediation plans
Knowledge of reference data management, hierarchy management and code value standardization
Strong SQL skills
Experience using data record matching and deduplication techniques
Advanced Microsoft Excel skills, including pivot tables, charts and graphs, and advanced formulas.
Demonstrated experience in handling large data sets and relational databases.
Ability to read and understand conceptual, logical and physical data models
Understands concepts and application of Business Intelligence tools, demonstrates understanding of relationship between data and business rules and functions.
Nice to have
Experience working with various commercial data profiling and data quality monitoring tools, such as Ataccama Data Quality Analyzer, Experian Pandora Data Quality Analyzer, Talend Data Quality or Informatica Data Quality Analyzer.
Experience working on writing advanced T-SQL queries using MS SQL Server
Experience using self-service Data Preparation tools such as TIBCO Clarity, Alteryx, Monarch or Paxata
Experience formulating and reporting on Data Quality metrics
Experience in creating data quality dashboards using BI / reporting tools such as Spotfire, Tableau, or PowerBI.
Experience with commercial financial application suites such as Fiserv and/or FIS
Knowledge of postal address and international data standards as ISO Currency and Country codes
Knowledge of metadata standards such as ISO/EIC 11179, OMG MoF, CWM, and Dublin Core
Roles or Responsibilities
Performs data profiling and analysis of incoming data sources in scope for the MDM project and prepare reports of findings to share with MDM program and project team members.
Identifies and tracks data quality issues that adversely affect either data integration or data reporting and analytics, conduct impact analysis activities, and recommend actions to mitigate risk to project or solution goals.
Works with client stakeholder groups, such as Data Governance, Data Quality and Enterprise Data Architecture to escalate any issues of global (corporate-wide) significance.
Creates and maintains data mappings between data sources and the MDM platform, to include data transformation rules
Manages reference data sets and update the global reference code repository
Recommends, organizes, and facilitates sessions to create data standards for shared data definitions and common reference codes.
Leads test data preparation activities
Ensures test data is relevant, representative and complies with Client security / compliance restrictions