Assignment : RQ08511 - Software Developer - Senior
Job Title : Senior Azure Data Engineer
Requisition (SS) : RQ08511
Start Date : 2025-04-01
End Date : 2026-04-05
Client : Health Services Cluster
Office Location : 5700 Yonge Street, Toronto
Organization : Health Services Cluster
Ministry : Ministry of Health
Business Days : 500.00
Note : Hybrid - Candidate must work 3 days onsite and 2 days remote
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
Description
Review and understand code and architecture of the existing code, and make updates as required to ensure the code is modular and can support scalability requirementsCode enhancements to existing features and new features as per approved requirements and design directionProvide realistic work estimates to support project planning; capture business requirements and update business rules based on the requirementsUse structured methodologies, design best practices, implement code that is of quality, and clearly documented. The application should function as required, without any defects. The application must operate with the Operating System (OS) and other peripherals as identifiedCreate custom reports as required, applying Microsoft TechnologiesConduct testing, integration, and deployment of the developed changes across the environmentReview, analyze and recommend solutions to any defects discovered in productionFully document all developed code, and transition in a steady state to a full-time resource.NOTE
Extension / Amendment Attestation : Extension(s) only allowed using unused days / funds left on contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW. HSC may exercise its option(s) to extend the SOW beyond April 5, 2026, for up to one additional extension term of one year. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW.The resource needed till March 31, 2027, will include an option to extend, at the same rate, till March 31, 2027 if Tender_12075 Managed Service Provider for Contingent IT Resources is also extended for a further one year, else an RFS under the Successor VOR will be issued for the services required April 5, 2026 to March 31, 2027.Assignment Type : This position is currently listed as "Hybrid" as consultants may be required to work partly in the physical workplace and partly remotely. The details of this arrangement will be at the Hiring Manager's discretion.Experience and Skill Set Requirements
Design and Development Experience - 35%
10+ years of experience with developing code in SQL and Azure SQL, T-SQL, Azure Streaming Analytics SQLIn-depth knowledge of Azure PaaS data services such as Azure SQL Database, Data Lake Store (Gen 2), Data FactoryIn-depth knowledge of on premise SQL ServerIn-depth knowledge of Azure PaaS data streaming services such as Azure Event Hub, Streaming AnalyticsFamiliar with SSAS PartitioningDemonstrated experience with power query / power pivot, and being able to combine datasets from different sourcesWriting Python and SQL script for custom Computer Aided Dispatch (CAD) installationsDemonstrated experience with Datafactory, On-Premise data gatewayFamiliar with PowerBI best practicesExperience with and knowledge of UI Design PrinciplesExperience in SOAP and REST web services for processing real-time data streamsDemonstrated experience in enabling role-based security in the reports by restricting access to information (record-based access) and reportsDemonstrated experience with deployment of Report into Azure infrastructure.Demonstrated ability to translate complex business requirements into technical solutionsAnalytical mind with a problem-solving aptitudeTechnical Skills - 35%
10+ years of technical data warehousing experience with a focus in the design and development of Business IntelligenceExperience with Azure Analysis Services / SSAS (tabular / multidimensional), SQL Server Reporting Services (SSRS) and Power BIEnd 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 sourcesDemonstrated experience in design and development of visualizations for various reports / dashboards including near real-time to be shared with both B2B and B2CDemonstrated experience in architecting, design, and building of dynamic, real-time analytics pipelines and dashboards using visualization tools such as PowerBIDemonstrated experience in building and deploying Mobile dashboardsCommunication Skills - 20%
Strong verbal and written communication skills that enable to effectively communicate ideas and concepts. Strong Interpersonal and negotiation skills.Writing Business Requirements Document, Data Sharing Agreements,Strong consulting skills to engage with all stakeholders, lead meetings with internal and external clients to gather and document business requirements.Ability to work with minimal supervision in an agile environment, be an effective communicator with other team members and the business owners.A demonstrated team player with a proven track record for meeting deadlinesDemonstrated experience in creating of conceptual, logical, and physical data documentation for knowledge retention and transfer.Industry Experience - 10%
Experience in working on multi-year projectsExperience with building enterprise level reporting solutions that protect high-sensitive informationDemonstrated knowledge and experience with Public Sector governance methodologies (e.g. UPM, architecture gating)