MDM Data Engineer

Headquarters: Remote URL: http://soltech.net

Job Description Our client is seeking an experienced MDM Data Engineer to design, build, and maintain data integrations connecting enterprise source systems to the EnterWorks 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.Key ResponsibilitiesIntegration DevelopmentBuild source-to-stage integrations to extract customer data from multiple ERP systems (AS400, Sage variants, etc.), Salesforce CRM, and edge applicationsDevelop stage-to-hub data flows to load cleansed and matched customer records into EnterWorksBuild hub-to-ERP integrations enabling bidirectional synchronization of master customer data back to source systemsImplement data transformation and mapping rules based on logical party model specificationsDevelop error handling, retry logic, and exception management for all integrationsCreate data validation routines to ensure data quality throughout the pipelineTechnical ImplementationConfigure and implement data quality rules in EnterWorks, including completeness, consistency, and accuracy checksImplement match/merge algorithms and survivorship rules to support golden record creationDevelop and execute data migration scripts for initial customer data loadsBuild and maintain automated testing frameworks for integration validationSupport iterative development through pilot and testing phases, progressing toward CI/CD practicesOptimize integration performance, reliability, and scalabilityTechnical Assessment & DocumentationConduct technical assessments of source system data structures, APIs, and connectivity optionsProfile source data to validate discovery findings and inform data quality rule developmentDocument technical specifications, including data mappings, transformation logic, and performance requirementsTroubleshoot and resolve integration and data flow issuesSupport data governance teams with monitoring dashboards and technical reportingCollaboration & CommunicationPartner with the Senior MDM Lead to translate business requirements into technical solutionsCoordinate with the MDM Hub Developer on EnterWorks configuration and data flow designParticipate in technical discussions with client SMEs on source system access and integration approachesProvide technical input for project planning, estimation, and delivery timelinesPhase Alignment Phase 1: MDM Initiation & Solution Selection Standardize, GovernConduct technical assessments of source systemsValidate integration approaches and document technical specificationsSet up development environmentsBegin source-to-stage integration developmentPhase 2: MDM Design, Build & Delivery AchieveComplete all integrations (source-to-stage, stage-to-hub, hub-to-ERP)Implement data quality and match/merge logicExecute data migration and support testing and UATOptimize performance and support rollout and hyper-careTechnical EnvironmentMDM Platform: EnterWorksSource Systems: AS400 (PRMS), A+, Sage variants, Salesforce CRM, and various edge applicationsIntegration: SQL and stored procedures, ETL/ELT tools (Informatica IDMC, Fivetran), REST/SOAP APIs, batch processingData Quality: Profiling tools, DQ rule configuration, monitoring dashboardsRequired Qualifications5+ years of experience in data engineering or data integration rolesStrong proficiency with ETL/ELT tools (Informatica and Fivetran preferred; Talend, SSIS, or similar acceptable)Experience with MDM platforms, preferably EnterWorks or comparable enterprise solutionsAdvanced SQL skills and experience with relational databasesHands-on experience integrating ERP systems (SAP, Oracle, AS400, Sage, or similar)Understanding of REST and SOAP API integrationsExperience implementing data quality frameworks and rulesStrong analytical, troubleshooting, and problem-solving skillsProven ability to collaborate with both technical and business stakeholdersPreferred QualificationsExperience integrating Salesforce and working with Salesforce APIsBackground in manufacturing or distribution environmentsFamiliarity with AS400/IBM data extraction techniquesExperience with Python or other scripting languages for data processingKnowledge of data governance and stewardship practicesExperience with cloud data platforms (Azure, AWS, GCP)CI/CD experience for deploying and managing data pipelinesAbout SOLTECHSOLTECH is a leading national technology company based in Atlanta, driven by a steadfast commitment to integrity, strong company values, and customer centricity. For nearly 30 years, we ve been part of the thriving technology community and have earned honors such as The Atlanta Journal-Constitution s Top Workplace and the Best & Brightest Companies To Work For In The Nation.Our exceptional team of engineers, designers, and strategists delivers custom software applications, technology consulting, AI and data engineering solutions, and IT staffing services that help organizations solve complex challenges nationwide.Join us on our quest to make the world a better place by bringing to life innovative software solutions that make our lives easier, safer, healthier, and more productive.If you re an IT professional seeking your next career opportunity, we d love to match your expertise with a role where you can thrive. Learn more at https://soltech.net/working-for-soltech/.SOLTECH believes in the dignity of every individual and practices equal employment opportunity as a core principle. We consider all applicants without regard to race, color, age, sex, sexual orientation, gender identity, religion, marital status, national origin, disability, or veteran status.

To apply: https://weworkremotely.com/remote-jobs/soltech-mdm-data-engineer