ERP Technician - ERP Development & Configuration Specialist

Decor Cabinets Ltd; Morden; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company in the cabinetry industry is seeking an ERP Technician to oversee its ERP systems, focusing on technical development, integration, and data management. The ideal candidate will have strong SQL skills and experience in ERP configuration, particularly within manufacturing settings. This role offers an opportunity to significantly enhance business efficiency through tailored ERP solutions and collaboration across various departments.

Qualifications

• Minimum 3 years ERP experience (Insight, Microsoft Dynamics, Epicor, or SAP).
• Strong SQL programming background.
• Experience in manufacturing environments is an asset.

Responsibilities

• Technical development and support for ERP systems.
• Architect and configure ERP environments.
• Develop and maintain SQL queries, stored procedures, and data workflows.

Skills

SQL

Problem-solving

Analytical skills

Data integration

Communication

Education

Bachelor’s degree in Computer Science or related field

Tools

Power BI

SSRS

Crystal Reports

Job description

Job Details

Description

Position Overview:

We are seeking a technically skilled, adaptable, and team-oriented ERP Technician with deep expertise in SQL development and a proven ability to quickly master and configure ERP platforms, particularly in manufacturing environments. Experience with Insight ERP (by Cyncly), Microsoft Dynamics, or similar systems is highly preferred.

This role will be responsible for technical development and support across our ERP landscape, with a focus on system architecture, configuration, integration, troubleshooting, and continuous improvement. The ideal candidate is collaborative, self-driven, and passionate about delivering secure, maintainable, and scalable ERP solutions that drive business efficiency.

Key Responsibilities

• ERP Technical Development & Support
• Participate in technical development efforts for ERP solutions including system configuration, SQL scripting, report/label changes, and data workflows.
• Architect scalable and maintainable ERP environments, prioritizing performance, security, and user experience.
• Manage system validation, QA testing, documentation, and troubleshooting of ERP-related issues.
• Ensure ERP development projects meet strategic goals and are completed on time.
• Stakeholder Collaboration & Communication
• Liaise with business stakeholders (e.g., Production, Sales, Engineering, Finance) to gather requirements and develop tailored ERP solutions.
• Participate as a technical point of contact for ERP-related inquiries, integrations, and enhancements.
• Work collaboratively with internal teams and third-party vendors to align technology with business needs.
• Data Management & Reporting
• Develop and maintain SQL queries, stored procedures, triggers, and views for reporting and automation.
• Ensure data accuracy and integrity across all ERP modules through structured audits and validation rules.
• Participate in creating reports and dashboards using tools such as Power BI, SSRS, or Crystal Reports to support business decisions.
• System Integration & Automation
• Integrate ERP with external applications (e.g., CRM, HRIS, inventory systems) using APIs, middleware, or custom scripts.
• Identify and automate routine tasks and manual processes to improve system efficiency and user productivity.
• Monitor integration performance and resolve any data synchronization issues.
• Security & Compliance
• Configure and manage user access through role-based permissions and security best practices.
• Perform regular system audits and collaborate with IT Security on compliance with internal and external standards.
• Stay current with security trends and ensure ERP systems are aligned with industry regulations.
• Continuous Learning & Team Enablement
• Keep up with ERP trends, development languages, and system capabilities, especially within Insight ERP.
• Contribute to internal documentation, team knowledge sharing, and training of new ERP team members.
• Support skill development within the ERP team in partnership with the ERP Manager.
  
  

Required Skills & Competencies

• Strong proficiency in SQL (queries, views, stored procedures, performance tuning).
• Hands-on experience configuring ERP systems in a manufacturing context (Insight preferred).
• Strong understanding of ERP data structures, business logic, and integration design.
• Effective problem-solving, analytical, and systems thinking skills.
• Experience with integration methods such as APIs, data import/export, middleware.
• Familiarity with reporting tools like Power BI, SSRS, or Crystal Reports.
• Excellent interpersonal and communication skills across technical and non-technical stakeholders.
• Self-starter with the ability to work independently and as part of a team.
  
  

Education & Experience

• Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent professional experience.
• Minimum 3 years of experience with ERP systems such as Insight, Microsoft Dynamics, Epicor, or SAP.
• Strong background in SQL programming and ERP configuration.
• Experience in manufacturing or production environments considered a strong asset.
  
  

Disability accommodations available upon request.