MDM Data Engineer

Headquarters: Remote

URL:

Our client is seeking an experienced MDM Data Engineer to design, build, and maintain data integrations connecting enterprise source systems to the Enter Works MDM hub. This role focuses on developing robust ETL/ELT pipelines, implementing data transformation logic, configuring data quality rules, and ensuring reliable data synchronization across the organization.

Two MDM Data Engineers will work collaboratively under the guidance of the Senior MDM Lead to deliver the technical integration components of a Customer MDM solution. The position blends hands‑on integration development with technical assessment and optimization to ensure solution quality, scalability, and performance.

• Build source-to-stage integrations to extract customer data from multiple ERP systems (AS400, Sage variants, etc.), Salesforce CRM, and edge applications
• Develop stage-to-hub data flows to load cleansed and matched customer records into Enter Works
• Build hub-to-ERP integrations enabling bidirectional synchronization of master customer data back to source systems
• Implement data transformation and mapping rules based on logical party model specifications
• Develop error handling, retry logic, and exception management for all integrations
• Create data validation routines to ensure data quality throughout the pipeline

• Configure and implement data quality rules in Enter Works, including completeness, consistency, and accuracy checks
• Implement match/merge algorithms and survivorship rules to support golden record creation
• Develop and execute data migration scripts for initial customer data loads
• Build and maintain automated testing frameworks for integration validation
• Support iterative development through pilot and testing phases, progressing toward CI/CD practices
• Optimize integration performance, reliability, and scalability

• Conduct technical assessments of source system data structures, APIs, and connectivity options
• Profile source data to validate discovery findings and inform data quality rule development
• Document technical specifications, including data mappings, transformation logic, and performance requirements
• Troubleshoot and resolve integration and data flow issues
• Support data governance teams with monitoring dashboards and technical reporting

• Partner with the Senior MDM Lead to translate business requirements into technical solutions
• Coordinate with the MDM Hub Developer on Enter Works configuration and data flow design
• Participate in technical discussions with client SMEs on source system access and integration approaches
• Provide technical input for project planning, estimation, and delivery timelines

• Conduct technical assessments of source systems
• Validate integration approaches and document technical specifications
• Set up development environments
• Begin source-to-stage integration development

• Complete all integrations (source-to-stage, stage-to-hub, hub-to-ERP)
• Implement data quality and match/merge logic
• Execute data migration and support testing and UAT
• Optimize performance and support rollout and hyper‑care

• MDM Platform: Enter Works
• Source Systems: AS400 (PRMS), A+, Sage variants, Salesforce CRM, and various edge applications
• Integration: SQL and stored procedures, ETL/ELT tools (Informatica IDMC, Fivetran), REST/SOAP APIs, batch processing
• Data Quality: Profiling tools, DQ rule configuration, monitoring dashboards

• 5+ years of experience in data engineering or data integration roles
• Strong proficiency with ETL/ELT tools (Informatica and Fivetran preferred; Talend, SSIS, or similar acceptable)
• Experience with MDM platforms, preferably Enter Works or comparable enterprise solutions
• Advanced SQL skills and experience with relational databases
• Hands‑on experience integrating ERP systems (SAP, Oracle, AS400, Sage, or similar)
• Understanding of REST and SOAP API integrations
• Experience implementing data…