Data and Operations Analyst

Location : Edmonton, Alberta

Employment Type : Full-time, Permanent

Experience Level : Early-career cloud experience with strong analytical, finance, and operations background

About AgileFreight

AgileFreight is a data-focused freight and logistics company that leverages analytics, cloud technologies, and structured operational information to improve freight planning, carrier selection, pricing, execution, and business performance. Our long-term strategy is to build a modern, data-driven operating model where every operational decision is supported by reliable information and analytics.

Position Summary

The Data and Operations Analyst will develop and maintain datasets, reports, dashboards, and analytical models that support AgileFreight's freight operations. The role combines data analytics with operational execution by applying insights to load booking, execution planning, pricing, profitability analysis, and continuous process improvement while helping build the company's Google Cloud analytics platform.

Primary Data & Analytics Responsibilities

• Collect, organize, clean, validate, and maintain operational and financial data from multiple business systems.
• Document business, reporting, and data requirements.
• Design and maintain structured datasets supporting shipments, customers, carriers, pricing, and profitability.
• Write SQL queries to extract, transform, validate, and analyze data.
• Develop dashboards and KPIs using Power BI, Looker Studio, and Excel.
• Perform trend, variance, profitability, forecasting, and performance analysis.
• Maintain data dictionaries, business rules, metadata, and analytical documentation.
• Support data quality, governance, backup, and information management practices.
• Assist with Google Cloud Platform services, including Databricks, BigQuery, Cloud Storage, and Looker Studio.

Data-Driven Freight Operations

• Use historical shipment, pricing, and carrier-performance data to support load booking decisions.
• Prepare shipment execution plans using customer requirements, capacity, service levels, and operational constraints.
• Analyze carrier performance, transit times, and lane profitability.
• Monitor shipments and update operational datasets.
• Recommend operational improvements based on analytical findings.

Financial & Business Analysis

• Analyze shipment revenue, carrier costs, margins, and customer profitability.
• Support budgeting, forecasting, business cases, and management reporting.
• Reconcile operational and financial information.
• Assist with invoice verification, accounts receivable analysis, and QuickBooks updates where required.

Education

Master's degree in Statistics, Mathematics, Data Science, Business Analytics, Finance, Economics, Accounting, or a related discipline.