Data Analyst IV

Compunnel, Inc.; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

An established industry player is on a mission to enhance its data capabilities and is looking for a Senior Data Analyst to drive strategic initiatives in Wealth Management. This role involves collaborating with cross-functional teams to deliver impactful, data-driven projects while ensuring alignment with the broader data strategy. You will leverage modern technologies and best practices to create robust data solutions that meet business expectations. If you're passionate about data and eager to contribute to a customer-centered digital transformation, this opportunity is perfect for you.

Qualifications

• 5-10 years of experience as a Data Analyst in Wealth Management.
• Strong SQL skills for data querying and transformation.
• Proven experience in data integration and warehousing.

Responsibilities

• Lead sessions to gather and validate data requirements.
• Manage UAT activities including test planning and execution.
• Contribute to building scalable data infrastructure.

Skills

Data Analysis

SQL

Data Integration

Data Warehousing

Master Data Management

GenAI

Adobe Journey Optimizer

Communication Skills

Education

Bachelor's Degree in Data Science or related field

Tools

Bloomberg Polar Lake

SimCorp Dimension

Findur

Apex

Eagle

Charles River

Sylvan

Calypso

Azure

AWS Connect

Job description

We are on a journey to become a customer-centered digital leader and are seeking a motivated Senior Data Analyst to help drive strategic initiatives. Reporting to the Lead Data Analyst in the GWAM Data Office/Engineering team, you will work cross-functionally to ensure delivery of high-impact, data-driven projects in Wealth Management. Your work will align with our broader data strategy, leveraging modern technologies and best practices.

Job Responsibilities:

1. Lead business sessions to gather, clarify, and validate data requirements
2. Create and maintain Business Requirement Documents (BRDs), Source-to-Target Mappings (STM), and metadata documentation
3. Ensure data solutions meet business expectations and align with strategic goals
4. Liaise across stakeholders to gain consensus and support data-related initiatives
5. Conduct in-depth data analysis, profiling, and validation activities
6. Manage UAT activities, including test planning, execution, and user sign-off
7. Provide support and guidance on data modeling, integration, and transformation
8. Contribute to building scalable, flexible data infrastructure and pipelines

Required Skills:

• 5–10 years of experience as a Data Analyst in Wealth Management (Retail, Retirement, Institutional, or General Accounts)
• 2–3 years of hands-on experience with GenAI
• Working knowledge of Adobe Journey Optimizer
• Proven experience in master data management, data integration, data warehousing, and analytics in capital markets or investment banking environments
• Strong SQL skills for data querying, profiling, validation, and transformation
• Proven experience delivering documentation artifacts in large, complex environments
• Strong communication skills, both written and verbal, with stakeholders at all levels
• Experience with trading platforms and book of record systems such as Bloomberg Polar Lake, SimCorp Dimension, Findur, Apex, Eagle, Charles River, Sylvan, Calypso
• Business analysis experience in building or managing data lakes or data warehouses
• Expertise in data modeling, ETL processes, and loading/validating datasets using SQL
• Ability to integrate new data sources into existing platforms (lake/warehouse)

Preferred Skills:

• Exposure to Azure cloud technologies
• Experience with AWS Connect
• Background in Agile teams and methodologies
• Experience using big data technologies and analytics frameworks

Certifications:

[Specify if required or preferred – e.g., Certified Data Analyst, Azure Data Engineer Associate]