Senior MDM Analyst Job Dallas area,Texas USA,IT/Tech

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