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.