Data Modeler

Job Description

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 Show more Show less