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 recordkeeping, order processing, NAV-based settlement, distributions, trailers/commissions, dealer and intermediary structures, and fund series/class setups.
- 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.
- Experience designing data pipelines and integration patterns (ETL/ELT, file-based feeds, APIs).
- Good understanding of data governance, data quality, metadata management and lineage.
- Strong communication skills; able to explain complex data topics to operations staff, technologists and senior leaders.
- 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.
- Knowledge of Canadian fund regulation and industry bodies (NI 81-102, NI 31-103, CIRO, CSA, IFIC) and client-reporting rules (CRM2).
- Exposure to fund accounting, custody and investment book of record (IBOR) data, and how they reconcile with TA records.
- 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).
- Agile delivery experience (Jira, Confluence).
What's in it for you?
- Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
- Accessibility and Workplace Accommodations - 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. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
- Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
- Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
- Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.
- Community Engagement - We offer opportunities for community engagement & belonging with our various programs such as hackathons.
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.