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.