Job Description :
Title: SQL Server Database Developer Location: Toronto, ON Full Time Job Description: 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 Developer - Data Engineer and Visualization Expert ingest data from source systems to SQL Server and to develop dashboards and reports. 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: [Critical] Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with data warehouse [Critical] Design and development of high quality dashboards / reports using tools like Power BI, SSRS, Excel/PowerPivot and Tableau. Develop custom reports, analytics and KPI's for the Business 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 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 in a timely manner. Consult with internal and external groups as required Train and assist users at all levels Skills Required / Functional Competencies: [Critical] Experience with Microsoft BI stack SQL Server, T-SQL, SSRS, MS SQL Enterprise Manager [Critical] Experience in developing BI reports and completing ad hoc queries and data analysis required [Critical] Expertise with data visualization / BI tools eg. Power BI, SSRS required. [Critical] Clear communication and interpersonal skills required Experience with EDL / Hadoop / Hive / Jupyter Notebooks / Tableau a plus Attention to detail and feedback from clients on dashboards and reports must be completed rapidly Experience with SDLC methodologies required eg. Agile / Waterfall Experience with databases, data modeling design Experience with data warehouse, ETL, SSIS, SSAS/cubes a plus Experience working with Content Management Systems like MS SharePoint or a plus Knowledge on Banking / Risk related systems is 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 implementing DevOps a plus Experience with MS Azure Cloud services, Google Cloud Platform etc a plus Experience with web development (in ASP.NET or Angular/CSS/HTML 5) a plus Technical Environment: Database: SQL Server / MS SQL Enterprise Manager Platform: Microsoft.NET, IIS, SharePoint Development Environment: Visual Studio / Jupyter Notebook Languages: T-SQL, C#, .NET, Python Source Control: MS Team Foundation Server / Git / Bitbucket Reporting: MS SQL Server Reporting Services Data Visualizations: MS PowerBI / Tableau / Excel