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.

Required Experience

• Several years of experience in data analysis, financial analysis, management reporting, operational analysis, or business intelligence.
• Experience in profitability analysis, cost allocation, variance analysis, management reporting, and business case development.
• Experience collecting, validating, reconciling, and analyzing data from multiple sources.
• Experience creating dashboards, KPIs, and executive reports.
• Working knowledge of SQL and relational databases.
• Strong Microsoft Excel skills, including PivotTables, advanced formulas, and data modeling.
• Experience with Power BI, Looker Studio, Tableau, or similar BI tools.
• Beginner-level knowledge of Google Cloud Platform is sufficient; willingness to develop expertise is expected.
• Experience in logistics or transportation is an asset but not required.

Professional Competencies

• Strong analytical and mathematical reasoning
• Excellent communication and documentation skills
• High attention to detail
• Ability to translate data into operational decisions
• Curiosity and continuous learning mindset

Pay: $45,227.50-$65,220.97 per year

Benefits

• Casual dress
• Flexible schedule
• On-site parking
• Paid time off

Work Location: In person