Senior MDM & Data Quality Analyst

CTC; EE. UU.; Presencial; USD 90.000 - 130.000; Jornada completa

Descripción de la vacante

Oncor seeks a data quality/MDM specialist to profile data quality, define survivorship rules, and resolve data anomalies. You will work with data stewards and IT teams to implement MDM across source systems and ensure a single source of truth.

The role requires advanced SQL, experience with Ab Initio or similar MDM platforms, and strong knowledge of data governance, ETL, REST APIs, and OLAP. Collaboration with business stakeholders is essential.

Formación

• 5+ years in data analysis with 2+ years in MDM or data quality
• Advanced SQL; hands-on data profiling and reconciliation is essential
• Experience with Oracle Exadata and SQL Server databases
• Experience with an MDM platform (Ab Initio preferred)
• Extensive knowledge of Data Governance, ETL, REST API development, OLAP and best practices for data tracking
• Ability to work in a fast-paced agile environment and explain data problems to non-technical stakeholders
• Big Data experience a plus (Hadoop, MongoDB)

Responsabilidades

• Profile data quality and measure data quality across systems
• Define and tune MDM rules, thresholds, and survivorship criteria
• Investigate data anomalies and recommend fixes with data stewards
• Build dashboards on MDM health, match accuracy, and governance metrics
• Configure deduplication routines and survivorship logic for single source of truth
• Write requirements, mappings, and acceptance tests for MDM integrations
• Collaborate with ETL, replication, and DBA teams on data movement and derivations
• Work with Data Stewards on review queues and remediation processes
• Develop data integration workflows connecting source systems to the MDM hub
• Partner with analysts and stakeholders to implement MDM at Oncor
• Support data governance definitions, lineage, data standardization, and dictionary
• Assist in production validation and break-fix related to data derivations

Conocimientos

Advanced SQL

Data analysis

Data profiling

Data reconciliation

Stakeholder communication

Herramientas

Ab Initio

Oracle Exadata

SQL Server

REST APIs

OLAP

Hadoop

MongoDB

Descripción del empleo

Oncor seeks a data quality/MDM specialist to profile data quality, define survivorship rules, and resolve data anomalies. You will work with data stewards and IT teams to implement MDM across source systems and ensure a single source of truth.

The role requires advanced SQL, experience with Ab Initio or similar MDM platforms, and strong knowledge of data governance, ETL, REST APIs, and OLAP. Collaboration with business stakeholders is essential.