Data Management Specialist

Blue Lemon Industries Limited; Markham; On-site; CAD 55,000 - 69,000; Full time

Job summary

Blue Lemon Industries Limited in Markham, ON is seeking a Data Management Specialist (Logistics & Inventory Systems) to design robust database models and manage inventory data across multiple GTA warehouses.

You will configure IT infrastructure, test DBMS for data synchronization between online channels and warehouse systems, and document SQL queries and data flows for performance improvements.

Qualifications

• Education: College/CEGEP.
• Experience: 1 year to less than 2 years.
• Technical asset skills include SQL, data warehousing, and server management.

Responsibilities

• Design, develop, and implement strategic database models to track inventory assets across multiple GTA locations.
• Configure and deploy IT network infrastructure to ensure internal apps access inventory databases.
• Test data models and DBMS to ensure data synchronization between online channels and warehousing systems.
• Document data reporting needs, SQL queries, data flow, and performance results for optimization.

Skills

Shell script

Data Warehouse

Servers

File management

Database software

SQL

Education

College/CEGEP

Tools

Database software

SQL

Job description

Volunteer Experience · Work Experience · Work & Career

You must sign in to apply for this position.

Job Title: Data Management Specialist (Logistics & Inventory Systems)
Employer: Blue Lemon Industries Limited
Location: 500 Esna Park Drive,Unit 1-4, Markham, ON L3R 1H5
Salary: 45.00 hourly / 35 hours per week
Terms of employment: Permanent employment, full time
Starts: as soon as possible
Vacancies: 1 vacancy

Job Requirements:

Education: College/CEGEP
Experience: 1 year to less than 2 years
Technical Asset Skills: Shell script, Data Warehouse, Servers, File management software, Database software, SQL
Personal suitability: accurate, client focus, organized, team player, adaptability, accountability, quick learner

• Design, develop, and implement strategic database models and blueprints to securely track luxury kitchen and bath inventory assets across multiple GTA locations.


• Configure, deploy, and set up the underlying IT network infrastructure and server environments to allow internal software applications to reliably access inventory databases.


• Test physical data models and database management systems (DBMS) to ensure seamless, bug-free data synchronization between online sales channels and warehouse fulfillment systems.


• Document ongoing data reporting needs, raw SQL queries, data flow logic, performance results, and technical recommendations for systems optimization.


• Enact rigorous database security measures and firewall permissions to ensure unauthorized users cannot access transactional data, customer information, or vendor accounts.


• Develop, execute, and monitor formal policies and procedures for network access controls, user tracking, and automated secure database backup and disaster recovery.


• Operate database management systems to query, clean, and analyze high-volume product SKU datasets, sales histories, and logistical tracking metrics.


• Liaise directly with showroom consultants, shipping clerks, and management staff to evaluate internal data requirements, coordinate data availability, and clean up localized user entry errors.


• Develop, maintain, and audit comprehensive document inventories and digital records tracking real-time stock levels across all active warehouses.


• Requisition manufacturing materials, retail showroom supplies, and inbound luxury kitchen/bath stock based on algorithmic system thresholds.


• Oversee the structural analysis of shipping, receiving, and storage data to prepare high-level logistics and warehouse utilization performance reports for executive review.


• Plan, track, and manage specific operational budgets relating to freight distribution, multi-location logistics, and warehouse material handling costs.

Job Title: Data Management Specialist (Logistics & Inventory Systems)
Employer: Blue Lemon Industries Limited
Location: 500 Esna Park Drive,Unit 1-4, Markham, ON L3R 1H5
Salary: 45.00 hourly / 35 hours per week
Terms of employment: Permanent employment, full time
Starts: as soon as possible
Vacancies: 1 vacancy

Job Requirements:

Education: College/CEGEP
Experience: 1 year to less than 2 years
Technical Asset Skills: Shell script, Data Warehouse, Servers, File management software, Database software, SQL
Personal suitability: accurate, client focus, organized, team player, adaptability, accountability, quick learner

• Design, develop, and implement strategic database models and blueprints to securely track luxury kitchen and bath inventory assets across multiple GTA locations.


• Configure, deploy, and set up the underlying IT network infrastructure and server environments to allow internal software applications to reliably access inventory databases.


• Test physical data models and database management systems (DBMS) to ensure seamless, bug-free data synchronization between online sales channels and warehouse fulfillment systems.


• Document ongoing data reporting needs, raw SQL queries, data flow logic, performance results, and technical recommendations for systems optimization.


• Enact rigorous database security measures and firewall permissions to ensure unauthorized users cannot access transactional data, customer information, or vendor accounts.


• Develop, execute, and monitor formal policies and procedures for network access controls, user tracking, and automated secure database backup and disaster recovery.


• Operate database management systems to query, clean, and analyze high-volume product SKU datasets, sales histories, and logistical tracking metrics.


• Liaise directly with showroom consultants, shipping clerks, and management staff to evaluate internal data requirements, coordinate data availability, and clean up localized user entry errors.


• Develop, maintain, and audit comprehensive document inventories and digital records tracking real-time stock levels across all active warehouses.


• Requisition manufacturing materials, retail showroom supplies, and inbound luxury kitchen/bath stock based on algorithmic system thresholds.


• Oversee the structural analysis of shipping, receiving, and storage data to prepare high-level logistics and warehouse utilization performance reports for executive review.


• Plan, track, and manage specific operational budgets relating to freight distribution, multi-location logistics, and warehouse material handling costs.

Got a question?

We're here to help. Check out our FAQs, send us an email or call us at 1-800-393-8060