Data Business Analyst at Bank of Nova Scotia in Toronto, ON
- Company: Bank of Nova Scotia
- Location: Toronto, ON, Canada
- Job type: full time
- Workplace: onsite
- Posted: 2026-11-20
All open roles at Bank of Nova Scotia
Job description
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 Analyze TA data across the full unitholder lifecycle: account setup, KYC/AML, purchases, redemptions, switches, transfers, systematic plans (PAC/SWP), distributions and reinvestments, fees, trailers and commissions. Profile and reconcile data from TA platforms (e.g., IFDS/SS&C, FundSERV order flows, dealer and intermediary files) against fund accounting, custody and general ledger records. Investigate breaks and data issues, find root causes and work with Operations and vendors to fix them for good. Turn business questions from Distribution, Sales, Finance and Compliance into clear data requirements, mappings and analytical outputs. Data Architecture & Modelling 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. Build source-to-target mappings, data lineage and transformation logic that engineers can implement and auditors can follow. Data Governance & Quality Own TA business definitions, metric dictionaries and critical data elements (e.g., AUM by dealer, net sales, gross sales, redemptions, unitholder counts). Design and monitor data quality rules, reconciliation controls and exception workflows. Help classify and protect sensitive investor data (PII), in line with privacy, records retention and information security standards. Work with Data Governance on metadata, data catalog entries, ownership and stewardship. Regulatory & Reporting Support 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 Act as the TA data subject-matter expert on modernization, migration and vendor-change projects. Write clear artifacts: requirements, data models, mapping specifications, test cases and runbooks. Support UAT, parallel runs and data validation during system changes and cloud migrations. Mentor analysts and engineers on TA business processes and data concepts. Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have: 5+ years in data analysis, data architecture or data engineering in asset management, wealth management or fund services. 2+ years working directly with Transfer Agency data and processes (mutual funds, ETFs, pooled funds or alternatives). Solid knowledge of the TA business: unitholder re
Data Business Analyst on JobPost.