MDM Engineer & Data Quality Analyst - Hybrid Dallas

Amtex Enterprises Inc.; Dallas (TX); Híbrido; USD 90.000 - 120.000; Jornada completa

Descripción de la vacante

Amtex Enterprises Inc. in Dallas, TX is seeking an MDM Engineer/Analyst to own match, merge, and survivorship rules for transmission and distribution data.

You will support data governance, write mapping and acceptance tests, and collaborate with DBA, ETL developers, analysts, and data architects to drive complex data initiatives. The role requires 5+ years in data analysis with 2+ years in MDM or data quality, advanced SQL skills, and experience with Oracle Exadata and SQL Server.

Formación

• 5+ years in data analysis with 2+ years in MDM or data quality.
• Advanced SQL; hands-on data profiling and reconciliation is essential.
• Previous 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 best practices for data tracking.
• Ability to work in a fast-paced agile environment managing multiple priorities.

Responsabilidades

• 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.
• Investigate data anomalies/issues reported by Business and Root-cause duplicates and false merges; provide mitigation recommendations.
• 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.
• Write requirements, mappings, and acceptance tests for MDM integrations.
• Work with ETL, Replication and DBA teams to determine data transformations and document accordingly.
• Build and optimize data integration workflows connecting source systems to centralized MDM hub.

Conocimientos

Advanced SQL

Data analysis

MDM

Data quality

Herramientas

Oracle Exadata

SQL Server

Ab Initio

REST API

OLAP

Descripción del empleo

Amtex Enterprises Inc. in Dallas, TX is seeking an MDM Engineer/Analyst to own match, merge, and survivorship rules for transmission and distribution data.

You will support data governance, write mapping and acceptance tests, and collaborate with DBA, ETL developers, analysts, and data architects to drive complex data initiatives. The role requires 5+ years in data analysis with 2+ years in MDM or data quality, advanced SQL skills, and experience with Oracle Exadata and SQL Server.