Systems Analyst

Please refer to the How to Apply for a Job (for External Candidates) job aid for instructions on how to apply.

If you are an active McGill employee (ie: currently in an active contract or position at McGill University), do not apply through this Career Site. Login to your McGill Workday account and apply to this posting using the Find Jobs report (type Find Jobs in the search bar).

University Advancement (UA) promotes McGill to its global community and to the public, engaging alumni, volunteers and friends of the University, and building on McGill’s record of fundraising success in support of University priorities.

By joining UA, you can be part of a dynamic, exciting and growing team of professionals that is making an extraordinary impact on the world by advancing the philanthropic and engagement ambitions of McGill University.

To find out more about UA, please visit us at www.mcgill.ca/advancement/ua-careers .

Position Summary:

As part of the UA development team, the Systems Analyst will contribute to the development, maintenance and enhancement of University Advancement’s systems, with a primary focus on our backend systems and databases, to ensure that they meet the current and future needs of the stakeholders and the user community. Working closely with other IT teams, the incumbent delivers services in a timely manner and at the high level of quality expected by McGill users. The Systems Analyst designs, develops, debugs, tests, supports/maintains, integrates applications and IT systems.

Primary Responsibilities:

• Design, develops, maintains and optimize complex DB schemas, SQL scripts and objects to meet application functionality and performance requirements. Working with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issue.

• Develops artifacts such as, but not limited to: code, scripts (Database and others), automated unit/functional/integration tests, unit test cases, and deployment instructions.

• Supports and maintains the unit’s set of applications.

• Works with other team members and colleagues from other IT Units in implementing new systems or modifying existing systems that meet business requirements and are aligned with the unit’s standards and orientations : (i)Transforms detailed functional specifications into code/scripts in accordance with design and programming standards; (ii)Provides estimates for tasks and artifacts under own responsibility.

• Conducts unit testing and supports Analysts and Technical teams during functional and integration testing.

• Participates in the proposal, definition and promotion of development standards.

• Thinks analytically, bringing forward ideas to improve existing processes and procedures.

• Supports the team in resolving system incidents/problems.

• Assists Technical Teams during deployment.

• Interacts with non-technical users, other IT colleagues, and uses online and other resources to understand requirements and specifications and to provide the best possible solutions. As needed, consults with and trains other Systems staff and UA power-users.

• Keeps abreast of new developments and trends in the field of advancement technology.

• Participates in the evaluation of new hardware and software products providing the feedback, testing, debugging as needed.

• Performs other duties as assigned.

Other Qualifying Skills and/or Abilities

• Desired: Three (3) to five (5) years’ related experience.
• Undergraduate degree in computer science or similar.
• Proven experience in Database server and Structured Query Language (DBs and SQL), expertise with Oracle is a must, experience with Programming Language PL/SQL is required.
• Knowledge of Web Services – Simple Object Access Protocol, Representation State Transfer (SOAP, REST). Object Oriented Programming.
• Knowledge of Web front/backend development (PHP, HTML5, JavaScript, Jquery).
• Familiarity with Microsoft Active Directory and Azure Services.
• Experience with Version Control Systems (GIT, GITLAB are assets).
• Familiarity with Linux. Knowledge of Software Delivery Life Cycle.
• Knowledge of the higher education and/or philanthropic sector an asset. Good troubleshooting skills.
• Attention to detail, diligent and rigorous work methods.
• Self-motivated and demonstrated ability to work on different projects concurrently and to establish priorities.
• Good team player with strong focus on delivering results to meet the business needs.
• Excellent verbal and written communication skills – English, spoken and written – French, spoken.
• Knowledge of French and English: McGill University is an English-language university where day to day duties may require English communication both verbally and in writing. The level of English required for this position has been assessed at a level #3 on a scale of 0-4.

Additional Information:

Testing may be administered. This is a one year term appointment.

#LI-HYBRID

Minimum Education and Experience:

Bachelor's Degree 3 Years Related Experience /

Annual Salary:

(MPEX Grade 05) $70,820.00 - $88,530.00 - $106,240.00

Job Profile:

MPEX-IST2E - IT Business Application - Professional 2

Hours per Week:

33.75 (Full time)

Supervisor:

Executive Director (Advancement Operations)

Position End Date (If applicable):

2024-08-31

Deadline to Apply:

2024-07-17

McGill University hires on the basis of merit and is strongly committed to equity and diversity within its community. We welcome applications from racialized persons/visible minorities, women, Indigenous persons, persons with disabilities, ethnic minorities, and persons of minority sexual orientations and gender identities, as well as from all qualified candidates with the skills and knowledge to productively engage with diverse communities. McGill implements an employment equity program and encourages members of designated groups to self-identify. Persons with disabilities who anticipate needing accommodations for any part of the application process may contact, in confidence, accessibilityrequest.hr@mcgill.ca.