Data Analyst

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

Benefits offered by this job

Coaching and training

Wellness program

Extracurricular sports teams

Job summary

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

The role uses SQL, Python, and Power BI within a governed data environment to deliver actionable insights for operations, commercial, and leadership teams. Ideal candidates have 2–5 years in analytics, strong data manipulation skills, and the ability to translate findings for non-technical audiences.

Qualifications

• 2-5 years in analytics or data role delivering decision-grade work.
• Strong SQL with multi-table joins and data-quality validation.
• Proficient in Python for data analysis and scripting investigations.
• Power BI to build and maintain clear, accurate views.
• Able 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.
• Use Python for analysis, transformation, and investigations beyond SQL.
• Build focused Power BI views to visualize findings for stakeholders.
• Surface data-quality issues explicitly and state caveats where warranted.
• Communicate findings clearly to non-technical commercial and operational audiences.

Skills

SQL

Python

Power BI

Data analysis

Communication

Analytical thinking

Business understanding

Tools

Pandas

R

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 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. 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”.