Data Analyst - Winnipeg Office

Bison Transport Inc.; Winnipeg; On-site; CAD 65,000 - 90,000; Full time

Benefits offered by this job

Coaching and training

Wellness program & sports teams

Meaningful and impactful work

Supportive team culture

Job summary

The Data Analyst at Bison Transport Inc. is a question-first, shared analytical resource supporting Asset, Logistics, Intermodal and LTL across North American operations.

You turn ambiguous business questions into defensible, data-backed answers using our governed data environment. Responsibilities include translating open questions into scoped analyses, writing and validating SQL, using Python for analysis, and building targeted Power BI views to inform operations, commercial, and senior

Qualifications

• 2–5 years in analytics producing decision-grade work.
• Strong SQL with multi-table joins and validating data.
• Python for data analysis, including scripting investigations.
• Power BI to create clean, accurate views.
• Analytical judgment distinguishing rate/mix/data artifacts.

Responsibilities

• Translate open-ended questions into scoped analyses without requiring a fully formed question.
• Write and validate SQL against a governed data warehouse.
• Use Python for analysis beyond SQL.
• Build focused Power BI views for visual answers.
• Support multiple lines of business as priorities dictate.
• Surface data-quality issues explicitly.
• Scope claims to data support and state caveats where needed.
• Communicate findings clearly to non-technical audiences.

Skills

SQL

Python (Pandas)

Power BI

Data manipulation

Communication

Job description

The Data Analyst is a question-first, shared analytical resource supporting all of Bison's lines of business — Asset, Logistics, Intermodal, and LTL — across our North American operations. The role takes ambiguous commercial and operational questions — why a lane is losing money, where empty mileage is concentrating, what has changed in a customer's freight — and turns them into defensible, data-backed answers using our governed data environment. This role is distinct from recurring report development and from statistical modelling. Your main purpose will be to translate a vague business question into a scoped analysis and a clear answer. Priorities shift between lines of business month to month, so breadth and the ability to get up to speed quickly on an unfamiliar corner of the business are central to the role. Outputs inform decisions made by operations, commercial, and senior leadership.

Specific Responsibilities include:

• Translate open-ended questions from operations, commercial, and leadership into scoped, answerable analyses without requiring the question to be fully formed.
• Write and validate SQL against a governed data warehouse to pull and join the data an analysis requires.
• Use Python for analysis, transformation, and investigative work beyond what SQL alone supports.
• Build focused Power BI views where a visual answer serves the audience better than a written one.
• Support any of Bison's lines of business as priorities dictate, ramping quickly on unfamiliar economics and operational context.
• Surface data-quality issues explicitly rather than analyzing around them.
• Scope claims to what the data supports, using ranges over false precision and stating caveats where warranted.
• Communicate findings clearly to non-technical commercial and operational audiences.

Our Ideal Candidate will possess:

• 2-5 years in an analytics or data role producing decision-grade work.
• Strong SQL, including multi-table joins and validating data of uncertain quality.
• Working Python for data analysis (pandas or equivalent), including scripting one-off investigations.
• Sufficient Power BI to build and maintain a clean, accurate view.
• Analytical judgment: distinguishing a rate problem from a mix problem from a data artifact, and stating where certainty is limited.
• Willingness to learn the distinct economics of each line of business — Asset, Logistics, Intermodal, and LTL.
• Clear written communication for a commercial and operational audience.
• Proficiency scripting in Python or R for analysis—clean, correct code, without an expectation of shipping production systems.
• Fluency with data manipulation (SQL, pandas/dplyr, or equivalent).
• Ability to reason about uncertainty and clearly state assumptions and their consequences.
• Demonstrated ability to explain technical work to non-technical audiences.
• Freight, logistics, or transportation domain experience is considered an asset.
• Exposure to network, profitability, or margin analysis is considered an asset.

What this role is not:

• Not a BI/dashboard-development role (that's our Reporting function).
• Not a data science / statistical-modeling role (that’s our Data Science function).
• Not data engineering — you consume the warehouse, you don't build the pipelines.

NOTE: This position is only available to candidates based in Winnipeg, MB.

This job is classified under NOC Code: 21211.

Why Bison:

• Thrive in a supportive team that provides coaching and training to help develop your skills and progress your career
• Dispersed work environments that promote a healthy work-life balance
• Meaningful and impactful work and projects with an essential service provider
• Join our engaging Wellness Program & extracurricular sports teams

About Bison:

• Celebrating over 50 years in Business
• Active in giving back through Corporate Social Responsibility and Charitable Giving
• Committed to environmental sustainability

Bison Transport is committed to Diversity and Inclusion in the Workplace.