Senior MDM Engineer: Hybrid Data Governance & Quality

Amtex Enterprises Inc.; Dallas (TX); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Amtex Enterprises Inc. is seeking a Senior MDM Engineer to own matching, merging and survivorship rules across diverse data environments.

You will support data governance initiatives, analyze anomalies, and collaborate with BA, DBA, ETL developers and data architects to drive data management initiatives. The role requires strong SQL, data profiling and reconciliation skills, plus experience with an MDM platform (Ab Initio preferred).

Qualifications

• 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 data tracking best practices
• Ability to work in a team-oriented, fast-paced agile environment managing multiple priorities

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 with data stewards
• Investigate data anomalies/issues reported by Business and root-cause duplicates and false merges, recommending 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

Skills

Advanced SQL

Data profiling

Data reconciliation

MDM data management

Agile teamwork

REST API development

OLAP

Data Governance

ETL

Tools

Ab Initio

Oracle Exadata

SQL Server

Hadoop

MongoDB

PostgreSQL

Job description

Amtex Enterprises Inc. is seeking a Senior MDM Engineer to own matching, merging and survivorship rules across diverse data environments.

You will support data governance initiatives, analyze anomalies, and collaborate with BA, DBA, ETL developers and data architects to drive data management initiatives. The role requires strong SQL, data profiling and reconciliation skills, plus experience with an MDM platform (Ab Initio preferred).