Senior MDM Engineer: Data Governance & Quality (Hybrid)

CTC; Dallas (TX); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Oncor is seeking a Senior MDM Engineer to own match, merge, and survivorship rules across enterprise data. You will analyze anomalies across DW/ODS/ETL environments and collaborate with data stewards, DBAs, and developers to support complex data initiatives. Strong SQL, data governance, and communication skills are essential.

The role is hybrid in Dallas, TX, with a focus on creating a single source of truth and supporting master data management efforts. Local candidates preferred.

Qualifications

• 15+ years in data analysis with expertise in MDM or data quality.
• Advanced SQL; strong data profiling and reconciliation required.
• Experience with Oracle Exadata and SQL Server databases.
• Experience with Ab Initio MDM platform.
• Knowledge of Data Governance, ETL, REST APIs, OLAP, and data lineage.
• Able to work in agile, team-focused environment and explain issues to non-technical stakeholders.

Responsibilities

• Profile source data and measure quality across completeness, uniqueness, validity, and consistency.
• Define and tune match, merge, survivorship rules in Ab Initio with thresholds and weights.
• Investigate data anomalies, root-cause duplicates, and mis merges; propose fixes.
• Build dashboards and reports on match accuracy, duplicates, and MDM health.
• Configure and tune deduplication rules and survivorship criteria for single source of truth.
• Write requirements, mappings, and acceptance tests for MDM integrations.
• Collaborate with ETL, replication, and DBA teams on data transformations and movement.
• Work with Data Stewards to define remediation and unmerge processes.
• Help implement master data management with Oncor stakeholders.
• Support Data Governance: definitions, ownership, lineage, and data dictionary.
• Assist in break-fix and production validation related to data derivations.

Skills

MDM platforms

Advanced SQL

Data profiling

Data quality

Oracle Exadata

SQL Server

Ab Initio

REST API development

OLAP

Big Data (Hadoop/MongoDB)

Tools

Ab Initio

Oracle Exadata

SQL Server

REST API

Job description

Oncor is seeking a Senior MDM Engineer to own match, merge, and survivorship rules across enterprise data. You will analyze anomalies across DW/ODS/ETL environments and collaborate with data stewards, DBAs, and developers to support complex data initiatives. Strong SQL, data governance, and communication skills are essential.

The role is hybrid in Dallas, TX, with a focus on creating a single source of truth and supporting master data management efforts. Local candidates preferred.