Business Analyst / Data Modeler - Trade Data

Compunnel, Inc.; Toronto; On-site; CAD 85,000 - 110,000; Full time

Job summary

A financial services firm in Toronto is seeking an experienced Business Analyst / Data Modeler specializing in capital markets. The role focuses on designing sophisticated data models for trade data, ensuring compliance and alignment with business needs. Candidates should have at least 5 years of data modeling experience and a strong understanding of financial products and regulations. This position offers an opportunity to significantly impact data governance and strategic initiatives in an evolving market.

Qualifications

• Minimum of 5 years of experience in data modeling, preferably in capital markets.
• Expert knowledge of financial products and trade lifecycle.
• Understanding of financial regulations impacting data management.
• Excellent analytical and problem-solving skills.
• Strong communication skills and ability to engage with stakeholders.

Responsibilities

• Design and develop data models for trade data related to financial instruments.
• Collaborate with teams to gather requirements and create specifications.
• Manage metadata repositories and promote data quality.
• Participate in data governance initiatives.
• Stay updated on industry trends and regulatory changes.

Skills

Data modeling

Capital markets expertise

Analytical skills

Problem-solving skills

Communication

Teamwork

Education

Bachelor’s or Master’s in Computer Science, Information Systems, Finance

Tools

ERwin

Power Designer

IBM Data Architect

SQL

NoSQL

Job description

Business Analyst / Data Modeler - Trade Data

03 / 27 / 2025

Contract

Active

Job Description : Job Summary

We are seeking a highly skilled Data Modeler with a strong background in capital markets to design and develop sophisticated data models for trade data related to various financial instruments. This role will ensure alignment with business needs and regulatory requirements, collaborating closely with various teams to create and maintain logical and physical data models. The successful candidate will also manage metadata repositories, support data governance initiatives, and advise on best practices for data storage, retrieval, and normalization.

Key Responsibilities

• Data Model Development : Design and develop sophisticated data models for trade data related to various financial instruments, ensuring alignment with business needs and regulatory requirements.
• Strategic Collaboration : Work closely with the Director of Data and Architecture Services, Trade Data, to understand strategic objectives and contribute to the overall data architecture strategy.
• Requirement Gathering : Collaborate with business analysts, data engineers, and IT teams to gather requirements and translate business needs into technical specifications.
• Model Maintenance : Create and maintain logical and physical data models, ensuring optimal performance and compliance with internal and external standards.
• Scalability & Flexibility : Ensure data models are flexible and scalable to support new products and adapt to changes in market practices.
• Metadata & Data Dictionaries : Manage metadata repositories and data dictionaries to promote data quality and consistency across the organization.
• Model Validation : Review data models with stakeholders, validate design decisions, and ensure data integrity.
• Data Storage & Retrieval : Advise on data normalization, storage solutions, and efficient data retrieval methods.
• Data Governance : Participate in data governance initiatives, supporting the development and enforcement of data policies and standards.
• Industry Awareness : Stay abreast of industry trends, tools, and regulatory changes that impact data modeling and capital markets.

Required Qualifications

Education : Bachelor’s or Master’s degree in Computer Science, Information Systems, Finance, or a related field.

Experience : Minimum of 5 years of experience in data modeling, with a strong preference for candidates with experience in capital markets.

Financial Products Knowledge : Expert knowledge of financial products, trade lifecycle, and market data.

Industry Protocols & Standards : Demonstrated experience in modeling trade data using industry-standard protocols and schemas such as FpML, ISDA CDM, FIX, SWIFT, or ISO20022.

Data Modeling Tools : Proficiency in data modeling tools (e.g., ERwin, Power Designer, IBM Data Architect) and familiarity with database technologies (SQL, NoSQL).

ETL & Data Warehousing : Experience with data warehousing, ETL processes, and big data platforms.

Analytical & Problem-Solving Skills : Excellent analytical, problem-solving, and organizational skills.

Communication : Strong communication skills, with the ability to interact with a variety of stakeholders.

Financial Regulations : Understanding of financial regulations (e.g., GDPR, MiFID II, Dodd-Frank) and their impact on data management.

Teamwork : Ability to work independently as well as collaboratively in a team environment.

Preferred Qualifications

Capital Markets Experience : Preference for candidates with capital markets experience and knowledge of financial products and trade data.

Certifications : Relevant professional certifications such as CFA or FRM are considered an asset.

J-18808-Ljbffr