Apply on Kit Job: kitjob.ca/job/2fsn6n

About the Role: Botsford Associates is supporting a major banking client on a Capital Markets data transformation program aimed at improving Straight Through Processing (STP) across the trade lifecycle. This is a current, open contract role supporting one of our financial services client.The program focuses on streamlining trade data flows from front-office order management / trade booking systems through downstream middle-office and settlement platforms. Currently, trade data from multiple OMS systems converges into a centralized layer where it must be standardized and normalized before being distributed to downstream systems.We are seeking a Senior Data Modeler with strong Capital Markets trade data expertise to design and implement a canonical trade data model that will support standardized processing and improved trade lifecycle data flows.Rate: $90-$100/hr CAD Incorporated Key Responsibilities:Design logical and physical data models to normalize trade data across multiple front-office booking systems.Define and implement a canonical trade data model supporting multiple asset classes and trade lifecycle events.Analyze and map trade data from OMS / trade capture systems into standardized schemas.Work with trade data formats including FIX, FpML, XML and other financial messaging standards.Collaborate with Front Office, Operations,



and Technology teams to ensure the model supports front-to-back trade flows from booking through settlement.Define data mappings, normalization rules, and data quality controls to ensure consistency and accuracy of trade data.Document data lineage, metadata, and data dictionaries supporting enterprise data governance.Required Experience:7+ years of data modeling experience in financial services.Robust knowledge of Capital Markets trade lifecycle and trade data structures.Experience working with FIX protocol, FpML, XML / XSD trade data formats.Hands-on experience with enterprise data modeling toolsStrong SQL and experience working with financial/enterprise data platforms (Cloud/Big Data Platforms/Environments would be preferred)Ability to work closely with trading, operations, and technology teams to standardize complex trade data flows.While we thank all interested applicants in advance, we will only contact those selected for an interview. All interviewed candidates will be notified of the hiring decision within 45 days of their interview.Artificial intelligence may be used during the initial resume screening process to identify qualified candidates. Your personal data is collected solely for recruitment purposes in compliance with applicable privacy laws.

Apply on Kit Job: kitjob.ca/job/2fsn6n

📌 Data Modeler (Oakville)
🏢 Botsford Associates
📍 Oakville