MDM Analyst

Sun Gro Horticulture is one of the most prominent North American horticultural companies, employing over 800 staff and serving customers worldwide. Since its humble beginnings in 1929, it has become the leading supplier of soilless growing mixes to North America’s top 100 greenhouse and nursery growers, shipping over 70,000 truckloads of product annually. Sun Gro products are made to exacting standards and conform to high product quality and performance criteria.

Sun Gro Horticulture recognizes that its success is due to the strength of its employees. The primary goal of Sun Gro® is to promote individual employees’ sense of accomplishment and contribution so that employees enjoy their association with Sun Gro Horticulture. The Company invests in its employees so that they are the most knowledgeable in the industry, and undertakes great efforts to nurture loyalty to, and teamwork at, Sun Gro.

GENERAL SUMMARY: 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.

This role is fully onsite 5 days a week Compensation Range - $50,000-55,000

ESSENTIAL POSITION FUNCTIONS: Vendor & Customer Master Data Management

• 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. Vendor Onboarding & Compliance
• 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.

Document & Contract Management

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

Finance Support

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

Data Quality & Governance

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

Qualifications

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

KNOWLEDGE, SKILLS AND ABILITIES

• 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