Data Modeler – Financial Services/Wealth Management (PL754)

Paralucent Inc; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading financial services institution is seeking a Data Modeler with 5-7 years of experience in data modeling and analysis. This hybrid role, based in Toronto, involves designing data models to optimize financial data for reporting and analytics. The ideal candidate will collaborate with Wealth Management teams and require strong SQL skills, along with expertise in ER modeling and dimensional modeling. Strong analytical and communication skills are essential for bridging technical and business teams.

Qualifications

• 5–7 years of hands-on experience in data modeling and analysis.
• Strong expertise in ER modeling, dimensional modeling, and data warehousing concepts.
• Proficiency in SQL and working with enterprise databases (Oracle, SQL Server, DB2 or equivalent).
• Experience with Wealth Management or Financial Services datasets (preferred).
• Familiarity with data governance, metadata management, and Master Data Management (MDM) concepts.
• Strong analytical, problem-solving, and stakeholder management skills.
• Excellent communication skills with the ability to bridge technical and business teams.

Responsibilities

• Design conceptual, logical, and physical data models aligned with Wealth Management requirements.
• Collaborate with business analysts, data engineers, and stakeholders to define data standards and best practices.
• Develop and maintain metadata repositories, business glossaries, and data dictionaries.
• Ensure data quality, consistency, governance, and compliance across platforms and systems.
• Translate Wealth Management and regulatory requirements into scalable technical data structures.
• Partner with BI and analytics teams to deliver models that support advanced financial reporting and insights.
• Conduct impact analysis for changes in source systems and downstream applications.
• Provide documentation, data lineage, and model updates to support business and audit needs.

Skills

Data modeling and analysis

ER modeling

Dimensional modeling

SQL

Stakeholder management

Problem-solving

Tools

Oracle

SQL Server

DB2

Job description

Location: Greater Toronto Area (hybrid 2 days per week); Duration: 6 months.

Our client, a leading financial services institution, is seeking a Data Modeler – Financial Services/Wealth Management with 5–7 years of experience in designing and implementing enterprise data models. The successful candidate will work closely with Wealth Management teams to structure, model, and optimize financial data for reporting, analytics, and compliance. This role requires a strong technical foundation in data modeling along with the ability to translate complex business needs into efficient, scalable data solutions.

Key Responsibilities

• Design conceptual, logical, and physical data models aligned with Wealth Management requirements.

• Collaborate with business analysts, data engineers, and stakeholders to define data standards and best practices.

• Develop and maintain metadata repositories, business glossaries, and data dictionaries.

• Ensure data quality, consistency, governance, and compliance across platforms and systems.

• Translate Wealth Management and regulatory requirements into scalable technical data structures.

• Partner with BI and analytics teams to deliver models that support advanced financial reporting and insights.

• Conduct impact analysis for changes in source systems and downstream applications.

• Provide documentation, data lineage, and model updates to support business and audit needs.

Qualifications

• 5–7 years of hands-on experience in data modeling and analysis.

• Strong expertise in ER modeling, dimensional modeling, and data warehousing concepts.

• Proficiency in SQL and working with enterprise databases (Oracle, SQL Server, DB2, or equivalent).

• Experience with Wealth Management or Financial Services datasets (preferred).

• Familiarity with data governance, metadata management, and Master Data Management (MDM) concepts.

• Strong analytical, problem-solving, and stakeholder management skills.

• Excellent communication skills with the ability to bridge technical and business teams.

Nice-to-Have Skills

• Exposure to cloud data platforms (Azure, AWS, GCP).

• Knowledge of regulatory reporting requirements in banking/wealth management.

• Experience working in Agile / PI planning environments.