IT Business Analyst, Data & Business Intelligence - ASL Distribution (Oakville)

Fastfrate Group

Oakville

On-site

CAD 69,000 - 110,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Fastfrate Group is seeking an IT Business Analyst to improve data quality, reporting, systems integration, and business processes across transportation, logistics, and distribution operations. The role collaborates with Operations, Finance, and IT to deliver scalable, data-driven solutions using SQL, Python, and Power BI in an on-site environment at Oakville.

The position focuses on data analytics, operational efficiency, and financial accuracy, with responsibilities spanning data cleansing,

Qualifications

  • Strong analytical capabilities to translate data into actionable insights.
  • Ability to communicate effectively with business users and IT teams.
  • Experience with data quality, data cleansing, and data governance.

Responsibilities

  • Develop, maintain, and enhance Power BI dashboards and KPI reports.
  • Consolidate data from multiple systems to improve reporting accuracy.
  • Gather reporting requirements from stakeholders and translate into dashboards.
  • Automate recurring reports and streamline data extraction & transformation.
  • Support data integration and validation across platforms.
  • Document processes, data definitions, and corrective actions for ongoing improvements.

Skills

Analytical skills
Communication
Detail-oriented
Multitasking

Education

Bachelor's in Analytics/IT/Data Science

Tools

Power BI
SQL
Python
Excel

Job description

Role Summary:

The IT Business Analyst is responsible for improving data quality, reporting, systems integration, and business processes across transportation, logistics, and distribution operations. Working closely with Operations, Finance, and IT teams, this role leverages data analytics, business intelligence, and technology solutions to enhance operational efficiency, strengthen financial accuracy, and support informed decision-making. The successful candidate will combine strong analytical skills with expertise in SQL, Python, Power BI, and enterprise systems to deliver scalable, data-driven solutions that drive business performance.


Hours of Work:

Monday to Friday, 8:00am – 4:30pm


Work Arrangement:

On-site


Position Type:

Non-Union


Employment Status:

Temporary (3-month contract with possibility of extension)


Compensation:

Hourly Range: $50.00 - $80.00/ hour


Work Location & Environment:

2160 Buckingham Road, Oakville ON; Office environment


Key Accountabilities:

Business Intelligence & Reporting


  • Develop, maintain, and enhance Power BI dashboards and operational KPI reports.

  • Consolidate data from multiple business systems to improve reporting accuracy and visibility.

  • Work with business stakeholders to gather reporting requirements and translate them into actionable dashboards.

  • Automate recurring reports and improve the efficiency of data extraction and transformation.


Data Cleansing & Quality Management


  • Identify and resolve duplicate, missing, inconsistent, and inaccurate records across business systems.

  • Develop automated data validation, cleansing, and reconciliation processes using SQL and Python.

  • Investigate data discrepancies and work with technical and operational teams to address root causes.

  • Establish ongoing data quality checks, exception reporting, and monitoring processes.


Financial Data Consolidation & Reconciliation


  • Support the consolidation and validation of financial data from multiple operational platforms.

  • Investigate discrepancies between billing, invoicing, rating, and settlement data.

  • Identify missing transactions, duplicate charges, incorrect rates, and other financial data inconsistencies.

  • Develop reconciliation reports and automated controls to improve financial accuracy.

  • Work with Finance and IT to improve data flows and reduce manual corrections.


Route Optimization & Operational Analytics


  • Support the analysis and continuous improvement of routing and optimization engines.

  • Analyze delivery routes, service areas, postal code mappings, and operational performance data.

  • Identify routing inefficiencies, data-related issues, and opportunities to improve delivery performance.

  • Work with Operations and technical teams to test and validate routing improvements.

  • Develop reporting to measure routing efficiency, exceptions, and optimization results.


Systems Integration & Data Support


  • Support data integration and information exchange between transportation, warehouse, delivery, and financial systems.

  • Investigate issues with data pipelines, APIs, and scheduled data processing.

  • Assist with data mapping, transformation, and standardization across platforms.

  • Provide technical and analytical support for production data issues.

  • Collaborate with developers and system administrators to troubleshoot and resolve data-related incidents.


Business Analysis & Continuous Improvement


  • Gather and document business requirements, workflows, and process improvement opportunities.

  • Translate operational and financial challenges into technical requirements.

  • Conduct data analysis to identify trends, exceptions, and opportunities for automation.

  • Support user acceptance testing, data validation, and implementation of system enhancements.

  • Document processes, data definitions, and corrective actions to ensure sustainable improvements.


Qualifications:


  • Education in Business Analytics, Information Technology, Computer Science, Data Science, or a related field.

  • Experience in logistics, transportation, distribution, or supply chain operations.

  • Familiarity with transportation management, warehouse management, or delivery management systems.

  • Experience with SQL, Python, Excel, and Power BI.

  • Understanding of ETL processes, data cleansing, transformation, and validation.

  • Experience working with relational databases and multiple data sources

  • Exposure to financial reconciliation, invoicing, settlement, and rating processes.


Skills and Abilities:


  • Strong analytical, troubleshooting, and problem-solving abilities.

  • Ability to communicate effectively with both business users and technical teams.

  • Strong attention to detail, particularly when working with financial and operational information.

  • Ability to manage multiple priorities and work independently.

  • Understanding of route optimization, operational analytics, or process automation.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Intelligence Analyst
Business Intelligence Analyst

Altis Technology • Mississauga

Hybrid
CAD 79,000 - 97,000
Hybrid work model
Accessibility accommodations
IT - After Hours Support - ASL Distribution (Oakville)
IT - After Hours Support - ASL Distribution (Oakville)

Fastfrate Group • Oakville

On-site
CAD 69,000 - 110,000
IT Business Analyst (Finance)
IT Business Analyst (Finance)

Careermine • Vaughan

On-site
CAD 80,000 - 110,000
Business Analyst
Business Analyst

Dollarama • Mount Royal

On-site
CAD 70,000 - 90,000
IT Business Analyst - Digital Integrations
IT Business Analyst - Digital Integrations

Imperial • Quebec

Hybrid
CAD 75,000 - 110,000
HR Business Partner - ASL Distribution (Oakville)
HR Business Partner - ASL Distribution (Oakville)

Fastfrate • Oakville

On-site
CAD 65,000 - 85,000
Manager Technology Analytics and Reporting
Manager Technology Analytics and Reporting

Purolator • Mississauga

On-site
CAD 120,000 - 170,000
Data Analyst / Business Intelligence Analyst
Data Analyst / Business Intelligence Analyst

NorthBridge Analytics • Ottawa

Hybrid
CAD 75,000 - 90,000
Company pension
Dental care
Flexible schedule
+3
Business Data Analyst
Business Data Analyst

Insight Global (United States) • Vancouver

Hybrid
CAD 75,768 - 82,656
BI Analyst
BI Analyst

PACT - Pearson Accelerator Construction Team • Mississauga

On-site
CAD 70,000 - 110,000