Information Technology Jobs in Lakeville, MN

Job Title: MDM Architect

Client: Fortune 500 Consumer Products Company

Duration: 6 Months (possible extension or conversion)

Location: Lakeville, MN (Onsite Tuesday–Thursday)

Employment: W2 Only (No C2C / No Sponsorship)

Reporting To: Associate Director of Data Strategy and Integration

Role Overview

The client is currently in the middle of a large M&A integration, bringing together data from 8th Avenue and existing PCB systems across multiple ERPs. The data environment is still early in maturity, and the focus is on standing up a practical MDM foundation using Stibo STEP rather than a full enterprise rollout. This role will lead the design and implementation of master data consolidation across Customer and Finished Goods domains, working closely with Data Quality, Governance, and Data Engineering teams. The position is a mix of architecture and hands-on configuration, focused on building scalable, reusable MDM processes and establishing core governance and data integrity standards.

Key Responsibilities

• Lead design and implementation of master data consolidation for 8th Ave to PCB integration
• Develop conceptual and logical data models for Customer and Item domains
• Design and implement match/merge and survivorship rules, including search-before-create logic
• Build and manage cross-reference mappings between legacy and target systems
• Define MDM architecture, including data flows, integration patterns, and system interactions
• Establish governance framework including CRUD ownership, data stewardship, and integrity controls
• Align closely with Data Quality Technical Lead on data quality rules and processes
• Assess and harmonize Customer and Product hierarchies across systems
• Integrate MDM with enterprise data catalog (metadata, lineage, business glossary)
• Identify gaps in current MDM setup and contribute to future roadmap
• Collaborate with business, ERP, and data teams to gather and refine requirements
• Support UAT, deployment, and post-production issue resolution
• Provide documentation, knowledge transfer, and mentoring to internal teams

Required Skills and Experience

• Strong experience in end-to-end MDM implementations, preferably using Stibo STEP
• Hands-on experience with data modeling, match/merge, survivorship rules, and hierarchies
• Experience working as both architect and hands-on configurator (design + build)
• Strong understanding of data integrity, cross-referencing, and multi-system data consistency
• Experience defining and implementing MDM governance (CRUD ownership, stewardship workflows)
• Ability to work in low data maturity environments and drive structure
• Experience leading cross-functional design discussions with business and ERP teams
• Strong understanding of data governance frameworks and data management practices
• Hands-on experience with JavaScript and REST APIs
• Experience working with search technologies (Elastic Search or similar)
• Strong communication and stakeholder management skills

Nice to Have

• Experience with Stibo STEP SaaS implementations in Customer or Product domains
• Experience in M&A data integration or system consolidation
• Exposure to Oracle JDE environment
• Experience with Snowflake or cloud data platforms
• Experience with Boomi MDH or other integration tools
• Familiarity with data enrichment services (Dun & Bradstreet, Loqate)
• Understanding of data cataloging concepts

Success Criteria

• Master data successfully consolidated across systems with accurate cross-references
• Match/merge and survivorship rules functioning effectively with minimal duplicates
• Post-go-live master data issues remain below 1%
• MDM governance processes established and adopted
• Integration and data flows are stable and scalable