Data Analyst - Winnipeg Office

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

Benefits offered by this job

Wellness Program

Extracurricular sports teams

Corporate social responsibility (CSR)

Job summary

Bison Transport Inc is seeking a Data Analyst to translate ambiguous business questions into scoped analyses and data-backed answers. You will work across Asset, Logistics, Intermodal and LTL, using SQL, Python and Power BI to deliver actionable insights for operations, commercial, and leadership teams.

The role emphasizes quick learning of different business contexts, strong data governance, and clear communication of findings to a non-technical audience.

Qualifications

• 2–5 years in an analytics or data role producing decision‑grade work.
• Strong SQL, including multi‑table joins and data validation.
• Working Python for data analysis, including scripting investigations.
• Sufficient Power BI to build and maintain a clean, accurate view.
• Analytical judgment and ability to explain technical work to non‑technical audiences.

Responsibilities

• Translate open-ended questions into scoped, answerable analyses.
• Write and validate SQL against a governed data warehouse to pull data.
• Use Python for analysis, transformation, and investigations beyond SQL.
• Build focused Power BI views to present visuals as answers.
• Support multiple lines of business (Asset, Logistics, Intermodal, LTL) as priorities shift.
• Surface data-quality issues and state assumptions and caveats clearly.

Skills

SQL

Python

Power BI

Data analysis

Analytical thinking

Communication

Tools

SQL Editor

Python (Pandas)

Power BI

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.

Background and suitability for a career in Transportation is wide ranging.

Some of our brightest people have joined us with no previous “trucking” experience.

We always say we work in the “people business”. So, whether you have a background in the airline, automotive, retail or hospitality industries, to name a few, your experience is valuable and we are bound to find many transferrable skills.

We are ready to welcome exceptional, high potential contributors who aspire to lead people and processes in the pursuit of service excellence in a highly dynamic and collaborative environment.

We seek team players who are eager to learn our business from the ground up, are able to demonstrate a track record of strong performance and possess a sincere interest in growing their careers in the transportation arena.

We seek top notch communicators who adopt a driver of change mindset of “how can we be better, do better and get better results”.