Sr. Programmer Analyst - Research Computing - Regular Full-Time 2026-18484 (2026-18484)

Sunnybrook; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

Sunnybrook Research Institute is seeking a Senior Programmer Analyst to develop, support, and optimize critical research and operational applications on-site. You will handle application development, database management, DevOps support, and automation, collaborating with IT, research, and operations teams to ensure secure, high-performing systems.

The role emphasizes data integrity, documentation, and proactive improvements in automation and cybersecurity practices, with responsibilities

Qualifications

• Bachelor's degree in a related field or equivalent experience.
• Minimum 5 years of programming, application development, or IT systems management.
• Strong proficiency in RDBMS and database programming (MS Access, SQL Server, MySQL).
• Experience with web and application development using PHP, ASP.NET, Visual Studio.NET, HTML/CSS, XML, and scripting languages (VBA, Python, R, Java, JSON).
• Experience administering REDCap is asset.
• Solid understanding of API integrations, version upgrades, patch management, and system testing.
• Strong analytical, troubleshooting, and communication skills.
• Excellent time management, organization, and attention to detail.
• Knowledge of cybersecurity best practices and mitigation strategies is an asset.

Responsibilities

• Plan, design, develop, test, and document computer programs and web applications.
• Function as an application specialist for REDCap, custom .NET applications, PHP, Python, and Java.
• Evaluate and implement new or modified program requests from users.
• Create and maintain database-driven applications in MS Access, SQL Server, and MySQL.
• Develop data validation rules, forms, and reports to ensure data accuracy and integrity.
• Deliver clear, accurate, and detailed technical documentation, including design and operational guides.
• Manage and maintain databases for clinical, financial, and research operations.
• Perform database administration, optimization, and troubleshooting using MS Access, SQL Server, and MySQL.
• Write and optimize complex SQL queries and stored procedures.
• Perform weekly/monthly server maintenance, system upgrades, and apply security patches.
• Implement and support API integrations, automation scripts, and quality testing processes.
• Implement and maintain automation for reporting, workflows, and data management.
• Support application upgrades, deployment pipelines, and configuration management.
• Identify and implement improvements for performance, scalability, and reliability.
• Work closely with IT, research, and operational teams to enhance system functionality and user experience.
• Support virtual user events, training sessions, and technical presentations.
• Provide user support, troubleshoot issues, and ensure timely resolution of application-related inquiries.
• Contribute to process optimization, knowledge sharing, and documentation updates.
• Identify opportunities to improve automation, data flow, and cybersecurity practices.

Skills

Programming

RDBMS

Web development

APIs

Communication

DevOps

Python

VBA

Analytical thinking

Education

Bachelor's degree in CS/CE/IS

Tools

REDCap

MS Access

SQL Server

MySQL

PHP

ASP.NET

Visual Studio

HTML/CSS

XML

JSON

VBA

Python

Job description

Job Title

Senior Programmer Analyst

Department

Sunnybrook Research Institute (On-site)

Summary:

Reporting to the Research Computing Manager, the Senior Programmer Analyst plays a key role in developing, supporting, and optimizing critical research and operational applications across SRI. This position combines application development, programming, DevOps support, database management, and process automation, ensuring secure, efficient, and high-performing systems. The role involves close collaboration with cross-functional teams to deliver innovative solutions, maintain application stability, and support data-driven decision-making.

Key Responsibilities

Application Development & Administration

• Plan, design, develop, test, and document computer programs and web applications.
• Function as an application specialist for REDCap, custom .NET applications, PHP, Python, and Java.
• Evaluate and implement new or modified program requests from users.
• Create and maintain database-driven applications in, MS Access, SQL Server, and MySQL.
• Develop data validation rules, forms, and reports to ensure data accuracy and integrity.
• Deliver clear, accurate, and detailed technical documentation, including design and operational guides.

Database & System Management

• Manage and maintain databases for clinical, financial, and research operations.
• Perform database administration, optimization, and troubleshooting using MS Access (with VBA), SQL Server, and MySQL.
• Write and optimize complex SQL queries and stored procedures.
• Perform weekly/monthly server maintenance, system upgrades, and apply security patches.
• Implement and support API integrations, automation scripts, and quality testing processes.

DevOps & Automation

• Implement and maintain automation for reporting, workflows, and data management.
• Support application upgrades, deployment pipelines, and configuration management.
• Identify and implement improvements for performance, scalability, and reliability.

Collaboration & Communication

• Work closely with IT, research, and operational teams to enhance system functionality and user experience.
• Support virtual user events, training sessions, and technical presentations.
• Provide user support, troubleshoot issues, and ensure timely resolution of application-related inquiries.

Continuous Improvement

• Contribute to process optimization, knowledge sharing, and documentation updates.
• Identify opportunities to improve automation, data flow, and cybersecurity practices.

Qualifications

• Bachelor's degree in computer science, Computer Engineering, Information Systems, or equivalent experience.
• Minimum 5 years of experience in programming, application development, or IT systems management.
• Strong proficiency in RDBMS and database programming (MS Access, SQL Server, MySQL).
• Experience with web and application development using PHP, ASP.NET, Visual Studio.NET, HTML/CSS, XML, and scripting languages (VBA, Python, R, Java, JSON).
• Experience administering REDCap is asset.
• Solid understanding of API integrations, version upgrades, patch management, and system testing.
• Strong analytical, troubleshooting, and communication skills.
• Excellent time management, organization, and attention to detail.
• Knowledge of cybersecurity best practices and mitigation strategies is an asset.