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 & Workplace:

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 clean

📌 IT Business Analyst, Data (Oakville)
🏢 Fastfrate Group
📍 Oakville