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

ASL Distribution is an equal opportunity employer committed to creating a diverse, inclusive, and accessible workplace. We welcome applications from women, visible minorities, Indigenous peoples, persons with disabilities, and all qualified individuals.

If you require an accommodation at any stage of the recruitment process, please contact us at [email protected] and we will work with you to meet your needs.

ASL Distribution Services Company Profile:

ASL Distribution, part of the Fastfrate Group, is a leader in Canadian transportation, warehousing and fulfillment services, supporting top North American brands with efficient, customer focused solutions.

With customized supply chain solutions, ASL’s transportation warehousing and fulfillment teams expertly manage the transportation, receiving, warehousing, picking, packing, and shipping of products with precision and efficiency.

It’s an energetic, fast-paced environment, ideal for individuals who excel in teamwork, problem solving, and building efficient solutions to move goods through the supply chain.

Why you’ll love working here:

• A workplace where you can learn, grow, and build your career
• A culture that encourages new ideas and continuous improvement
• Supportive leaders who provide guidance while giving you autonomy
• A team-focused environment
• A competitive total-rewards package, including group benefits and a company-sponsored retirement savings plan
• Support for professional memberships, training, and certifications

The Opportunity:

This is your chance to join a team where your work truly makes an impact. In this role, you will contribute directly to the success of our customers, our operations, and the Fastfrate Group as a whole. You’ll work in a supportive environment that values collaboration, problem-solving, and continuous learning.

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.

How To Apply:

If you’re interested in joining our team, please submit your application through our online career portal. We appreciate all applicants; however, only those selected for an interview will be contacted.

Disclaimer: We use some technology-based tools, which may include artificial intelligence (AI), to support application screening; however, all hiring decisions include human review.