Data Conversion Analyst

Description Data Conversion ManagerWho We AreAt Fidelity, we’ve been helping Canadian investors build better financial futures for over 35 years. We offer individuals and institutions a range of trusted investment portfolios and services - and we’re constantly seeking to find new and better ways to help our clients. As a privately owned company, we boldly embrace innovation in all areas as we continue to grow our business into the future. Working with us means you’ll be part of a diverse and dedicated group of people who make a real difference for our clients and communities every day. You’ll have a wide range of opportunities to grow and develop your career in an inclusive environment where you’ll feel valued and supported to be your best - both personally and professionally.Business OverviewFidelity Clearing Canada (FCC) is the leading independent clearing broker and custodian in the Canadian market. We provide trade execution, clearing, custody and back-office support services to Canadian-based brokerage firms and the Canadian brokerage arms of U.S.-based firms.For more information about Fidelity Clearing Canada, please visit The OpportunityThe Technical Conversion Manager, FCC is responsible for the technical data components of implementing new clients to FCC. This includes developing, enhancing, and maintaining conversion utilities (internal) for a bulk data conversion and understanding the functionality of external conversion utilities utilized by the books & records provider. In addition, this role is responsible for data loading, scripting, and mining as well as maintaining accurate data mapping.What You Will DoBulk and ad-hoc data loading, scripting, data mining using house conversion toolsHandle large sets of data cleaning and manipulation of upwards from 100,000 to millions or recordsWorking closely with the books & records provider to complete configuration for Dataphile to Dataphile data replication and conversionsResponsible for delivering clear requirements for data modification requests and conversion script selectionsCompleting data analysis on the incoming client, account, position, security, and transaction recordsCreating and maintaining conversion utilities for managing aspects of client dataHandling the post-conversion sweep process, ensuring adherence to FCC transaction code standardsMaintaining conversion data mapping, performing necessary QA and version controlConsulting with external stakeholders for agreement and approval on all configuration and mapping.Other duties as requiredWhat We’re Looking For:3+ years working experience within the brokerage industry preferredCompletion of a post-secondary education or equivalent work experienceAdvanced Excel skills in using Excel functions, conditional formatting, pivot tables, charting, and Power Query (M Language). Knowledge of VBA & Macros is nice to have.Relevant experience with Python and its data processing libraries and packagesRelevant experience working with flat files/text database and ETL. Experience with Regular Expressions is an asset.SQL knowledge with relevant experience working with SQLite and MySQL/MariaDBExperience with MS SQL Server and Oracle database is an assetKnowledge or relevant experience with Broadridge Dataphile, OSS/ISM or other stock brokerage accounting systems, understanding of brokerage operations is an assetExperience using JIRA, Confluence, Bitbucket (GIT) is preferredExperience with data analytics, automation using Power Automate, screen scraping, web scraping is an assetCompletion of Canadian Securities Course is an assetThe Expertise You Bring:Strong foundation in programming logic and skill in handling large datasetsSolid understanding of the Canadian brokerage industry in both the retail and institutional segmentsAbility to analyze technical requirements and documentationAbility to work with cross-functional teamsHigh attention to detailStrong analytical & organizational skillsOutstanding verbal, and written communication skills