Job Description :
Programmer / Developer - Senior Toronto, ON Contract Must-haves: 10+ years of experience with developing code in SQL and Azure SQL, T-SQL, Azure Streaming Analytics SQL In-depth knowledge of Azure PaaS data services such as Azure SQL Database, Data Lake Store (Gen 2), Data Factory Demonstrated experience in design and development of ETL (Extract, transform, load) processes, and validating data sources Demonstrated experience in architecting, design, and building of dynamic, real-time analytics pipelines and dashboards using visualization tools such as PowerBI Nice to have: Public Sector experience Experience and Skill Set Requirements Design and Development Experience (40%) 10+ years of experience with developing code in SQL and Azure SQL, T-SQL, Azure Streaming Analytics SQL In-depth knowledge of Azure PaaS data services such as Azure SQL Database, Data Lake Store (Gen 2), Data Factory In-depth knowledge of on premise SQL Server In-depth knowledge of Azure PaaS data streaming services such as Azure Event Hub, Streaming Analytics Familiar with SSAS Partitioning Demonstrated experience with power query/power pivot, and being able to combine datasets from different sources Writing Python and SQL script for custom Computer Aided Dispatch (CAD) installations Demonstrated experience with Datafactory, On-Premise data gateway Familiar with PowerBI best practices Experience with and knowledge of UI Design Principles Experience in SOAP and REST web services for processing real-time data streams Demonstrated experience in enabling role-based security in the reports by restricting access to information (record-based access) and reports Demonstrated experience with deployment of Report into Azure infrastructure. Demonstrated ability to translate complex business requirements into technical solutions Analytical mind with a problem-solving aptitude Technical Skills (30%) 10+ years of technical data warehousing experience with a focus in the design and development of Business Intelligence Experience with Azure Analysis Services / SSAS (tabular/multidimensional), SQL Server Reporting Services (SSRS) and Power BI End to end management of the Software Development Life Cycle (SDLC) for Computer Aided Dispatch (CAD) Developing process models and ongoing analysis of program effectiveness for Computer Aided Dispatch (CAD), Demonstrated experience in design and data modeling of data warehouse (e.g. dimensional modeling), data cubes, tabular models to support reporting, both ad-hoc and "canned" reports. Demonstrated experience in design and development of data models for OLTP (On-line Transaction Processing) and OLAP (On-line Analytical Processing) environments based on industry best practices. Demonstrated experience in design and development of ETL (Extract, transform, load) processes, and validating data sources Demonstrated experience in design and development of visualizations for various reports/dashboards including near real-time to be shared with both B2B and B2C Demonstrated experience in architecting, design, and building of dynamic, real-time analytics pipelines and dashboards using visualization tools such as PowerBI Demonstrated experience in building and deploying Mobile dashboards
             

Similar Jobs you may be interested in ..