TMX Group is a leading global exchange organization that enhances capital markets. The Fixed Income and Reference Data Analyst Intern will work closely with the Global Corporate and Reference Data Team, focusing on business intelligence, automation, and scripting to drive revenue and improve data processes.
Automation of monthly fixed income trading data statistics and posting to Quicksight
Generation of Issuance/Maturity Waterfall and automate code to update monthly and post to Quicksight
Automation and posting to Quicksight of Government of Canada Cash trades vs. Futures in support of MX team
Evaluation of what we can do with the Terms & Conditions data currently maintained in PDF documents as we now have those centralized
Automate monthly graphs, charts and commentary email based on monthly summary statistics
Write code to automatically search daily Fixed Income Trade Data (FITD) - Corporate Bonds and FITD - Provincial Bonds daily files and where Coupon or Notional are missing then populate our Reference Google sheet with details and search for missing details
Create the MVP version of our Unified corporate actions offering - Review CDS corporate actions data loaded into EDP (bulletins + entitlements) and develop requirements to normalize, standardize data used to merge into a Golden Copy
Create a shareable AWS Quicksight dashboard providing insights from CDS Corporate actions (bulletins + entitlements) data loaded into EDP
Create a shareable AWS Quicksight dashboard providing longitudinal insights from CDS Security Master
Qualification
Required
Currently enrolled in a Bachelor's or Master's program in Computer Science, Data Science, Finance, or a related quantitative field
Strong proficiency in Python (Pandas, NumPy) and SQL
Experience with data visualization tools (Tableau, Quicksight) is a significant asset
Familiarity with cloud platforms (AWS, Google Cloud)
Excellent analytical and problem-solving skills
Ability to work independently and manage multiple tasks effectively
Good communication skills, both written and verbal
Preferred
Data lakes/warehouses (Snowflake) is a plus
Benefits
Generous time-off and leaves
TMX Group is a corporation that manages many marketplaces to offer investment options to its clients.