Senior MDM Analyst

*Only Local to texas candidates are applicable*

Responsibilities
Profile source data and measure data quality (completeness, uniqueness, validity and consistency)
Define and tune match, merge, and survivorship rules in Ab Initio including thresholds, weights and exception handling in collaboration with data stewards
Investigate data anomalies/issues reported by Business and Root-cause duplicates and false merges. Provide recommendations for mitigation and drive fixes upstream
Build dashboards and reports on match accuracy, duplicate rate, MDM health, stewardship backlog, and business impact
Configure and tune rules, deduplication routines, and survivorship criteria to ensure a single source of truth in data set.
Write requirements, mappings, and acceptance tests for MDM integrations
Work with ETL, Replication and DBA teams to determine data transformations, data movement and derivations and document accordingly
Work with Data Stewards on review queues; define unmerge and remediation processes
Build and optimize data integration workflows connecting source systems to centralized MDM hub
Partner with analysts, data governance teams, and business stakeholders to implement master data management at Oncor.
Support Data Governance functions such as definitions, ownership, documenting lineage, data standardization, and dictionary.
Work with support teams to ensure consistent and pro-active support methodologies are adhered to for all aspects of data movements and data transformations
Assist in break fix and production validation as it relates to data derivations, replication and structures
Ability to explain data problems to non-technical stakeholders

Qualifications
15+ years in data analysis with 2 or more years in MDM or data quality
Advanced SQL; hands-on data profiling and reconciliation is essential
Previous experience working with Oracle Exadata and SQL Server databases
Experience with an MDM platform (Ab Initio preferred)
Extensive working knowledge of Data Governance, ETL, REST API development, OLAP and best practices for data tracking
Ability to work in a team-oriented, fast-paced agile environment managing multiple priorities
Ability to explain data problems to non-technical stakeholders
Strong attention to Detail
Ability to collaborate effectively and work as part of a team
Denodo Experience a plus
Big Data Experience a plus (Hadoop, MongoDB)
Postgres and Cloud Experience is a plus
Regulated Industry experience is a plus