Senior MDM Analyst

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