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.