Internship - Financial Planning Analyst / Bi Analyst

Position: Internship
Title: Financial Planning Analyst / BI Analyst
Term: Apr 1, 2024 - Jul 31, 2024
Location: Calgary, AB
WHY TRIMAC?
Are you a highly motivated self-starter who continually looks for new opportunities and initiatives to drive change across the organization? Are you looking for a creative, challenging job that contributes to your community's way of life in a stable industry? Are you highly collaborative and believe that the best results are achieved through strong relationships and partnerships? Trimac is a North American company with over 75 years of history that is geared to embrace a changing, technology-driven future and we're looking for candidates who want to join us on our journey!
Summary:
Trimac Transportation headquartered in Calgary, AB, is looking for a Financial Planning Analyst / BI Analyst intern to assist with driving performance through financial insights and business insights. We are looking for an ambitious, talented individual interested in developing their skills in financial modeling and data analytics. The ideal candidate will be proficient in Microsoft Excel, and Microsoft Power BI tools; and knowledgeable in financial principles and data analytics.
The Intern will be reporting to the Manager of Financial Analysis and reporting to the Manager of Strategic Planning.
Responsibilities:
This position will have the opportunity to work across many projects currently underway within the company including:
Finance :

• Monitor and track capital expenditures to ensure they align with approved budgets and financial objectives, identifying gaps and recommendations concerning overages or major changes to capital forecasts.
• Participate in due diligence efforts, including reviewing financial statements, conducting industry analysis, and identifying risks and opportunities.
• Perform financial modeling/Discounted Cash Flow to support the M&A team in evaluating potential transactions and related negotiating strategies.
• Conduct industry research to establish market-comparable benchmarks for various operational and financial performance metrics.
• Support the development and maintenance of forecasts and reporting that reflect company objectives and capabilities, strategic initiatives, and external fundamentals.

Data Modeling :

• Design and implement data models to support business reporting needs.
• Ensure data accuracy, consistency, and reliability in the reporting environment.
• Retrieve and manipulate data using SQL queries to meet reporting requirements.
• Create and optimize DAX (Data Analysis Expressions) formulas for Power BI reports.
• Document data sources, transformation processes, and report logic for future reference.
• Maintain documentation for Excel models, VBA scripts, and Power BI reports.

Skills:

• Knowledge of financial modeling, 3-statement analysis, and financial accounting concepts
• Discounted Cash Flow/NPV Analysis
• Knowledge of Data modeling, Power BI, DAX, SQL, Excel VBA Macros, and Advanced Excel functions
• A keen eye for detail with a high degree of accuracy
• Strong written and verbal skills at the business level.

Requirements/Education Studies:

• Current student in Financial Planning or equivalent fieldin finance.
• No experience required.