About Us

TransCold Distribution is the premier wholesale supplier and distributor of ice cream and frozen goods throughout Canada and Western United States. Since 2002, we have provided exclusive access to the most recognized ice cream and frozen food brands in the world with industry best product portfolio and customer service.

TransCold delivers to Major Grocery, Drug, Gas & Convenience and Independent Retailers through Direct to Store Delivery (DSD) and Warehouse Fulfillment, and provides services for mobile vendors, corporate events, and third-party logistics (3PL) customers. With 14 locations and 240+ employees, TransCold has the logistical reach to supply all regions across Canada and Western USA with a customer-first attitude.

We are seeking a highly analytical and technically skilled Data Analyst to join our dynamic team. This role is ideal for someone who thrives in a fast-paced, integrated systems environment and is passionate about transforming data into actionable insights. You will play a key role in supporting our 3rd Party Logistics (3PL) operations, SAP B1 ecosystem, and various integration platforms, with a strong focus on identifying and remediating data integrity issues.

Key duties and responsibilities include

·        Design, develop, and maintain reports and dashboards using Pervasive Dashboards, Crystal Reports, SQL, and SAP B1 Calculated Views.

·        Analyze operational data to identify trends, anomalies, and opportunities for process improvement.

·        Ensure data accuracy and integrity across systems, including e3PL, SAP B1, and Descartes.

·        Support and troubleshoot data flows between SAP B1, e3PL, Descartes, and SOCS.

·        Leverage iPaaS tools like Saltbox Integration Platform and DTW for data transformation and automation.

·        Collaborate with IT and business stakeholders to resolve integration issues and optimize workflows.

·        Translate business requirements into technical specifications and data models.

·        Document data processes, integration mappings, and report logic.

·        Contribute to process reengineering initiatives and change management efforts.

·        Work closely with business users, developers, and vendors to gather requirements and deliver solutions.

·        Communicate technical concepts clearly to non-technical stakeholders.

·        Provide training and support to end-users on data tools and reports.

Technical Environment

·        ERP & WMS: SAP B1 (with Boyum Add-Ons), Korber e3PL

·        Integration Tools: Saltbox, DTW, Ramp Interchange (EDI)

·        Reporting Tools: Crystal Reports, SQL, Calculated Views

·        Logistics Tools: Descartes Route Optimization, Proof-of-Delivery

·        Legacy Systems: SOCS, Legacy EDI Providers

Required Skills & Qualifications

·        3–7 years of experience in a data analyst or business analyst role, preferably in a logistics or ERP-integrated environment.

·        Strong SQL skills and experience working with relational databases.

·        Hands-on experience with SAP B1, including Boyum Add-Ons, DTW, and Print & Delivery.

·        Familiarity with integration platforms such as Saltbox or similar iPaaS tools.

·        Experience with Crystal Reports and data visualization best practices.

·        Understanding of EDI workflows and logistics data flows.

·        Excellent analytical thinking and problem-solving skills.

·        Strong communication and documentation abilities.

Preferred Qualifications

·        Experience with SAP S/4HANA and ability to articulate differences with SAP B1.

·        Knowledge of warehouse and logistics operations.

·        Familiarity with route optimization and delivery automation tools.

·        Experience managing user access and authorization controls.

Soft Skills

·        Analytical Thinking: Ability to break down complex processes and identify data-driven solutions.

·        Problem-Solving: Creative and methodical approach to troubleshooting and optimization.

·        Adaptability: Comfortable with shifting priorities and learning new systems quickly.

·        Attention to Detail: High standards for data accuracy and report quality.

·        Collaboration: Strong team player who works well across departments.

·        Communication: Clear and empathetic communicator with both technical and non-technical audiences.

·        Time Management: Skilled at balancing support tasks with long-term projects.

·        Empathy: Patient and user-focused, especially during training or change management.

Why Join Us?

·        Work in a collaborative, tech-forward environment with a focus on innovation.

·        Be part of a growing company with exciting logistics and ERP challenges.

·        Opportunity to make a tangible impact on business operations and decision-making.

Benefits & Perks

·         Comprehensive Extended Health Care Plan including medical, dental, and vision care benefits.

·         AD&D, Long-term Disability, and Life Insurance

·         RRSP matching contribution program

·         Paid time off (birthday leave, vacation leave, sick leave, bereavement leave, and citizenship leave)

·         Employee Assistance Program

·         Educational Assistance

·         Free parking

·        A great group of team members to work with!

·         A dynamic, fast-paced work environment and a company that truly cares about its employees.

·         Opportunities for career development so you can grow with us.

To Apply

To be considered for the above opportunity, we invite you to send a cover letter and an up-to-date resume to cooljobs@transcold.com. Interviews are taking place very soon!!! To learn more about us, visit www.transcold.com.

*****