MDM & Data Quality Architect — Hub & Governance

CTC; United States; On-site; USD 140,000 - 190,000; Full time

Job summary

Oncor is seeking a senior data professional to support data governance and master data management initiatives across multiple environments, including ETL, data warehousing, and data replication. You will analyze data quality, define survivorship rules, and collaborate with business users and IT teams to ensure a single source of truth.

The role requires deep SQL proficiency, experience with MDM platforms (Ab Initio preferred), and strong communication to translate data problems for non-technical

Qualifications

• 15+ 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 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.
• Big Data Experience a plus (Hadoop, MongoDB).

Responsibilities

• Profile source data and measure data quality (completeness, uniqueness, validity and consistency).
• Define and tune match, merge, and survivorship rules in Ab Initio with thresholds and weights.
• Investigate data anomalies and root-cause duplicates; recommend fixes.
• Build dashboards and reports on data quality and MDM health.
• Configure deduplication routines and survivorship criteria for a single source of truth.
• Write requirements, mappings, and acceptance tests for MDM integrations.
• Collaborate with ETL, Replication, and DBA teams on data transformations.
• Work with Data Stewards on review queues and remediation processes.
• Build and optimize data integration workflows to centralized MDM hub.
• Partner with analysts and stakeholders to implement master data management.
• Support Data Governance definitions, lineage, and data standards.
• Assist support teams with data movement and transformation governance.
• Aid in break fixes and production validation related to data derivations.
• Explain data problems to non-technical stakeholders.

Skills

Advanced SQL

Data profiling

Data reconciliation

MDM

Ab Initio

Oracle Exadata

SQL Server

Data Governance

ETL

REST API

OLAP

Big Data

MongoDB

Tools

Ab Initio

Oracle Exadata

SQL Server

Job description

Oncor is seeking a senior data professional to support data governance and master data management initiatives across multiple environments, including ETL, data warehousing, and data replication. You will analyze data quality, define survivorship rules, and collaborate with business users and IT teams to ensure a single source of truth.

The role requires deep SQL proficiency, experience with MDM platforms (Ab Initio preferred), and strong communication to translate data problems for non-technical