Soltech: MDM Data Engineer

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 Responsibilities

Integration Development

• 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 EnterWorks

• 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

Technical Implementation

• Configure and implement data quality rules in EnterWorks, 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

Technical Assessment & Documentation

• 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

Collaboration & Communication

• Partner with the Senior MDM Lead to translate business requirements into technical solutions

• Coordinate with the MDM Hub Developer on EnterWorks 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

Phase Alignment 

Phase 1: MDM Initiation & Solution Selection – Standardize, Govern

• Conduct technical assessments of source systems

• Validate integration approaches and document technical specifications

• Set up development environments

• Begin source-to-stage integration development

Phase 2: MDM Design, Build & Delivery – Achieve

• 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

Technical Environment

• MDM Platform: EnterWorks

• 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

Required Qualifications

• 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 EnterWorks 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 quality frameworks and rules

• Strong analytical, troubleshooting, and problem-solving skills

• Proven ability to collaborate with both technical and business stakeholders

Preferred Qualifications

• Experience integrating Salesforce and working with Salesforce APIs

• Background in manufacturing or distribution environments

• Familiarity with AS400/IBM data extraction techniques

• Experience with Python or other scripting languages for data processing

• Knowledge of data governance and stewardship practices

• Experience with cloud data platforms (Azure, AWS, GCP)

• CI/CD experience for deploying and managing data pipelines

About SOLTECH
SOLTECH 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.