Data Expert (Trade & Transaction Data Transformation)

- Location: Toronto, ON/Halifax, NS – Hybrid (4 days onsite)
- Pay Rate:
- NS: $85.63/hr - $101.51/hr
- ON - $85.97/hr - $101.51/hr
- Contract Length: 6 Months

We at Raise are hiring a Data Expert (Trade & Transaction Data Transformation) for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising demand. We’re hiring right now; if you’re interested, apply below for your chance to join a excellent place to work

Responsibilities:

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. This includes defining exception taxonomies, root cause classifications, and replay functions; building data validation rules that feed the UI; conducting end-to-end testing across trade workflows; and establishing rollout strategies to minimize operational disruption.
- 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.

Must-Have Skills:

- 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
- Strong 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

Nice-to-Have Skills:

- R Programming
- Master’s Degree

Looking for meaningful work? We can help!

Raise is an established hiring firm with over 65 years of experience. 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.

We have a dedicated webpage for accommodations where you can learn more about what we offer and request accommodation: https://raise.jobs/accommodations/

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. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions), please contact us at +1 (phone hidden) or [email protected]

#FIN24

#LI-VM1

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