Transfer Agency Data Architect | Analytics & Cloud

Scotiabank

Toronto

On-site

CAD 110,000 - 170,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Diversity and inclusion initiatives
Workplace accessibility accommodations
Tuition assistance and online courses
Competitive rewards including bonus

Job summary

Scotiabank in Toronto, Canada is seeking a Data Analyst / Data Architect with strong Transfer Agency (TA) experience. You will design, model and govern TA data to support reporting, analytics and regulatory obligations, while moving to cloud platforms such as Azure or Snowflake.

You will write SQL, analyze source data and define target-state data models, integration patterns and data quality controls for the TA domain, collaborating across Operations, Distribution, Finance, Compliance and

Qualifications

  • 5+ years in data analysis, data architecture or data engineering in asset management or fund services.
  • 2+ years working directly with Transfer Agency data and processes.
  • Solid knowledge of unitholder recordkeeping, order processing, and fund setups.
  • Hands-on experience with TA platforms (IFDS, SS&C DST, CIBC Mellon, RBC Investor Services) and FundSERV.
  • Advanced SQL and experience with large relational and cloud data platforms.

Responsibilities

  • Analyze TA data across the full unitholder lifecycle: account setup, KYC/AML, purchases, redemptions, switches, transfers, distributions and reinvestments.
  • Profile and reconcile data from TA platforms against fund accounting, custody and general ledger records.
  • Investigate data issues, identify root causes and coordinate fixes with Operations and vendors.
  • Translate business questions into data requirements, mappings and outputs.
  • Design data models for TA domain including investor/account, dealer/advisor, fund/series/class, transactions.

Skills

Advanced SQL
Data modeling
ETL/ELT design
BI tools (Power BI, Tableau)
Data governance & data quality
Communication skills
Python or PySpark
Cloud data platforms (Azure, Databrick

Education

University degree in Computer Science, Information Systems, Finance, Engineering or related field

Tools

Azure Data Factory
Databricks
Synapse
Snowflake
ER/Studio
Erwin

Job description

Scotiabank in Toronto, Canada is seeking a Data Analyst / Data Architect with strong Transfer Agency (TA) experience. You will design, model and govern TA data to support reporting, analytics and regulatory obligations, while moving to cloud platforms such as Azure or Snowflake.

You will write SQL, analyze source data and define target-state data models, integration patterns and data quality controls for the TA domain, collaborating across Operations, Distribution, Finance, Compliance and

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Systems Analyst - Transfer Agency Ops
Business Systems Analyst - Transfer Agency Ops

Scotiabank • Toronto

On-site
CAD 90,000 - 120,000
DEI & Allyship
Accessibility accommodations
Tuition assistance
+3
Data Business Analyst
Data Business Analyst

Scotiabank • Toronto

On-site
CAD 110,000 - 170,000
Diversity and inclusion initiatives
Workplace accessibility accommodations
Tuition assistance and online courses
+1
Strategic Tech BA: Data, Automation & SDLC
Strategic Tech BA: Data, Automation & SDLC

Scotiabank • Toronto

On-site
CAD 85,000 - 110,000
ERGs
Accessible workplace
Tuition assistance
+3
AI & BI Engineer, Data Platform Lead — Toronto
AI & BI Engineer, Data Platform Lead — Toronto

The Toronto-Dominion Bank (Canada) • Toronto

On-site
CAD 105,000 - 129,000
Senior HR Data & Governance Lead
Senior HR Data & Governance Lead

The Toronto-Dominion Bank (Canada) • Toronto

On-site
CAD 82,000 - 115,000
Lead Data Engineer: Wealth Analytics on Google Cloud
Lead Data Engineer: Wealth Analytics on Google Cloud

Scotiabank • Toronto

On-site
CAD 120,000 - 160,000
Inclusive culture
Accessibility & accommodations
Upskilling opportunities
+3
Senior IT Data Specialist – AML & Fraud Risk Tech
Senior IT Data Specialist – AML & Fraud Risk Tech

TD Bank Group • Toronto

On-site
CAD 114,000 - 137,000
Treasury & Capital Markets BA — Migration & Data-Driven
Treasury & Capital Markets BA — Migration & Data-Driven

TechDoQuest • Toronto

On-site
CAD 80,000 - 100,000
Data Architect | 5-7 Years | Toronto, Ontario, Canada
Data Architect | 5-7 Years | Toronto, Ontario, Canada

Qwalton Private Limited • Toronto

On-site
CAD 120,000 - 180,000
Senior Data Analyst
Senior Data Analyst

Scotiabank • Toronto

On-site
CAD 100,000 - 140,000
Diversity & Inclusion
Accessibility
Tuition assistance
+3