Data Expert (Trade & Transaction Data Transformation) Location: Toronto, ON/Halifax, NS – Hybrid(4 days onsite) Contract Length: 6 Months We at Raise are hiring a Data Expert (Trade & Transaction Data Transformation) for one of our top clients.

Capital

Markets (Banking CM) is seeking an experienced and highly motivated data expert, responsible for leading and designing trade and transaction data models and data products to support a transformational operations initiative, inclusive of creating and optimizing end-to-end real-time exception workflows. This role bridges data modeling, data product strategy, and business operations to establish a unified, asset-agnostic data ecosystem. You will own the end-to-end data product lifecycle—from requirements definition through deployment—while collaborating and driving partnerships with middle office and technology stakeholders to translate operational complexity into scalable, maintainable data solutions.

Contribute to the execution of all phases of the data requirements process, including planning, data elicitation and extraction, analysis, documentation, and support. Establish best practices for data modeling and ontology across the team, and contribute to building trade and transaction data capabilities. Partner with stakeholders to understand data sources, business event needs, requirements, data lineage, technical specifications, and key success metrics, ensuring alignment with project objectives.

Define comprehensive functional and non-functional requirements for technology, architecture, tooling, and data products supporting the modernization program. Work with architecture teams to provide requirements that ensure data solutions are real-time and asset-agnostic and support current and future product expansion.



Validate and enhance the exception schema and data model for the Common Exception Manager platform, enabling unified detection and resolution across all asset classes. building data validation rules that feed the UI; conducting end-to-end testing across trade workflows; Analyze and document trade lifecycle requirements and establish the data models that support real-time exception and transaction processing.

Contribute to data taxonomy and ontology frameworks that create common language required for the exception layer. Define system and field level data sourcing requirements including system/database table, columns, etc. creating detailed field-level mapping documentation and lineage. Create and maintain physical data dictionaries and process documentation.

Conduct data profiling to understand data quality issues, patterns, and anomalies across source systems. Define and prioritize data quality rules aligned with business requirements, translate rules into executable validation logic, implement into UIs, and lead testing efforts to ensure rules function correctly under production conditions. Using the latest technologies available, define and implement strategic mechanisms for analyzing data quality and identifying data anomalies, while improving how we publish data trends and dashboards.

Partner with data stewards and custodians/technology-owners,



to diagnose and remediate data gaps across data flows/lineage. Conduct advanced data analysis, identify trends, and provide actionable insights to drive evidence-based decision-making. Identify opportunities to optimize data processes, automate workflows, and improve problem-solving methodologies to better support operational and strategic objectives. 10+ years of experience as a Data SME with strong Transaction Data and Trade Lifecycle expertise ~ Understanding of data architecture ~ Bachelor’s Degree ~ Python knowledge and ability to communicate technical requirements ~ Robust SQL and query design skills ~ Trade/transaction lifecycle and process improvement experience ~ Experience establishing a centralized exception data layer, extensive experience with logical / physical relational data modeling, data profiling, pattern recognition, advanced data analysis, trade and transaction data expertise, data taxonomy and ontology R Programming Master’s Degree We can help!

We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity. We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.

In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job.

📌 Data Expert (Trade & Transaction Data Transformation) (Bedford)
🏢 Raise
📍 Bedford