Senior MDM Engineer

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

You’ll own the match, merge, and survivorship rules for Oncor’s transmission and distribution data. You’ll support and analyze data anomalies for source data originating in multiple environments including but not limited to Data Warehouse, ODS, Data Replication/ETL and other Data Management initiatives. You will closely collaborate with the Business users and the Data Management team members such as Business Analysts, DBA, ETL developers, Application developers and Data Architects to support complex Data related initiatives. You will also be responsible for assisting in the initial setup and on-going documentation/configuration related to Data Governance and Master Data Management solutions. You have a passion for data, along with good SQL, analytical and communication skills.

Job Title: Senior MDM Engineer

Duration: 12+ months

Work Mode: Hybrid

Vis: C2C/ W2

Note: Local Candidates Preferred: Candidates must be currently located in or near Dallas, TX. H1B, Green Card, and U.S. Citizens are welcome to apply. Relocation candidates will not be considered.

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

• Strong hands‑on experience with Enterprise Master Data Management (MDM) platforms.
• 15+ years in data analysis with strong expertise 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
• Big Data Experience a plus (Hadoop, MongoDB)