Master Data Management Architect

The Master Data Management (MDM) Architect is responsible for designing, implementing, and managing MDM solutions to ensure data accuracy, consistency, and reliability across the organization. This role collaborates with cross-functional teams, including IT, business stakeholders, data stewards and supply chain teams, to align MDM initiatives with organizational goals. The MDM Architect will define data governance policies, develop technical architectures, optimize integration processes, and support business decision-making through data analysis and insights. This position plays a critical role in improving data quality, driving operational efficiency, and ensuring compliance with data privacy and security regulations.   DUTIES AND RESPONSIBILITIES:    Essential Functions:   Collaborate with cross-functional teams, including IT, business stakeholders, business analysts, and data stewards, to understand master data requirements and provide effective MDM solutions. Define and design the overall MDM architecture, ensuring alignment with business objectives, scalability, and compatibility with multiple domains. Develop the master data management strategy, aligning MDM initiatives with the program objectives and long-term goals. Communicate effectively via correspondences, presentations, and meeting with business and technical stakeholders. Develop, implement, and enforce master data governance policies, standards, and procedures to ensure data quality, accuracy, compliance, consistency, and reliability of master data. Provide standards, guidelines, processes, and expertise to address master data issues such as convergence, standards, and synchronization. Develop and maintain technical architectures and data models for MDM solutions. Implement data integration processes, ensuring the seamless flow of data between different systems and applications. Collaborate with System Administrators to optimize the performance and scalability of MDM solutions and operations. Document and incorporate MDM best practices and processes. Collaborate with other teams to ensure compliance with data privacy and security regulations. Work closely with all levels of the organization including presenting to educate the business on master data issues and best practices. Identify and leverage opportunities to continually improve the data quality, processes, and standards for master data domains. Provide training and create documentation for end-users and data stewards on MDM best practices and usage. Analyze supply chain data to identify opportunities to improve processes, reduce costs, and optimize inventory levels. Create and maintain dashboards and reports that provide visibility into supply chain KPIs and trends. Partner with supply chain teams to interpret data insights and support decision-making processes. Perform ad hoc analyses to address supply chain challenges and drive actionable recommendations. Other duties as assigned.     MINIMUM QUALIFICATIONS:   5 years of hands-on professional experience as an Architect in multiple Master Data Management (MDM) projects architecting, planning, designing, developing, implementing, testing, and integrating successful MDM solutions including data cleansing, data ingestion pipelines, matching, merging, deduplication, hierarchy management, standardization, automation, and orchestration of enterprise Master and Reference data such as Clients and Providers data to create the single version of the truth (e.g., golden record). Experience with SAP Business One ideally with Boyum/BEAS experience. Experience with designing, developing, and implementing entity relational diagrams, conceptual, logical, and physical relational data models. 5 years of hands-on professional experience creating data profiling rules, data cleansing rules, data match rules (exact match, fuzzy match), merge options, auto-merge rules, manual merge rules, un-merge rules, validation rules, and trust rules. 5 years of hands-on professional experience in designing, developing, and maintaining integrations between MDM solutions and other systems using APIs, web services, etc. Experience using data modeling and developing complex SQL queries, stored procedures, functions, views, complex joins, indexes, triggers, external tables, roles, grants, permissions, DDL, and DML. 5 more years of hands-on professional experience in data analysis, metadata cataloging, creating, and maintaining documentation including technical specifications, data mappings, data dictionary, data lineage, data flow diagrams, and high-level and low-level design. Domain knowledge and experience in manufacturing businesses. Knowledge and experience in applying data management concepts such as data architecture, data quality, metadata management, Data Warehousing and Business Intelligence, data integrity, data integration and interoperability, data governance, data security, data storage and operations.         EDUCATION, SKILLS AND EXPERIENCE:    Education: Bachelor’s degree preferred, but not required.   Skills Excellent people skills with the ability to collaborate effectively in a team environment     Experience 5 years of hands-on professional experience as an Architect in multiple Master Data Management (MDM) projects architecting, planning, designing, developing, implementing, testing, and integrating successful MDM solutions including data cleansing, data ingestion pipelines, matching, merging, deduplication, hierarchy management, standardization, automation, and orchestration of enterprise Master and Reference data such as Clients and Providers data to create the single version of the truth (e.g., golden record). Experience with SAP Business One ideally with Boyum/BEAS experience.Experience with designing, developing, and implementing entity relational diagrams, conceptual, logical, and physical relational data models.5 years of hands-on professional experience creating data profiling rules, data cleansing rules, data match rules (exact match, fuzzy match), merge options, auto-merge rules, manual merge rules, un-merge rules, validation rules, and trust rules.5 years of hands-on professional experience in designing, developing, and maintaining integrations between MDM solutions and other systems using APIs, web services, etc.Experience using data modeling and developing complex SQL queries, stored procedures, functions, views, complex joins, indexes, triggers, external tables, roles, grants, permissions, DDL, and DML.5 more years of hands-on professional experience in data analysis, metadata cataloging, creating, and maintaining documentation including technical specifications, data mappings, data dictionary, data lineage, data flow diagrams, and high-level and low-level design.Domain knowledge and experience in manufacturing businesses.Knowledge and experience in applying data management concepts such as data architecture, data quality, metadata management, Data Warehousing and Business Intelligence, data integrity, data integration and interoperability, data governance, data security, data storage and operations.Experience with developing dashboards, KPIs, and reporting tools to monitor supply chain performance and communicate insights to stakeholders.Knowledge of general supply chain processes, including demand planning, inventory management, and procurement.   .  COMPUTER SKILLS: Proficient with Microsoft Power BI and related tools. Strong proficiency with Excel (advanced functions such as pivot tables, macros, and VLOOKUP), Power Query, and other data analysis tools.