Senior Analyst, Data Management, Client Data Operations, GBM Onboarding (1 Year Contract GWO)

Scotiabank; Toronto; On-site; CAD 90,000 - 140,000; Full time

Benefits offered by this job

Bonus

Flexible vacation

Comprehensive benefits

Job summary

Scotiabank is seeking a Senior Analyst, Data Management in Client Data Operations for GBM Onboarding on a 1-year contract. You will lead data reconciliation, analysis, and regulatory data extracts while maintaining data governance across multiple systems.

You will collaborate with front-to-back teams, support portal changes, and drive process improvements leveraging SQL, Python, VBA, and BI tools. Strong analytical and communication skills are essential.

Qualifications

• Requires strong Excel, SQL, VBA and BI/reporting tool skills (Tableau/Power BI).
• Experience with Python, Power Query and Power Platform is a plus for automation and reporting improvement.
• Knowledge of financial markets and end-to-end front/middle/back-office workflows is expected.
• Strong analytical, problem-solving and communication skills are needed to work with diverse stakeholders.

Responsibilities

• Maintains and governs client and counterparty data across GBM Onboarding systems.
• Leads data extracts, population scoping, and control reporting for regulatory needs.
• Supports portal functionality design, testing, and validation of data fields and rules.
• Drives data quality improvements and data governance initiatives across the onboarding lifecycle.
• Collaborates with cross-functional teams to understand data needs and ensure data availability and accuracy.

Skills

Excel

SQL

VBA

Tableau

Power BI

Python

Power Platform

Education

Undergraduate degree in Mathematics, Statistics, Computer Science or Business

Tools

Tableau

Power BI

SQL

Python

Power Query

Job description

Select how often (in days) to receive an alert:

Select how often (in days) to receive an alert:

Please be advised that our Careers site will be unavailable from November 28 at 12am ET to November 29 12am ET for scheduled system maintenance.

Title: Senior Analyst, Data Management, Client Data Operations, GBM Onboarding (1 Year Contract GWO)

Requisition ID: 272328
Employee Referral Program – Potential Reward:$1,000.00
We are committed to investing in our employees and helping you continue your career at Scotiabank.

The Role

Supports the Client Data Operations team in GBM Onboarding with counterparty data reconciliation, analysis, reporting and control. This involves developing an understanding of the data and the functionalities of systems used by the Onboarding and Static Data teams and performing data analysis and reconciliation across various systems. The Senior Analyst will primarily lead the maintenance of and changes to the Regulatory Onboarding Portals, support regulatory data extracts, counterparty population scoping, control reporting and audit/regulatory requests, and contribute to GBMO’s fulfilment of regulatory obligations through participation in business transformation, data governance and process improvement initiatives.

Is this role right for you? In this role, you will:

• Establishes, maintains and governs client and counterparty data management requirements, reference data standards and related governance artifacts across Global Banking and Markets systems, including mandatory attributes, permitted values, source-of-truth rules, validation logic, field-level specifications, data dictionaries, source-to-target mappings, lineage references and systems-of-record documentation. Engages stakeholders across front office, KYC, compliance, onboarding, static data, trade source, credit, GBMO Metrics and business teams to understand data needs, document requirements, confirm data availability and suitability, and align data capture and structuring approaches.
• Performs complex client data analysis, reconciliation and data quality management by extracting, querying and analyzing large datasets; preparing and validating regulatory onboarding data extracts, counterparty population files and control reports; reconciling records across systems; identifying discrepancies, downstream impacts and error patterns; cleansing data; investigating regulatory data exceptions; completing root cause analysis; documenting assumptions and evidence; and implementing corrective actions to restore data integrity.
• Designs, enhances and supports client data models, structures, queries, reporting solutions and Regulatory Onboarding / Good-to-Trade portal functionality, including specifying new or amended fields, permitted values, record relationships, validation rules and portal change requirements; liaising with technology partners through implementation; performing user acceptance testing, regression testing and pre-release validation; reviewing and validating portal updates, field changes and control report items; confirming implemented changes are complete, accurate and appropriately evidenced; and monitoring data quality, operational performance and regulatory onboarding outcomes.
• Drives process improvement across recurring and ad hoc reporting, operational reconciliation, regulatory onboarding and COBRA data workflows by identifying manual, repetitive or control-sensitive processes; improving accuracy, timeliness, control, consistency and efficiency; supporting automation and optimization using approved tools such as SQL, Python, VBA, Power Query, Power Platform and business intelligence tools; and creating, maintaining and updating documentation, audit trails and job aids for portal processes, queries, scripts and reporting workflows.
• Supports cross-functional data, COBRA and project initiatives across Global Banking and Markets Operations by advising business units on data sourcing, data quality, KYC, AML and OTC onboarding lifecycle matters; assessing downstream impacts of onboarding, regulatory and static/reference data changes across source systems, reporting outputs and operational handoffs; supporting clarification of BAU ownership, controls and escalation paths; and assisting the Associate Director with complex analysis, problem solving, portal change execution and regulatory onboarding support as required.
• Champions a high-performance, inclusive and well-controlled environment by applying the Bank’s risk appetite and risk culture in day-to-day decisions; supporting effective and efficient operations in accordance with Scotiabank’s Values, Code of Conduct and Global Sales Principles; supporting audit, regulatory, compliance and control-related requests through evidence preparation, source-data reconciliation, SQL/database extracts and clear audit trails; and helping ensure business controls meet operational, compliance, AML/ATF/sanctions and conduct risk obligations.

Do you have the skills that will enable you to succeed in this role? – We’d love to work with you if you have:

• Requires strong knowledge of Excel, SQL, VBA and business intelligence/reporting tools such as Tableau, Power BI or similar visualization tools. Experience with Python, Power Query and Power Platform is considered an asset for automation, reconciliation and reporting process improvement.
• Requires knowledge of financial markets, financial instruments and end-to-end front, middle and back-office workflows, including the operational impact of current and anticipated regulatory changes.
• Requires strong analytical, problem-solving and critical-thinking skills to independently resolve complex, multi-dimensional and often unstructured business problems, and propose practical solutions.
• Requires strong interpersonal, communication, negotiation, time management and organizational skills to build consensus and obtain cooperation from business, technology, operations, compliance and management stakeholders.
• A recognized undergraduate degree is required, preferably in Mathematics, Statistics, Computer Science or Business.
• Requires strong technical writing skills to document requirements, procedures, data definitions, testing outcomes, audit evidence and reporting processes.

Working Conditions

• Work in a standard office-based environment or BCP location as required; non-standard hours are a common occurrence.
• May require limited travel globally.

What’s in it for you?

• Opportunity to engage with various GBM business groups on KYC/AML topics and client outreach activities
• Opportunity to enhance knowledge of GBM’s global product offering, business lines and functional processes, as well as gain exposure to the overall bank
• Opportunity to build strong strategic relationships across broad partner and stakeholder groups within GBM globally and across the bank
• Be a key member of a dynamic and engaged team with strong leadership and focused personal and career development support
• A rewarding career path with diverse opportunities for professional development
• An organization committed to making a difference in our communities – for you and our customers.
• A competitive rewards program including bonus, flexible vacation, personal and sick days, and comprehensive benefits that start on your first day.
• 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 employees 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 every 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.

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.

Note: All postings in me@Scotiabank will remain live for a minimum of 5 days.

Job Segment: Operations Manager, Database, Compliance, Business Process, Data Analyst, Operations, Technology, Legal, Management, Data