It Business Analyst, Data & Business Intelligence - Asl Distribution (Oakville)

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:30pmWork Arrangement:
On-sitePosition Type:
Non-UnionEmployment Status:
Temporary (3-month contract with possibility of extension)Compensation:
Hourly Range: $50.00 - $80.00/ hourWork Location & Environment:
2160 Buckingham Road, Oakville ON;
Office environmentKey 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 sourcesExposure 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.
#J-18808-Ljbffr