Senior MDM Engineer #3408

Genius Road, LLC; Dallas (TX); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Genius Road, LLC seeks a Senior MDM Engineer to lead data quality improvements and governance for critical business data. You will define match, merge, and survivorship rules while collaborating with stakeholders, data stewards, developers, and architects to resolve complex data issues.

The role emphasizes strong SQL capabilities, Ab Initio/MDM platform experience, and cross-team coordination in a fast-paced Agile environment. Dallas hybrid setup with 3 days onsite.

Qualifications

• 5+ years of data analysis experience, including 2+ years in Master Data Management (MDM) or data quality.
• Advanced SQL skills, including hands-on data profiling and reconciliation.
• Experience with Oracle Exadata and SQL Server.
• Hands-on experience with an MDM platform, including configuration and implementation; Ab Initio is preferred.
• Experience designing and implementing MDM integrations, ideally across multiple source systems.
• Demonstrated experience supporting MDM initiatives from requirements and design through implementation and ongoing support.
• Strong understanding of data governance, ETL, REST APIs, OLAP, and data tracking best practices.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication skills, including the ability to explain technical issues to non-technical stakeholders.
• Ability to collaborate across business and technical teams in a fast-paced Agile environment.

Responsibilities

• Profile source data and assess data quality, including completeness, uniqueness, validity, and consistency.
• Define and optimize MDM match, merge, and survivorship rules, including thresholds, weights, and exception handling.
• Investigate duplicates, false merges, and data anomalies; identify root causes and recommend corrective actions.
• Develop dashboards and reports to monitor data quality, match accuracy, duplicate rates, and MDM performance.
• Document requirements, data mappings, and acceptance criteria for MDM integrations.
• Partner with ETL, replication, DBA, and development teams on data transformations, integrations, and data movement.
• Collaborate with data stewards on review queues, unmerge processes, and remediation.
• Support data governance initiatives, including data definitions, ownership, lineage, standardization, and documentation.
• Assist with production troubleshooting, break/fix activities, and validation of data structures, replication, and data derivations.
• Communicate findings and recommendations to technical teams and business stakeholders.

Skills

Advanced SQL

Data profiling

Data governance

Agile environment

Data analysis

Tools

Oracle Exadata

SQL Server

Ab Initio

MDM platform

Job description

Senior MDM Engineer (Master Data Management)

Contract Length: 12-18+ months
Location: Dallas, Texas (hybrid – 3 days onsite) ****LOCAL CANDIDATES ONLY****

Genius Road is seeking a Senior MDM Engineer to support enterprise data management and governance initiatives for a well-established organization in a regulated industry. This role focuses on improving data quality, managing match, merge, and survivorship rules, and ensuring the accuracy and integrity of critical business data. The position involves close collaboration with business stakeholders, data stewards, developers, and data architects to resolve complex data issues and maintain reliable, trusted data.

Required Qualifications

• 5+ years of data analysis experience, including 2+ years in Master Data Management (MDM) or data quality.
• Advanced SQL skills, including hands-on data profiling and reconciliation.
• Experience with Oracle Exadata and SQL Server.
• Hands-on experience with an MDM platform, including configuration and implementation; Ab Initio is preferred.
• Experience designing and implementing MDM integrations, ideally across multiple source systems.
• Demonstrated experience supporting MDM initiatives from requirements and design through implementation and ongoing support.
• Strong understanding of data governance, ETL, REST APIs, OLAP, and data tracking best practices.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication skills, including the ability to explain technical issues to non-technical stakeholders.
• Ability to collaborate across business and technical teams in a fast-paced Agile environment.

Preferred Qualifications

• Denodo experience.
• Big data experience with Hadoop or MongoDB.
• PostgreSQL and cloud experience.
• Experience in a regulated industry.

Key Responsibilities

• Profile source data and assess data quality, including completeness, uniqueness, validity, and consistency.
• Define and optimize MDM match, merge, and survivorship rules, including thresholds, weights, and exception handling.
• Investigate duplicates, false merges, and data anomalies; identify root causes and recommend corrective actions.
• Develop dashboards and reports to monitor data quality, match accuracy, duplicate rates, and MDM performance.
• Document requirements, data mappings, and acceptance criteria for MDM integrations.
• Partner with ETL, replication, DBA, and development teams on data transformations, integrations, and data movement.
• Collaborate with data stewards on review queues, unmerge processes, and remediation.
• Support data governance initiatives, including data definitions, ownership, lineage, standardization, and documentation.
• Assist with production troubleshooting, break/fix activities, and validation of data structures, replication, and data derivations.
• Communicate findings and recommendations to technical teams and business stakeholders.

Genius Road, LLC is proud to be a Certified Women’s Business Enterprise, an Equal Opportunity Employer and values diversity. All employment is decided on the basis of qualifications, merit and business need.