Job Description :
Role: SQL Server Data Developer Location: Toronto, ON Full Time Skills Required / Functional Competencies: [Critical] Experience with Microsoft BI stack SQL Server, T-SQL, SSRS, MS SQL Enterprise Manager etc [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. Knowledge of configuring SharePoint Online for hosting data and reporting solutions Clear communication and interpersonal skills required Attention to detail and feedback from clients on dashboards and reports must be completed rapidly Experience developing code to consume REST API services and integrating systems with sftp a plus Experience in design and development of dimensional data model aligning to Kimball approach a plus Experience with MS Azure / SQL Server MI / Machine Learning services a plus Experience with SDLC methodologies required eg. Agile / Waterfall Experience with databases, dimensional data modeling design Experience with data warehouse, ETL, SSIS, SSAS/cubes a plus Experience integrating systems with COTS Commercial Off The Shelf software packages a plus Experience with implementing DevOps / CIAD a plus Experience with EDL / Hadoop / Hive / Jupyter Notebooks / Tableau a plus Experience with web development (in ASP.NET MVC / C a plus Knowledge on Banking / Risk related systems is a plus Technical Environment: Database: SQL Server / MS SQL Enterprise Manager Platform: Microsoft.NET, IIS, SharePoint Online 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

Similar Jobs you may be interested in ..