Sr. Software Developer

Position : Sr. Software Developer

Location : Toronto, ON (Hybrid)

Duration : Months Contract (Possibility For Extension)

Job Description :

Design and Development Experience

• 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 ), 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 :

• 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 ( 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 BB and BC
• 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

Industry Experience :

• Experience in working on multi-year projects
• Experience with building enterprise level reporting solutions that protect high-sensitive information
• Demonstrated knowledge and experience with Public Sector governance methodologies ( UPM, architecture gating)

Must haves :

• 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 ), 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
30+ days ago