Azure-SQL Database Developer

13
Dec

Azure-SQL Database Developer

  • Contract
  • Toronto
  • Posted 1 month ago

JO 2477: Azure/SQL Database Developer

Location: Toronto, Ontario

Contract Term: 1 year

Duration of Potential Extension: 12 months

Assignment Description

The primary focus would be to aid in the development and improvement of our internal Data Warehouse. Duties and responsibilities include, but may not be limited to, the following:

  • Administration of the Azure (cloud) platform to grant User access and monitor the performance of the overall environment
  • Maintenance of the Data Suite being used on Azure (SQL Server Databases, Azure Analysis Services & Azure Data Factory V2)
  • Creation of new Data Models and modification of existing Data Models in Azure Analysis Services (SSAS) as per reporting requirements
  • Creation of new Data Visualizations/Reports and modification of existing Visualizations in Power BI as per business requirements
  • Continuous improvement of performance and efficiency of the DW
  • Creation of simple web forms using Azure App Service
  • Continuous research on latest industry trends and releases within the data analytics realm
  • Documentation of all current processes and newly added processes and up keeping of Data Dictionary
  • Participating in the development of Test Plans, Test Cases and Test Scripts
  • Collaborating with internal stakeholders to set expectations and deliver solutions in a timely and effective manner

Qualifications

  • University degree in Computer Science, Engineering, Statistics or a Data Science equivalent discipline
  • Minimum of five professional years’ experience in a data and database management role
  • Vastly experienced with SQL development in a Microsoft SQL Server Data Warehouse environment
  • Experienced in developing Analysis Models/Cubes using Microsoft SQL Server SSAS packages
  • Prior working knowledge on cloud based environments (preferably with Microsoft Azure)
  • Well versed in data visualization tools such as Power BI
  • Capable of understanding and developing in C# and DAX
  • Understanding of OOD, experience of server side coding.
  • Experience with SNS API to retrieve data
  • Demonstrated ability to show initiative and self-direction, maintain currency of knowledge, identify and solve problems
  • Excellent interpersonal skills
  • Effective communication skills

Deliverables

  • Complete outstanding development on projects in progress (e.g., Leading to Reading)
  • Review and remedy outstanding issues on existing databases, including data synchronization/configuration for source data from the Integrated System, purchase requisition database, people counter data, Reserve-A-Computer data, and other databases that are applicable to customer interaction
  • Create a Phase 1 working sandbox for the customer interaction data captured to support consistent and accurate data reporting and analysis
  • Document the proposed approaches to assignments and work completed
  • Work with designated staff to transfer the knowledge

Job URL: https://01millennium.com/jobs/azuresql-database-developer/
 

Apply Online