Lead Data Architect / MDM Specialist

Role Summary:
The Lead Data Architect owns the design of the customer golden record and all matching, deduplication, and hierarchy logic for the project. As no MDM platform is in place, this role designs and builds the data quality architecture from scratch rather than configuring an existing tool. This is the most critical and least compressible role on the project and the primary owner of long-term data governance continuity.

Key Responsibilities:

• Map source schemas from legacy CRMs (3 confirmed, up to 6 total) to the target ERP Customer Master.
• Negotiate and document field-level survivorship matrices with business and financial stakeholders.
• Define the golden record model: attributes, hierarchies, and relationship types.
• Design the account hierarchy model to represent OEM, supplier, and dealer relationships, including variable ownership and multi-brand dealer structures.
• Design matching, deduplication, and survivorship rules (custom logic - fuzzy/phonetic matching, scoring, weighting) in the absence of a commercial MDM platform. Use of AI tools and Agents is strongly recommended.
• Incorporate data privacy, security, and compliance requirements (e.g., GDPR, CCPA) into the data model and architecture from the outset.
• Collaborate with business stakeholders to define data ownership, establish data governance workflows, and assist in designing the operating model for long-term MDM adoption.
• Define new rules and guidelines for Account and contracts in CRM systems (to ensure most clean data is ELT ready).
• Define the system-of-record matrix: which system (ERP or CRM) is authoritative for which field.
• Own data quality KPIs, define cutover/test-readiness criteria, and contribute to overall project performance metrics (e.g., data accuracy improvement, duplicate reduction).
• Lead the Phase 0 account hierarchy validation workshop using real ownership/brand edge cases from the business.
• Evaluate and document where AI-assisted matching may responsibly supplement rule-based logic.
• Produce and maintain full documentation of all rules and models to ensure continuity beyond this engagement.

Required Qualifications Experience:

• Experience Level: 12+ Years (Senior Contractor).
• Senior, hands-on data architecture/engineering background with proven MDM experience (e.g., SAP MDG, Informatica, Reltio).
• Define data lineage between different CRM systems and ETL process
• Proven experience building custom-engineered staging/cleansing databases (Postgres, Snowflake).
• Prior experience on CRM-to-ERP migration programs.
• Strong knowledge of Salesforce.
• Strong relational database modeling, SQL, and data pipeline tooling (such as dbt). Experience with ETL tool like Alteryx is a strong preference.
• Experience using AI/ML libraries (e.g., scikit-learn, TensorFlow) for data cleansing, or leveraging generative AI for semantic matching and documentation.
• Direct automotive or dealer-network industry experience is strongly preferred.
• Demonstrated experience designing matching/deduplication logic without a commercial MDM platform.
• Experience modeling complex, multi-dimensional account hierarchies with variable/partial ownership structures (automotive OEM/dealer/franchise, multi-tier distribution, or comparable domain complexity).
• Strong data governance background.
• Excellent communication skills and comfortable owning cross-functional decisions.
• Support the date lineage process for Migration Engineer

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.