Job Description :
Job title: Meta Data Analyst
Location: Columbia SC
Duration:1+years
Metadata Management:
Metadata management from ingestion to consumption supporting all data governance functions
Data Classification and Prioritization
Data Tagging and custom regular expressions
Data Access Governance
Import & maintenance of metadata across platforms
Reverse engineering of Data models
Integrate Data transformation jobs
Change control mechanisms (following deployment schedules)
Bulk Import of Glossaries
Data Lineage:
Responsible for Lineage that is consumable & actionable for Business users
Generate Lineage for all identified CDEs
Discover broken links and create manual overrides
Custom scripting for generating Lineage on parameterized jobs
Additional tagging for discovering Business Lineage
Data Quality:
Strong experience with entire data quality lifecycle: Profile, Standardize, Enrich and Remediate
Custom profiling on data elements beyond basic dimensions for finding anomalies
Ability to define data quality rules based on Governance Policies and/or Business Rules
Schedule & monitor batch data quality processes for standardization and enrichment
Further logging & tracking of data quality issues to remediation by working with respective stakeholders
Dash-boarding of aggregated data quality exception results and respective metrics
Technical Toolset:
(Strong hands-on expertise with…)
Databases: SQL Server, Oracle, Essbase, SSAS
Data Modeling: ER Studio (or Erwin) with Deep Operational & Dimensional modeling and mapping experience
Data Governance MDM): Collibra, Axon, Reltio, Profisee, Alation or similar
Data Integration: SSIS
Data Quality: Informatica Data Quality, IBM Quality Stage & Information Analyzer or similar
BI: Tableau, Hyperion, Cognos, SSRS or similar
Environment: On-prem and Cloud
Advanced: AI/ML based tools experience a bonus