Why this role stands out
Elevate your career as an MDM Analyst at CTC USA, LLC, where you will drive impactful data quality initiatives and master sophisticated tools like Ab Initio in a collaborative, high-growth environment. This hybrid role is perfect for a detail-oriented professional who thrives on solving complex data challenges and wants to contribute to a forward-thinking team. Apply today to secure your place in this dynamic organization and take the next step in your professional journey.
Quick overview
Job description
Responsibilities
§ 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 in collaboration with data stewards
§ Investigate data anomalies/issues reported by Business and Root-cause duplicates and false merges. Provide recommendations for mitigation and drive fixes upstream
§ 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 in data set.
§ 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
§ Work with Data Stewards on review queues; define unmerge and remediation processes
- Build and optimize data integration workflows connecting source systems to centralized MDM hub
- Partner with analysts, data governance teams, and business stakeholders to implement master data management at Oncor.
§ Support Data Governance functions such as definitions, ownership, documenting lineage, data standardization, and dictionary.
§ Work with support teams to ensure consistent and pro-active support methodologies are adhered to for all aspects of data movements and data transformations
§ Assist in break fix and production validation as it relates to data derivations, replication and structures
- Ability to explain data problems to non-technical stakeholders
Qualifications:
- 5+ years in data analysis with 2 or more years in MDM or data quality
- Advanced SQL; hands-on data profiling and reconciliation is essential
- Previous experience working 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 managing multiple priorities
- Ability to explain data problems to non-technical stakeholders
- Strong attention to Detail
- Ability to collaborate effectively and work as part of a team
- Denodo Experience a plus
- Big Data Experience a plus (Hadoop, MongoDB)
- Postgres and Cloud Experience is a plus
- Regulated Industry experience is a plus
Similar jobs
- UO

PEER RECOVERY SPECIALIST CERTIFIED
University of New Mexico - Hospitals · Edgewood, NM · Hybrid · Posted 9 Nov 2026 🇺🇸
BLSMental HealthPatient CareSalary not listed - UO

COUNSELOR SOCIAL WKR CLIN
University of New Mexico - Hospitals · Peralta, NM · Hybrid · Posted 26 Oct 2026 🇺🇸
Case ManagementMental HealthOutreach+1Salary not listed - RA
Dietary AideRecently posted
Regency at Shelby Township · Utica, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Nursing$16 - $17/hr - RA
Laundry AideRecently posted
Regency at Bluffs Park · Ann Arbor, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
NursingSalary not listed - EM

Admissions CoordinatorRecently posted
Ely Manor · Allegan, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
CRMMedical TerminologyNursingSalary not listed - TL
Dietary AideRecently posted
The Laurels of Sandy Creek · Wayland, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Nursing$16 - $17/hr - CH

Float Business Office CoordinatorRecently posted
Ciena Healthcare · Grand Rapids, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Accounts ReceivableNursingPatient Care+1Salary not listed - RA
Business Office Coordinator (BOC)Recently posted
Regency at Whitmore Lake · Whitmore Lake, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Nursing$10k/mo - RA
Activity AideRecently posted
Regency at Whitmore Lake · Whitmore Lake, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Nursing$16 - $17/hr - RA
Dietary AideRecently posted
Regency at Whitmore Lake · Whitmore Lake, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Nursing$18/hr - CH

Float Business Office CoordinatorRecently posted
Ciena Healthcare · Detroit, MI · Hybrid · Posted 16 Nov 2026 🇺🇸
Accounts ReceivableNursingPatient Care+1Salary not listed - HR
Certified Dietary Manager (CDM)Recently posted
Hickory Ridge of Temperance · Temperance, MI · On-site · Posted 16 Nov 2026 🇺🇸
ComplianceFood SafetyNursing+1Salary not listed