Senior Analyst, Investment Data Solutions

Requisition ID: 192990
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

As a Senior Analyst,Investment Data Solutions, you will provide the expertise to streamline existing investment information into customized data views, by performing end-to-end system analysis, design, programming, support, documentation and implementation of in-house and third-party investment solutions used by our investment teams.

You will be working as a partner with Scotiabank technology teams, as well as the fixed income and broader 1832 Asset Management team, and will also be responsible for working within a specific framework of technology and investment management standards, policies and procedures, while collaborating with internal partners to ensure successful execution of mandates.

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

• Management of a front-office Investment Data and reporting solution.
• Maintain, support, and enhance existing applications using primarily MS SQL, Excel VBA, in addition to Windows Batch Scripting, PowerShell and C#.
• Daily administration of Investment Database to ensure that accurate, complete and timely reporting is available (eg 7:00 - 8:00 am) to portfolio managers, the investment teams and other stakeholders of the data and reporting application.
• Manage the process of loading and validating data (e.g. prices, positions, analytics, etc.)
required in the daily reporting provided to investment teams.
• Creation and maintenance of unique reporting solutions specific to end user specifications.
• Working closely with portfolio managers across the asset management teams to determine new reporting requirements and enhance existing reports.
• Facilitation of and participation in meetings regarding end user requirements and design throughout the development phase of the project.
• Maintain and enhance through automation, existing ETL process using MS SQL Server to ingest, transform, cleanse and load Investment Data (e.g. security prices, positions, portfolio analytics, etc.).
• Identify potential issues within ETL pipelines, notify end-users and propose solutions to enhance the existing processes.
• Migration of database sources to new master data sources and procedures to a cloud based infrastructure.
• Perform logical and physical data modeling to develop highly optimized data infrastructure and assure that data quality, security, and compliance requirements are met.
• Develop and maintain database stored procedures, functions and triggers in MS SQL Server.
• Ensure that all documentation meets application system and technical requirements.

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

The successful candidate must have the following:

• Bachelor's degree in Finance, Economics or Computer Science, or equivalent, with course work in finance or business administration;
• Minimum 2-5 years related work experience demonstrating progressive responsible work in applications programming and system analysis.
• Must have experience in the investment/mutual fund industry, with knowledge of fixed income products and a strong understanding of derivative products.
• Proficiency in MS SQL Server (T-SQL), Excel VBA and Windows batch scripts is required, working knowledge of Powershell, C# .NET, SQL Server Integration Services (SSIS) is beneficial.
• Knowledge of source control techniques and use of GIT or other source control systems
• Knowledgeable with SQL Server database management and SQL Server query development.
• Experience with Bloomberg, Eagle, Simcorp Dimension and/or Charles River is a strong asset.
• Experience with Cloud technology services and engineering (Azure or GCP preferred) is an asset.

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.