TMW SYSTEMS ANALYST & BUSINESS PROCESS SPECIALIST

Manitoulin Group of Companies; Mississauga; On-site; CAD 90,000 - 115,000; Full time

Benefits offered by this job

Great People to Work With

Paid Personal Days

Company Paid Benefits

Company Profit Sharing

Promote from Within

Fun Company Events

Job summary

Vision Transportation in Mississauga, ON seeks an experienced TMW Subject Matter Expert to bridge daily transportation processes with TruckMate capabilities. The role partners with dispatchers, brokers, and admin teams to optimize workflows, build reports, and ensure ISMS-compliant changes.

You will work on-site with Vision Transport and report to Administration while aligning with MGC Shared IT Services under ISO 27001:2022 controls, contributing to smooth operations and continuous improvement.

Qualifications

• 3+ years of direct experience administering, supporting, and optimizing Trimble TruckMate (TMW) in a transportation environment.
• Solid understanding of freight brokerage operations, asset-based trucking, and warehousing concepts.
• Strong SQL query development skills and experience with database navigation and custom report writing.
• Ability to translate operational feedback into efficient software workflow solutions.

Responsibilities

• Partner with dispatchers, brokerage personnel, and warehousing staff to map workflows and identify bottlenecks.
• Leverage TruckMate customization to streamline screen flows and boost productivity.
• Translate business requirements into functional software setups without heavy programming.
• Provide end‑user training and develop documentation for new workflow enhancements and reports.

Skills

SQL proficiency

Business analysis

Freight brokerage knowledge

On-site availability

Tools

Trimble TruckMate

DB2

Crystal Reports

SSRS

SAP BusinessObjects

Job description

At Vision Transportation, it is our mission to provide a great work environment for all our employees! Our core values are trust, teamwork, innovation, positivity and wellness. With three locations, Vision Transportation continues to grow and we are always looking for talented professionals to join our family. We are looking for passionate and experienced people in the logistics industry. If you if you enjoy working in a fast-paced environment you will thrive in this position.

Vision Transport is seeking an experienced TMW (Trimble TruckMate) Subject Matter Expert to join our team on-site in Mississauga, ON. In this role, you will serve as the crucial operational bridge between daily transportation business processes and TMW software capabilities.

Working directly alongside dispatchers, brokerage specialists, and administrative teams, you will optimize TruckMate workflows, customize user interface screens, build complex database reports, and streamline operational procedures. You will report directly to Vision Transport Administration while maintaining alignment with Manitoulin Group of Companies (MGC) Shared IT Services, strictly adhering to ISO 27001 ISMS policies and corporate Change Management frameworks.

Key Responsibilities:

1. Workflow Optimization & Business Process Alignment

• Partner directly with Vision Transport dispatchers, brokerage personnel, and warehousing staff to map current workflows and identify operational bottlenecks.

• Leverage native TruckMate customization capabilities (table-driven settings, menu options, custom fields, and layout modifications) to streamline screen flows and boost user productivity.

• Translate business requirements into functional software setups without relying on unnecessary custom programming.

2. Reporting & Data Analysis

• Analyze TruckMate database schemas and data structures to develop, optimize, and maintain custom operational and executive management reports.

• Utilize SQL, Crystal Reports, SSRS, or SAP BusinessObjects to provide actionable insights for freight brokerage, asset utilization, and warehousing metrics.

• Ensure custom queries and reports are optimized to prevent performance degradation on the underlying DB2 database infrastructure.

3. IT Governance, Security & Change Management

• Adhere strictly to Manitoulin Group of Companies' Information Security Management System (ISMS) policies and ISO 27001:2022 security controls.

• Follow formal IT Change Management procedures by thoroughly testing and vetting all system changes, interface configurations, and new reports in the Development environment prior to production release.

• Collaborate with MGC Shared IT teams (Infrastructure, Development, EDI) to request vendor SOWs (e.g., Trimble EDI configurations) or specialized environment support.

4. End-User Support & Training

• Provide hands‑on, in‑office support and functional guidance to operational staff regarding best practices within TMW TruckMate.

• Develop user documentation and conduct training sessions for staff on new workflow enhancements, report usage, and system updates.

Required Experience & Skills

• Trimble TruckMate Expertise: Minimum 3+ years of direct experience administering, supporting, and optimizing Trimble TruckMate (TMW) in a transportation environment. Experience with recent releases (v24/v25+) preferred.

• Domain Knowledge: Solid understanding of freight brokerage operations, asset-based trucking, and warehousing concepts, terminology, and workflows.

• Technical & SQL Proficiency: Strong SQL query development skills and demonstrated experience in database schema navigation and custom report writing.

• Business Analysis: Proven capability to translate complex operational feedback from dispatchers and managers into efficient software workflow solutions.

• On‑Site Availability: Ability to work full‑time on‑site at the Mississauga, ON office. Work can be performed remotely as needed.

Preferred Qualifications

• Experience operating within an ISO 27001 certified environment or structured ITIL change management framework.

• Familiarity with DB2 database structures and basic query execution plan optimization.

• Previous experience in a shared services corporate model collaborating across IT and business units.

What do we offer to you?

• GreatPeople toWorkWith!
• Paid Personal Days
• Company Paid Benefits
• Company Profit Sharing
• Promote from Within
• Fun Company Events!

Expected Salary Range: CAD $90,000 - $115,000 / year (commensurate with experience)

Some travel may be required