Job Description

WHY TRIMAC?
Trimac Transportation is a leader in the bulk transportation industry with over 140 locations throughout Canada and the US. The average age of our fleet hovers around 5 years with innovative in-cab technology to assist with safety, route planning, fuel usage, and communication.

Trimac offers career progression, competitive pay, benefits, and job security; 75 years is a legacy you want to be a part of!

THE ROLE
Trimac is a Noth American wide enterprise that is the process of transforming itself to becoming a leader in the transportation space through its Digital Transformation initiatives. This includes adopting cloud native technologies, upskilling its employees and modernizing infrastructure. The IT team is leading this journey through adopting technologies like AWS, Kubernetes, CI/CD pipelines, NodeJS, ReactJS, MongoDB etc. to enable the business enhance the experience of its employees, drivers and customers.

The Data engineer role is expected to serve two mindsets, help support existing analytic workloads in the traditional environment and start opportunistically migrating to public cloud services, that build on the micro-service environment to enable the next generation of business success through real-time analytics and data science workloads.

Location: Remote
Schedule: M-F; 40 hrs/week

RESPONSIBILITIES
  • Source data and build relationships from a variety of sources including: Trimac data warehouse, operational applications, third party application thru API, other industry sources
  • Maintaining and optimizing existing data models (SSAS, Data warehouse, SQL)
  • Support the broader Business intelligence team with data management, data governance and data flow activities
  • Use available data to develop reports that provide management insight into operations, safety or financial matters

SKILLS/ KNOWLEDGE
Required
  • Microsoft Power BI
  • SQL Server programming and development tools
  • Data modeling using SSAS (SQL Server Analysis Services)
  • Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • ETL and data warehousing tools and architecture
  • Data Analysis Expressions (DAX)
  • PowerShell
  • GitHub/Git
Nice to have
  • Experience using APIs
  • AWS, Microsoft Azure
  • R, Python, Kubeflow
  • Experience in ITIL Change Management/Quality Assurance practices
SAFETY IS OUR CORE VALUE
  • We make Safety a part of every decision.
  • We make Safety personal.
  • We have the courage to intervene.
Trimac Transportation is an equal opportunity employer that is committed to employment equity. We value a diverse workforce and are committed to hiring practices that are fair and equitable.

We appreciate your interest and taking the time to apply, however only those selected for interviews will be contacted. Thank you!

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online