Data & Systems Administrator

CMP Group; Delta; Hybrid; CAD 75,000 - 90,000; Full time

Benefits offered by this job

Extended benefits

Hybrid work model

Performance & training programs

Annual events

Job summary

CMP Group in Delta, BC seeks a Data & Systems Administrator to gather, maintain, and analyze product and customer data, including pricing. You’ll support Sales, Customer Service, and Marketing by ensuring data is accurate, standardized, and readily available for reporting and decision-making.

You will manage pricing and product data across PIMCore, ERP (Infor Visual), and Zoho CRM, drive data quality improvements, and support system enhancements and cross-functional projects in a hybrid work

Qualifications

• Minimum of 2 years in data administration.
• 2+ years data governance experience.
• 2+ years pricing and product data experience.
• 2+ years data analysis, reporting, and process improvement.
• 2+ years systems/project support, training, and documentation.
• 2+ years SQL experience querying relational databases.
• Experience with ERP/CRM systems including Infor Visual, PIMCore, Zoho CRM is an asset.
• Advanced MS Excel skills including Power Query, lookups, and pivot tables.

Responsibilities

• Maintains data standards and governance across the organization.
• Manages product, customer, pricing, and sales data in PIMCore, Visual, and Zoho CRM.
• Ensures data accuracy, completeness, and adherence to business rules.
• Monitors data quality across key data elements and resolves issues.
• Develops automated data processes and reports to support decision-making.
• Collaborates with Sales, Marketing, Finance on pricing discrepancies.
• Supports system enhancements, testing, and user training.

Skills

Data governance

Pricing data mgmt

Data analysis

SQL queries

ERP systems

CRM systems

Excel/Power Query

Data quality

Education

Post-secondary education in Business/IT/Data Analytics

Tools

Infor Visual

PIMCore

Zoho CRM

Excel

Power Query

SQL

Job description

CMP is a global manufacturing company with 6 manufacturing and distribution facilities throughout Canada, the United States, Italy, Australia, and China. CMP supplies the recreational and commercial marine industries with a broad range of products for various industry segments, including anchoring & ground tackle, corrosion, dock & boat accessories, and steering & controls. CMP manufactures and distributes products under the brands, Martyr, Rocna, Vulcan, Titan, Panther, Dock Edge, Octopus, Intellisteer, Sanitation Equipment and, Trollmaster.

We are seeking a Data & Systems Administrator to join the team in our Delta, BC location.

PURPOSE OF THE JOB:

The Data & Systems Administrator is responsible for gathering, developing, entering, maintaining and analyzing product and customer data, including product attributes, customer information and pricing. This role supports the Sales, Customer Service and Marketing departments by ensuring data is accurate, complete, standardized, and readily available for reporting and decision-making. The Data & Systems Administrator will analyze customer sales and pricing data to identify trends, opportunities, and data quality issues that support business strategy and the development of customized strategies for current and prospective customers. This role requires strong knowledge of data management, business processes, sales and marketing workflows, data analysis, and business systems. The Data & Systems Administrator will also contribute to process improvement, automation, system optimization, and cross-functional projects designed to improve the quality, efficiency, and accessibility of company data.

BENEFITS:

• Salary - $75,000 to $90,000 per year based on experience
• Extended Benefits Plan (Vision/Dental/Prescription/etc.) as of your first day
• Performance, Education & Referral Programs
• Quarterly town halls and summer BBQ’s
• Annual Golf Tournament and Winter Holiday Party
• And much more!

RESPONSIBILITIES:

Data Management & Governance

• Maintains standards for how data elements are defined, structured, utilized and shared throughout the organization, including related SOPs.
• Manages product, customer, pricing, and sales data within the Product Information Management (PIMCore), Enterprise Resource Planning (Visual), and Customer Relationship Management (Zoho) systems.
• Ensures data is accurate, complete, consistent, standardized, and maintained according to established business rules.
• Monitors data quality across Accounts, Contacts, Opportunities, products, pricing, and other key data elements.
• Identifies and communicates data errors or inconsistencies to appropriate users and departments and supports timely resolution.
• Utilizes internal tools and third-party services to maintain the integrity, usability, and availability of product, customer, and sales data.
• Ensures data management practices comply with established company policies, procedures, and standards.
• Ensures customer pricing information and contracts are accurate, complete, and implemented on time across all applicable systems.
• Prepares, compiles, and organizes documentation and information required for customer price sheets.
• Enters and maintains pricing information accurately within applicable databases and systems while adhering to formatting and standardization requirements.
• Obtains and validates missing or incomplete information required to establish customer pricing.
• Reviews and scrubs pricing data for errors in formatting, spelling, calculations, and standardization.
• Prepares price books in Excel and uploads pricing information into the ERP system.
• Works with Sales, Customer Service, Finance, and other departments to investigate and resolve pricing discrepancies and database issues.

Data Analysis, Reporting & Process Improvement

• Uses Excel, Power Query, SQL, and other analytical tools to extract, transform, validate, and analyze business data.
• Develops and maintains reports, datasets, and analytical tools to support Sales, Customer Service, Marketing, and management decision-making.
• Analyzes customer, product, sales, and pricing trends and identifies opportunities, anomalies, and data quality issues.
• Continually identifies opportunities to improve processes, eliminate inefficiencies, reduce manual work, and automate recurring tasks.
• Develops and maintains automated data processes and workflows where appropriate.
• Recommends improvements to data structures, processes, systems, and reporting based on identified business needs.

Systems & Project Support

• Supports system enhancements, testing, implementations, upgrades, and data-related projects.
• Provides training, documentation, and ongoing support to users as required.
• Supports and/or coordinates strategic projects designed to improve business performance, data quality, operational efficiency, and system capabilities.
• Works collaboratively with internal stakeholders and system vendors to resolve issues and improve system functionality

Safety:

• Promotes safe work practices as outlined in the Worksafe B.C. regulations.

Quality:

• Ensures the Company’s quality policies and procedures are followed.

Team building:

• Participates in 1X1 meetings with the Controller, Financial Systems and Cost Accounting

REQUIREMENTS:

• Minimum of 2 years of experience in data administration
• 2 + years of experience in data management & governance
• 2 + years of experience in pricing & product data
• 2 + years of experience in data analysis, reporting & process improvement
• 2 + years of experience in systems & project support/ coordination, training, documentation & user-support skills
• 2 + years of experience in SQL, including the ability to query, filter, join, and analyze data from relational databases
• 2 + years of experience in ERP and CRM software; Infor Visual (ERP), PIMCore and/or Zoho CRM is an asset
• Advanced Microsoft Excel skills, including experience with Power Query, lookups, formulas, pivot tables, and data validation and strong computer skills, especially Microsoft Office (Word, Excel, PowerPoint)
• Post-secondary education in Business, Information Technology, Data Analytics, or a related field
• Experience establishing data standards, definitions, validation rules, documentation, and data governance practices is an asset
• Strong understanding of sales, customer service, and marketing processes and workflows
• Comfortable in developing strong relationships and working with senior level executives

HOURS:

• Monday to Friday, 8:00am - 4:30pm
• Hybrid (3 days in the office and 2 days of working from home) – there will be a training period of 6 months in the office before transitioning to hybrid

Please note: All job postings at CMP are aimed at filling existing vacancies within our organization. CMP may utilize artificial intelligence (AI) tools as part of the applicant screening process. However, our Talent Acquisition Specialist will also review applications to ensure a fair and comprehensive assessment.

This posting and any related applicant information will be retained for three years in accordance with provincial or state regulations. CMP values diversity and encourages applications from all qualified individuals who are legally entitled to work. We welcome applications from candidates with disabilities and provide accommodations upon request for those participating in all aspects of the selection process. To request accommodations, please contact our Human Resources Department.

We thank all applicants for their interest and advise that only those selected for an interview will be contacted.