Human Resources

Human Resources

Human Resources

site header

Programmer Analyst

Subscribe to RSS Feed
Printer friendly interface
Competition Number: J1022-0885
Position Title: Programmer Analyst
Employee Group: Support Staff - USW Local 2010
Job Category: Information Technology
Department or Area: ADV Info Tech Management
Location: Kingston, Ontario, Canada
Salary: $63,762.00 - $77,750.00/Year
Grade: 08
Hours per Week: 35
Job Type: Term
Length of term: 12 months
Shift: 7 Monday - Friday
Number Of Positions: 1
Date Posted: November 9, 2022
Closing Date: December 4, 2022
Additional Information:
This position is eligible for a remote work arrangement within Canada.

COVID 19 On-Campus Requirements

The Queen’s University Policy Regarding Mandatory Vaccination Requirements for In-person University Activities requires ALL Community Members, including employees, to be Fully Vaccinated against COVID-19 prior to participating in any In-person University Activities. This is a condition of employment for all employees who are required to attend University Property to perform their employment responsibilities. Individuals who cannot be vaccinated due to substantiated grounds (medical and other protected grounds under the Ontario Human Rights Code) may ask the University to validate the exemption and request an accommodation for these rare circumstances. If approved, they will be subject to additional health and safety measures.

About Queen's University

Queen’s University is the Canadian research intensive university with a transformative student learning experience. Here the employment experience is as diverse as it is interesting. We have opportunities in multiple areas of globally recognized research, faculty administration, engineering & construction, athletics & recreation, power generation, corporate shared services, and many more.

We are committed to employment equity and diversity in the workplace and welcome applications from individuals from equity seeking groups such as women, racialized/visible minorities, Indigenous/Aboriginal peoples, persons with a disability, persons who identify in the LGBTQ+ community and others who reflect the diversity of Canadian society.

Come work with us!

Job Summary

Reporting to the Associate Director, Information Automation and Delivery, the Programmer Analyst performs a crucial role in managing data, application programming, data integration, reporting, and project support for the Office of Advancement. This role will work closely and collaboratively with our team of developers, analysts, and business subject matter experts to support the Office of Advancement's goal of increasing philanthropy, stewarding donors, and engaging our alumni around the world.

The Programmer Analyst is responsible for programming PL/SQL, supporting the needs of the data warehousing and business intelligence environment, assisting in the definition and prioritization of data, and reporting requests.

As an ideal candidate, you are curious, detail-oriented and will execute tasks and activities with a professional, results-focused, collaborative approach, and will communicate in a proactive manner. Success in this role requires working closely with end-users to understand their unique needs, and to translate these into practical solutions within an appropriate timeframe, by leveraging your technical knowledge.

We value strong developers who have a passion for building efficient solutions with the end-user in mind. We will offer a wide range of challenges and interesting projects while encouraging skill development in areas of interest. Our goal is to create a rewarding environment where you can grow, learn, and improve your skills. If you are interested in working with an exceptional group of people and playing a pivotal role in supporting the evolving needs of our organization – we encourage you to apply.

Job Description


A Brief Overview

This position programs, maintains, develops and supports various databases, applications, websites, and/or systems. This position consults with units or departments on a variety of applications needs. This position installs, designs, codes, modifies, tests, debugs, and maintains applications to meet user needs. This position also analyses and revises system logic, develops and maintains bridging integrations between systems, modifies procedures, and documents changes.



What you will do
  • Programs, maintains, develops and supports various databases, applications, websites, and/or systems.
  • Consults with units or departments on a variety of applications needs.
  • Installs, designs, codes, modifies, tests, debugs, and maintains applications to meet user needs.
  • Analyses and revises system logic, modifies procedures, and documents changes.
  • Develops scripts to automate processes.
  • Develops and maintains bridging integrations between systems.
  • Provides detailed instructions and documentation on system operations.
  • Revises procedures and documentation to describe program development, logic, coding, and corrections.
  • Other duties as required in support of the department and/or unit.
Required Education
  • Three-year Community College Diploma or Three-Year Bachelor Degree, or equivalent. In addition, requires trade certification, qualification, or on-going learning to remain ahead of changes in technology or emerging fields.
    Required Experience
    • More than 3 years and up to and including 5 years of experience.
      • Experience in database administration/management, design and/or technologies considered an asset (e.g., MySQL, PostgreSQL, and/or Oracle/DB2, relational databases, warehoused databases, etc.).
      • Experience in program analysis and reporting considered an asset.
      • Experience working in a comparable client-focused environment considered an asset
      • Familiarity with software development best practices, including coding standards, code reviews, source control management, build processes, testing, and operations considered an asset.
    Consideration may be given to an equivalent combination of education and experience.

    Job Knowledge and Requirements
    • Knowledge of concepts and principles in a specialist field that is typically acquired through a combination of advanced professional or academic qualifications and/or substantial work experience.
    • Provide effective consultation and advice on non-straightforward and/or complex issues.
    • Interaction with others requires interpersonal skills and the ability to understand and influence.
    • Adapt messages to meet the different needs of different audiences.
    • Builds relationships, trust and credibility.
    • Prioritize and distribute work to deliver objectives on time and to the highest standard.
    • Identify in advance when the intended results may not be achieved and develops a plan to address the gaps.
    • Actively participate in project team meetings and develop individual and unit project plans.
    • Lead procedural or technological change within a unit.
    • Identify opportunities to improve the effectiveness and efficiency of work processes.
    • Seek information and input to fully understand the cause of problems.
    • Appropriately assesses risks before making a decision.
    • Contribute to the creation and evaluation of possible solutions.
    • Take action to remove obstacles and address problems before the impact performance and results.
    • Apply equity, diversity, accessibility, inclusion and Indigenization considerations to decision making and planning.
    • Promote a work environment that is free from sexual violence, harassment and discrimination, and the ability to show empathy for those who have experienced trauma.

    Employment Equity and Accessibility Statement

    The University invites applications from all qualified individuals. Queen’s is committed to employment equity and diversity in the workplace and welcomes applications from women, visible minorities, Aboriginal Peoples, persons with disabilities, and persons of any sexual orientation or gender identity. In accordance with Canadian Immigration requirements, priority will be given to Canadian citizens and permanent residents.

    The University provides support in its recruitment processes to applicants with disabilities, including accommodation that takes into account an applicant's accessibility needs. Candidates requiring accommodation during the recruitment process are asked to contact Human Resources at hradmin@queensu.ca.

    Njoyn ATS