MDM Analyst

Sun Gro Horticulture•Mississauga, ON

2d•CA$50,000 - CA$55,000•Onsite

About The Position

The Master Data Management (MDM) Analyst is responsible for maintaining the integrity, accuracy, completeness, and governance of vendor and customer master data within Microsoft Dynamics 365 Business Central. This role serves as a central point of coordination between Purchasing, Engineering, Plant Operations, Logistics, Sales, Customer Care, Human Resources, Finance, and external vendors to ensure timely and compliant onboarding, maintenance, and validation of master records. The MDM Analyst manages the end-to-end vendor and customer setup process, verifies regulatory and tax compliance requirements, maintains supporting documentation and contracts, monitors insurance certificates and other vendor qualifications, and ensures master data remains current and accurate. The role also supports select finance-related processes, including vendor banking setup and payment administration, while ensuring compliance with company policies and regulatory requirements. This position plays a critical role in supporting operational efficiency, risk mitigation, compliance, and data governance across the organization.

Requirements

College diploma or degree in Business, Accounting, Finance, Supply Chain, or a related field preferred.
3+ years of experience in Master Data Management, Procurement Administration, Vendor Management, Accounting or related roles.
Experience with Microsoft Dynamics 365 Business Central or similar ERP systems.
Strong experience managing vendor and customer master data.
Master Data Management (MDM)
Microsoft Dynamics 365 Business Central
Vendor and Customer Master Data Administration
Vendor Onboarding and Compliance Management
IRS TIN Verification and Tax Compliance
Document and Records Management
Contract and Insurance Certificate Administration
Data Governance and Data Quality Management
Banking Setup and Vendor Payment Administration
Microsoft Excel, Word, and Outlook
Strong attention to detail and organizational skills
Excellent communication and stakeholder management abilities
Ability to manage multiple priorities in a fast-paced environment
Strong problem-solving and analytical skills
High level of accuracy, confidentiality, and accountability

Responsibilities

Create and maintain vendor and customer records in Microsoft Dynamics 365 Business Central.
Process vendor setup requests received from Purchasing and customer setup requests from Sales and Customer Care.
Update vendor and customer information, including names, addresses, contact information, payment terms, websites, and banking details.
Review and maintain data accuracy, completeness, and consistency across all master records.
Identify and block inactive vendors and reactivate records as business needs require.
Coordinate new vendor onboarding by working with Purchasing, Engineering, Plants, Logistics, HR, and vendors to obtain required documentation.
Distribute, collect, review, and validate vendor forms based on vendor type and country requirements.
Perform IRS TIN/FID verification for U.S. vendors, carriers, and Canadian carriers delivering into the U.S. Ensure legal business names and tax information are properly verified and compliant.
Maintain vendor and customer documentation, contracts, tax forms, insurance certificates, and compliance records.
Monitor expiration dates for Certificates of Insurance (COI), Workers' Compensation certificates, and vendor contracts.
Coordinate with vendors, carriers, and purchasing teams to obtain updated documentation and ensure ongoing compliance.
Maintain organized electronic filing systems and document retention records.
Initiate vendor banking setup and banking information changes.
Complete vendor credit applications and coordinate submissions through Purchasing.
Support payment processing by managing vendor payment blocks and unblocks for wire transfer payments.
Conduct ongoing reviews of vendor and customer master records to ensure accuracy and completeness.
Maintain data standards and support internal controls, audit requirements, and compliance initiatives.
Act as the primary steward of vendor and customer master data across the organization.