Data Analyst

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

Benefits offered by this job

Wellness Program

Extracurricular sports teams

CSR and charitable giving

Job summary

Bison Transport Inc. is seeking a Data Analyst to translate ambiguous business questions into scoped analyses and data-backed answers across Asset, Logistics, Intermodal, and LTL.

You will pull and join data with SQL, analyze with Python, and present findings using Power BI to non-technical leaders. You will need 2-5 years in analytics, strong SQL, Python, and Power BI skills, plus clear written communication.

Qualifications

• 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).
• Sufficient Power BI to build and maintain a clean, accurate view.
• Analytical judgment: distinguishing rate/mix/data artifacts, state uncertainty clearly.
• Willingness to learn distinct economics of 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.
• Fluency with data manipulation (SQL, pandas/dplyr).
• Ability to reason about uncertainty and state assumptions clearly.
• Demonstrated ability to explain technical work to non-technical audiences.
• Freight, logistics, or transportation domain experience is an asset.
• Exposure to network, profitability, or margin analysis is an asset.

Responsibilities

• 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 investigations beyond what SQL 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 and caveats where warranted.
• Communicate findings clearly to non-technical commercial and operational audiences.

Skills

SQL

Python

Power BI

Data analysis

Communication

Data manipulation

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.

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.