Data Modeller

Primary Skills

Capital Market

Data Modeling

JD

RBC Capital Markets is looking for an experienced Business

Analyst Data Modeler to join our Data and Architecture Services team within the Capital

Markets Division. The successful candidate will be responsible for designing and

implementing data models that effectively capture trade data across a diverse range of

financial products. This role requires a blend of technical expertise in data modeling,

deep knowledge of capital markets, and a strong understanding of trade data

Responsibility

Design and develop sophisticated data models for trade data related to various

financial instruments, ensuring alignment with business needs and regulatory

Requirements

Collaborate with business analysts, data engineers, and IT teams to gather

requirements and translate business needs into technical specifications.

Create and maintain logical and physical data models, ensuring optimal

performance and compliance with internal and external standards.

Ensure data models are flexible and scalable to support the introduction of new

products and adapt to changes in market practices.

Bachelor or Masters degree in Computer Science, Information Systems,

Finance, or a related field.

Minimum of 5 years of experience in data modeling, with a strong preference for

candidates with capital markets experience.

Expert knowledge of financial products, trade lifecycle, and market data.

Demonstrated experience in modeling trade data using industry-standard

protocols and schemas such as FpML (Financial Products Markup Language),

ISDA CDM (International Swaps and Derivatives Association Common Domain

Model), FIX (Financial Information eXchange), SWIFT, or ISO20022.

Proficiency in data modeling tools (e.g., ERwin, PowerDesigner, IBM Data

Architect) and familiarity with database technologies (SQL, NoSQL).

Experience with data warehousing, ETL processes, and big data platforms