Job Description

Position: Software Developer - Senior
Location: Toronto, ON (Hybrid)
Duration: 250 Days Contract + Possible Extension
:
Design and Development Experience

• 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 Data factory, On-Premises 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

• 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

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

Skills Required