RQ08442 - Software Developer - Senior
Client: Ministry of Health
Period: 12 months
Start Date: 2025-04-01
End Date: 2026-03-31
Working Hrs.: 7.25 Hrs. / day
Location: 5700 Yonge Street, 9th Floor
Hybrid - Candidate must be able to work 3 days onsite and 2 days remote
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.
Assignment Type: This position is currently listed as "Hybrid " as consultants will 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.
Must Have:

• 10+ years of experience in database and ETL development with Microsoft SQL Server including Microsoft SQL Server Reporting Services.
• Experience in SOAP and REST web services for processing real-time data stream.
• Demonstrated experience with MS SQL Server performance tuning (Profiler, Tracing, Execution Plan Analysis), data and application integration (ETL, SSIS, OS scripting) and data migration.

Description (Total 100)
Design and Development Experience (35%)
10+ years of experience in database and ETL development with Microsoft SQL Server including Microsoft SQL Server Reporting Services.
Demonstrated experience with database architecture, data modeling, logical and physical database design (OLTP, OLAP, Data Warehousing, ERwin, Visio, UML) and database capacity planning.
Demonstrated experience with MS SQL Server performance tuning (Profiler, Tracing, Execution Plan Analysis), data and application integration (ETL, SSIS, OS scripting) and data migration
Demonstrated ability to translate complex business requirements into technical solutions
Experience with and knowledge of UI Design Principles
Experience in SOAP and REST web services for processing real-time data streams
Demonstrated experience in responding to and troubleshooting issues related to data quality and performance and resolve them in a timely manner.
Experience working with team-collaboration tools (Confluence and Jira)
Proven experience developing ETL processes specifically in the Azure cloud environment.
Ability to optimize ETL processes for performance and scalability.
Strong skills in troubleshooting and debugging ETL processes to identify and resolve issues efficiently.
Technical Skills (35%)
10+ years of demonstrated experience in development of enterprise-level information technology solutions by analyzing, coding, configuring, testing, and implementing new and by modifying/enhancing existing applications utilizing Microsoft SQL Server.
Demonstrated experience in all aspects of the software development cycle (SDLC, Agile)
Experience with designing and developing solutions for a 9-1-1 Public Safety environment
Demonstrated experience in DELIVERING and MEETING project deliverable timelines.
Deep understanding of Azure data services such as Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure SQL Data Warehouse, Azure Data Lake Storage, etc.
Proficiency in ETL tools and frameworks for data integration and transformation, such as Azure Data Factory, Apache Spark (Azure Databricks), Apache NiFi, Talend, or Informatica.
Strong programming skills in languages commonly used for ETL processes, such as Python, Scala, or C#.
Expertise in SQL for data querying and manipulation.
Understanding of data modeling concepts and experience with database design.
Familiarity with data integration patterns and best practices for handling large volumes of data in a cloud environment.
Ability to implement data quality checks and validation processes to ensure the accuracy and completeness of the data.
Proficient in version control systems like Git for managing and tracking changes to the ETL code.
Experience in setting up monitoring and logging for ETL processes to track performance, identify issues, and ensure data integrity.
Understanding of data security principles and experience implementing security measures in ETL processes.
Knowledge of compliance requirements relevant to the industry.
Skill in automating ETL workflows and orchestrating data pipelines using tools like Azure Logic Apps or Apache Airflow.
Communications and Analytical Skills (25%)
Strong verbal and written communication skills that enable to effectively communicate ideas and concepts. Strong Interpersonal and negotiation skills.
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 deadlines
Demonstrated experience in creating of conceptual, logical, and physical data documentation for knowledge retention and transfer.
Experience in working on multi-year projects
Public Sector Experience (5%)
Experience in working on multiple projects at the same time
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 (e.g. UPM, architecture gating)