Job Description :
Job title: Data Analyst Location: Columbia ,SC. Duration: Long term Knowledge & Experience: Overall Data Management and Governance Frameworks like: DAMA/DMBOK and DCAM/DGI Business Glossary & Taxonomy Data Architecture & Modeling Master Data Management Data Warehousing & Business Intelligence Data Custodianship Experience with Collibra or similar Data Governance Tool Strong Expertise in: 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 Qualifications: Bachelor s degree in Information Technology or similar subject area A minimum of (10-15) seven years of relevant experience 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 amp; MDM): Collibra or similar Data Integration: SSIS BI: Tableau, Hyperion, Cognos, SSRS or similar Environment: On-prem and Cloud