Pay
$95K–$145K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 2,327 postings in the last year. Stated ranges, not salaries paid.
Toronto, ON, CA, M5H 1A1
Actively hiring, first seen by us 1 day agoYou will design, model and govern the data behind unitholder recordkeeping, fund transactions, distributions and dealer relationships.
You will write SQL and analyze source data, and you will also define target-state data models, integration patterns and data quality controls for the TA domain.
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. We are looking for a Data Analyst / Data Architect with strong Transfer Agency (TA) experience. You will design, model and govern the data behind unitholder recordkeeping, fund transactions, distributions and dealer relationships. You will work between Operations, Distribution, Finance, Compliance and Technology to turn TA data from outsourced and in-house platforms into trusted, well-documented data products. These products support reporting, analytics, regulatory obligations and the move to the cloud. The role is both hands-on and architectural. You will write SQL and analyze source data, and you will also define target-state data models, integration patterns and data quality controls for the TA domain.
We are looking for a Data Analyst / Data Architect with strong Transfer Agency (TA) experience. You will design, model and govern the data behind unitholder recordkeeping, fund transactions, distributions and dealer relationships. You will work between Operations, Distribution, Finance, Compliance and Technology to turn TA data from outsourced and in-house platforms into trusted, well-documented data products. These products support reporting, analytics, regulatory obligations and the move to the cloud. The role is both hands-on and architectural. You will write SQL and analyze source data, and you will also define target-state data models, integration patterns and data quality controls for the TA domain. Is this role right for you? In this role you will:
Actively hiringFirst seen by us 1 day ago, still listed, and not a repost of an earlier posting.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
$95K–$145K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 2,327 postings in the last year. Stated ranges, not salaries paid.
Day 1
Early. Similar jobs usually come down between day 5 and day 43.
From 16,008 similar postings that came down. Coming down is not always a hire.
35 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Hiring recordAdd your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- Experience with Azure Data Factory, Databricks, Synapse, Snowflake or GCP equivalents. - Python or PySpark for data analysis, automation and validation. - Knowledge of Canadian fund regulation and industry bodies (NI 81-102, NI 31-103, CIRO, CSA, IFIC) and client-reporting rules (CRM2).
We are looking for a Data Analyst / Data Architect with strong Transfer Agency (TA) experience. You will design, model and govern the data behind unitholder recordkeeping, fund transactions, distributions and dealer relationships. You will work between Operations, Distribution, Finance, Compliance and Technology to turn TA data from outsourced and in-house platforms into trusted, well-documented data products. These products support reporting, analytics, regulatory obligations and the move to the cloud. The role is both hands-on and architectural. You will write SQL and analyze source data, and you will also define target-state data models, integration patterns and data quality controls for the TA domain. Is this role right for you? In this role you will:
- Hands-on experience with at least one major TA platform or service provider (e.g., IFDS, SS&C DST, CIBC Mellon, RBC Investor Services, or similar) and with FundSERV or similar order-routing networks. - Advanced SQL; experience with large relational and cloud data platforms. - Proven data modelling skills (dimensional and normalized), with tools such as ER/Studio, Erwin or equivalent.
- Design and maintain conceptual, logical and physical data models for the TA domain, including investor/account, dealer/advisor, fund/series/class, transaction, holdings/positions, distributions, and fee/trailer entities. - Define the target-state architecture for TA data on the enterprise cloud platform (e.g., Azure, Databricks, Snowflake), including ingestion, curated layers (bronze/silver/gold or equivalent) and consumption patterns. - Set integration standards for batch file feeds, APIs and event-driven flows between the TA, fund accounting, CRM (e.g., Salesforce), data warehouse and reporting tools.
- University degree in Computer Science, Information Systems, Finance, Engineering or a related field. - Experience with Azure Data Factory, Databricks, Synapse, Snowflake or GCP equivalents. - Python or PySpark for data analysis, automation and validation.
- Familiarity with BI tools (Power BI, Tableau) and semantic-layer design. - Industry certifications such as CIFC, IFIC Mutual Funds Course, CDMP, or cloud data certifications (Azure Data Engineer, Databricks). - Agile delivery experience (Jira, Confluence).
- Supply accurate data for regulatory and statutory obligations, such as client reporting (CRM2 cost and performance reports), tax reporting (T3, T5, NR4, RL slips), FATCA/CRS, AML/FINTRAC, unclaimed property and fund-level filings. - Support sales and distribution analytics, dealer compensation, flow reporting and executive dashboards (e.g., Power BI, Tableau). Delivery & Stakeholder Engagement
- Experience with TA platform conversions, vendor migrations or fund mergers. - Familiarity with BI tools (Power BI, Tableau) and semantic-layer design. - Industry certifications such as CIFC, IFIC Mutual Funds Course, CDMP, or cloud data certifications (Azure Data Engineer, Databricks).
Complete your application on jobs.scotiabank.com. The employer’s form will show what is required.
Already applied? Track this application
Requisition ID: 279960
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
We are looking for a Data Analyst / Data Architect with strong Transfer Agency (TA) experience. You will design, model and govern the data behind unitholder recordkeeping, fund transactions, distributions and dealer relationships. You will work between Operations, Distribution, Finance, Compliance and Technology to turn TA data from outsourced and in-house platforms into trusted, well-documented data products. These products support reporting, analytics, regulatory obligations and the move to the cloud.
The role is both hands-on and architectural. You will write SQL and analyze source data, and you will also define target-state data models, integration patterns and data quality controls for the TA domain.
Is this role right for you? In this role you will:
Transfer Agency Data Analysis
Data Architecture & Modelling
Data Governance & Quality
Regulatory & Reporting Support
Delivery & Stakeholder Engagement
Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have:
What's in it for you?
Location(s): Canada : Ontario : Toronto
Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.
At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.
New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Analyst, by the work the posting describes.
Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.
Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.
Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
Toronto, ON, CA, M5H 1A1
Working pattern and location restrictions need checking in the full posting.
No clear work-authorization passage found. Eligibility is unconfirmed.