The Business Intelligence and Business Analytics (BIBA) unit develops and maintains all the data collection processes which feed data into our centralized data repository -- Business Intelligence & Data Analytics (BIDA). BIDA is the data source used by data analysts and scientists from the Digital & Analytics Strategy Division (DASD), who support the diverse needs for information coming from both the Ministry of Health and Ministry of Long-Term Care. Having accurate and up-to-date data is critical for enabling the evidence-based decision in both ministries.
Two Senior Software Developers (Python) are required to provide technical expertise in maintaining, and enhancing various automated data acquisition processes, such as:
- full OLIS data processing received quarterly from OH
- daily OLIS COVID data
- daily OLIS Flu & RSV data
- daily ALC (Alternative Level of Care) data
- daily ICU usage from CRITICALL
- daily ACES (Acute Care Enhanced Surveillance) data
- daily HSCM (Health System Capacity Monitoring) data
- monthly CHC (Community Health Care) data
Besides collecting data, the resources will also provide expertise in automating other processes (for data transformation, data sharing and complex reporting).
Responsibilities
•Design, develop, test, implement, and troubleshoot:
o data pipelines using Python and AWS services (Glue, StepFunctions, Lambda)
o complex data transformation procedures
o data models for the efficient storing of data in relational databases as well as in unstructured data repositories
o re-useable classes and modules as to enhance the maintainability and ability to deliver solutions quickly.
• Review existing code base and assist other more junior team members ensuring a consistent level of quality.
• Assess new business requirements and propose adequate technical solutions (using on-prem and on-cloud resources)
Assignment Type: This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.
Extension/Amendment Attestation:
Extensions are permitted only to the extent of unused contract days and/or remaining contract funds. No additional funds will be added beyond the maximum contract value, including any extension options set out in the original SOW.
General Development Experience (Python) | • Data engineering (pandas, pyspark) • Working with XLSX, CSV, JSON files, relational databases, cloud storage, structured and unstructured data • Data processing automation • Linux experience | 40 points |
AWS Cloud Experience | • Experience using AWS Services such as Glue, StepFunctions, Lambda, S3 • Experience with cloud data warehousing and analytics (AWS Redshift or equivalent) | 25 points |
Data Warehouse | • Data modeling (relational & dimensional), advanced SQL • Extract/Transform/Load data using tools such as Informatica IDMC • Data reporting/visualization | 25 points |
Software Development Life Cycle | • Full SDLC from requirements gathering, design, implementation, testing to deployment and production support • Familiar with project management (agile/scrum and waterfall) • Change and Incident management | 5 points |
General | • Communication, presentation and negotiation skills • Consulting, problem-solving and decision-making skills • Public sector experience | 5 points |
Applications for this position will be accepted until Friday, April 17, 2026 at 11:00 a.m..
If you meet the requirements for this role, please apply now.
Apply for This PositionClick "Apply." If no email opens, check your pop-up blocker or email your resume directly to resume@govtechtalentsolutions.ca, including the Requisition Number and Job Title in the subject line.