Analyst, Corporate Finance - Greater Calgary Metropolitan Area

Job Summary · The Analyst, Corporate Finance will play a pivotal role in driving strategic financial decisions through advanced analytics, financial modeling, and investment analysis. Reporting to the Director of Capital and Financial Planning, this analytically oriented position ...

Job description

Job Summary

The Analyst, Corporate Finance will play a pivotal role in driving strategic financial decisions through advanced analytics, financial modeling, and investment analysis. Reporting to the Director of Capital and Financial Planning, this analytically oriented position focuses on cash flow modeling, business case development, and capital investment management to optimize financial performance and asset utilization. The Analyst will also deliver forward-looking forecasts and provide support for treasury and cash management functions to ensure the organization's operational and capital funding needs are met.

This role is ideal for a proactive, detail-oriented professional with strong financial expertise and sound business acumen. This individual can work effectively across departments, leverage data to drive insights, and seamlessly translate those insights into actionable recommendations to influence key business decisions.

Responsibilities

• Conduct detailed cash flow and discounted cash flow (DCF) modeling to assess potential investment opportunities.
• Develop robust business cases for capital investment projects, ensuring alignment with strategic and financial goals.
• Perform financial due diligence on investment opportunities, evaluating risks, returns, and long-term value creation.
• Maintain a holistic, multi-year view of capital investments across fleets, prioritizing equipment utility and return on net assets (RONA).
• Collaborate with stakeholders to align capital allocation with business priorities and financial objectives.
• Leverage Power BI and the Microsoft suite of tools to support enterprise financial planning and analysis (FP&A) with a strong focus on capital planning, fleet analytics, and return on net assets (RONA).
• Partner internal stakeholders to translate capital planning and performance management requirements into intuitive dashboards, models, and analytical tools that inform decision-making.
• Integrate financial, operational, and fleet-level data from multiple sources to deliver consistent, accurate, and timely insights into asset utilization, capital efficiency, and RONA performance.
• Utilize Microsoft Excel, including advanced formulas, Power Query, and scenario modeling, to support detailed capital investment analysis, fleet replacement modeling, and forward-looking financial forecasts.
• Automate recurring FP&A, capital, and fleet performance reporting using Microsoft tools (e.g., Excel, Power BI, VBA) to improve efficiency, accuracy, and repeatability.
• Analyze internal and external data to uncover trends, risks, and opportunities that support data-driven decision-making.
• Identify performance improvement initiatives across operations and finance through actionable insights derived from analytics.
• Enhance operational efficiency and financial performance by providing recommendations grounded in comprehensive data analysis.
• Build forward-looking forecast models to predict the financial and operational impact of business decisions.
• Analyze potential scenarios and outcomes, delivering recommendations to leadership based on forecast results.
• Support long-term planning by modeling the implications of investment and operational strategies.

Qualifications

• Bachelor's degree in Finance, Accounting, Economics, Mathematics, or a related field.
• Minimum of 3 years in a corporate finance, financial planning, or investment analysis role, with a strong emphasis on analytics and data-driven decision-making.
• Experience with Power BI and Microsoft suite of applications (VBA, macros, etc.) and usage to develop/visualize business insights and dashboards.
• Exceptional ability to interpret complex data sets and translate them into actionable business insights.
• Advanced proficiency in financial modeling, including cash flow and discounted cash flow (DCF) analysis.
• Expertise in Microsoft Excel for financial analysis, forecasting, and scenario modeling.
• Strong understanding of financial metrics (e.g., IRR, NPV, ROI) and their application to investment decisions.
• Deep knowledge of financial principles, capital investment strategies, and their linkage to operational performance.
• Excellent ability to distill complex financial data into clear, concise presentations for diverse stakeholders.
• Experience with forward forecasting, scenario analysis, and business case development for capital investments.
• Familiarity with treasury and cash management principles, including cash flow forecasting and optimization.
• Knowledge of the transportation or logistics industry and its financial drivers.