Analyze Information Security spending as a GTS Finance Coordinator Intern with TMX, using advanced Excel and Google Sheets to reconcile complex datasets.
This internship supports Global Technology Services Information Security leadership and finance teams. You will clean, categorize, map, and analyze global security technology spend across vendors, contracts, invoices, Trayport, and TSX platforms. The work centers on foundational datasets, financial visibility, and accurate reporting.
Key Responsibilities:
- Clean and categorize historical Information Security transaction data
- Reconcile committed contracts and licensing values against actual expenditures
- Map global spend across Trayport and TSX platforms
- Prepare spreadsheets, dashboards, and executive financial summaries
- Explore Google Gemini for categorization, extraction, and reporting
Requirements:
- Currently enrolled in third- or fourth-year Finance, Accounting, or Commerce
- Advanced Google Sheets and Excel skills, including VLOOKUPs and pivot tables
- Ability to manage large datasets independently and accurately
- Transparent written and verbal communication with technology stakeholders
- Proactive analytical problem-solving and deadline management abilities
Apply financial analysis, spreadsheet expertise, and investigative thinking to strengthen TMX Information Security spending visibility and reporting.