.NET Software Engineer
Scotiabank
Toronto, ON
Requisition ID: 64624

Join the Global Community of Scotiabankers to help customers become better off.

Brief Description of Department:
The Enterprise Compliance and Regulatory Systems team is accountable for developing and supporting a number of compliance and risk management related tools and reporting systems within the Bank. The team is seeking a Software Engineer to develop and maintain a number of web applications built on asp.net mvc / asp.net core / Angular as well as SharePoint including the integration of a number of systems within the Bank. The incumbent will be joining a team of solution developers and architects that focus on systems utilized in compliance and risk management.

Key Accountabilities:
Reporting to the Senior Manager – Development of Enterprise Compliance and Regulatory Systems, the incumbent will be responsible for the following:

Design and development and support of high quality web applications built on ASP.NET MVC / C# with an MS SQL Server backend. Additional stacks include ASP.NET Core as well as Angular and SharePoint
Design and development of reports including KPIs for the Business using tools like MS SQL Server Reporting Services / MS PowerBI Reporting Services, Excel, PowerPivot.
Design and development of SQL queries / Stored Procedures / ETL packages using T-SQL and SSIS (SQL Server Integration Services) to extract data from source systems to integrate with data warehouse
Collecting business requirements / user stories from clients
Complete testing to ensure high quality product for clients
Developing SQL views to enable data consumers to read data from data warehouse
Assisting the Solution Architect to integrate systems via REST API, database views, SharePoint lists, sFTP etc
Responsible for documenting databases, data process flows and maintain data dictionaries
Troubleshoot and resolve database and applications defects on servers in a timely manner. Consult with internal and external groups as required
Assist in system upgrades / server upgrades as required
Opportunities for developing and supporting several web-based applications used in an array of functions.
Train and assist users at all levels

Skills Required / Functional Competencies:
At least 3 years of experience on ASP.NET MVC and ASP.NET Core leveraging Bootstrap / FontAwesome / css and modern web application and javascript libraries utilizing MS Visual Studio / Team Foundation Server
At least 3 years of expertise in MS Entity Framework for data persistence
At least 3 years of experience with IIS / Tomcat
Experience working with UI libraries DevCraft / Telerik / Kendo UI
Experience writing Java endpoint REST API services using STS Sprint Tool Suite is a plus
Experience with Microsoft BI stack SQL Server, T-SQL, developing ETL packages in SSIS for integration services, SSRS for reporting services, MS SQL Enterprise Manager, SQL Profiler required
Experience in developing BI reports and completing ad hoc queries and data analysis required
Knowledge and experience with modern javascript frameworks with Angular/React a plus
Experience working with box.com REST APIs a plus
Able to work independently and directly with the product owner to collect user stories / requirements as well as to plan and execute sprints while adhering to architectural standards is critical
Knowledge and experience with JIRA / SharePoint / SP Online is needed
Experience with SDLC methodologies required eg. Agile / Waterfall
Experience with data visualization tools like Tableau or PowerBI is a plus
Experience with development predictive Machine Learning models / Azure Machine Learning / R / Python a plus
Experience with databases, data modeling design, analytics / BI projects a plus
Familiar with data warehouse, ETL, SSIS, SSAS/cubes a plus
Attention to detail is a must and feedback from clients on dashboards and reports must be completed rapidly
Very strong and clear communication and interpersonal skills required
Experience with web development (in ASP.NET or Angular/CSS/HTML 5) a plus
Experience developing code to consuming REST API services a plus
Experience integrating systems with COTS Commercial Off The Shelf software packages a plus
Experience with DevOps, MS Azure Cloud services, Google Cloud Platform etc a plus

Technical Environment:
Platform: Microsoft.NET, IIS, SharePoint, Azure / Office 365 / SharePoint Online
Languages: C#, ASP.NET, T-SQL, Angular / Javascript
Development Environment: Visual Studio
Database: MS SQL Server 2017 / MS SQL Enterprise Manager
Source Control: MS Team Foundation Server / Git
Reporting: MS SQL Server Reporting Services
Data Visualizations: Tableau / MS PowerBI / Excel
Location(s): Canada : Ontario : Toronto

As Canada's International Bank, we are a diverse and global team. We speak more than 100 languages with backgrounds from more than 120 countries. 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.