Sr. Programmer Analyst Research Computing Regular Full-Time

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 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

• Bachelors 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 Visual 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.