Senior MDM Analyst

Peyton Resource Group; Dallas (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Peyton Resource Group is seeking a Senior MDM Engineer to own match, merge, and survivorship rules for transmission and distribution data. You will analyze data anomalies across the data warehouse, ODS, ETL, and other data management initiatives while collaborating with business users and data teams.

The role emphasizes a passion for data, strong SQL, analytical skills, and clear communication. You will help document configurations, support data governance, and develop scalable data integration

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 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 while managing multiple priorities.
• Ability to explain data problems to non-technical stakeholders.

Responsibilities

• Data Quality & Profiling: Profile source data and measure data quality.
• Match, Merge & Survivorship: Define and tune match, merge, survivorship rules with data stewards.
• Integration & Development: Build data integration workflows to the centralized MDM hub; write mappings and tests.
• Reporting: Build dashboards and reports on match accuracy and MDM health.
• Data Governance & Support: Support governance, lineage, data dictionary, and single source of truth.

Skills

Advanced SQL

Data profiling

Data governance

ETL development

REST API development

OLAP

Data analytics

Team collaboration

Attention to detail

Tools

Ab Initio

Oracle Exadata

SQL Server

Denodo

Hadoop

MongoDB

Postgres

Job description

Senior MDM Engineer Position Summary The Senior MDM Engineer owns the match, merge, and survivorship rules for transmission and distribution data. This role supports and analyzes data anomalies in source data originating from multiple environments, including the Data Warehouse, ODS, Data Replication/ETL, and other Data Management initiatives. The engineer collaborates closely with business users and Data Management team members (Business Analysts, DBAs, ETL developers, Application developers, and Data Architects) on complex data initiatives, and assists with the initial setup and ongoing documentation and configuration of Data Governance and Master Data Management solutions. The ideal candidate has a passion for data, along with strong SQL, analytical, and communication skills.

Key Responsibilities

• Data Quality & Profiling
  • Profile source data and measure data quality (completeness, uniqueness, validity, and consistency)
  • Investigate data anomalies and issues reported by the business;root-cause duplicates and false merges
  • Provide mitigation recommendations and drive fixes upstream
• Match, Merge & Survivorship
  • Define and tune match, merge, and survivorship rules in Ab Initio, including thresholds, weights, and exception handling, in collaboration with data stewards
  • Configure and tune rules, deduplication routines, and survivorship criteria to ensure a single source of truth
  • Work with Data Stewards on review queues;define unmerge and remediation processes
• Integration & Development
  • Build and optimize data integration workflows connecting source systems to the centralized MDM hub
  • 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
• Reporting
  • Build dashboards and reports on match accuracy, duplicate rate, MDM health, stewardship backlog, and business impact
• Data Governance & Support
  • Support Data Governance functions, including definitions, ownership, lineage documentation, data standardization, and data dictionary
  • Partner with analysts, data governance teams, and business stakeholders to implement master data management
  • Work with support teams to ensure consistent, proactive support methodologies for all aspects of data movement and transformation
  • Assist with break-fix and production validation related to data derivations, replication, and structures
  • Explain data problems to non-technical stakeholders

Qualifications

• Required 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 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 while managing multiple priorities
• Ability to explain data problems to non-technical stakeholders
• Strong attention to detail
• Ability to collaborate effectively as part of a team
• Preferred Denodo experience
• Big Data experience (Hadoop, MongoDB)
• Postgres and cloud experience
• Regulated industry experience