Programmer Analyst I

Job Profile
AAPS Salaried - Information Systems and Technology, Level B

Job Title
Programmer Analyst I

Department
Student Housing and Community Services | Development Services IT

Compensation Range
$6,251.00 - $8,986.00 CAD Monthly

Posting End Date
April 25, 2025

Job Summary
The Programmer Analyst I programs software application modules and codes, tests, debugs, documents, and maintains those modules. This position works a fixed schedule but requires flexibility as some work must be performed outside of regular business operating hours. The programmer analyst may also be required for occasional on-call duties.

Organizational Status
The Programmer Analyst I is a member of the Student Housing and Community Services IT team providing support and development for Student Housing and Community Services' systems from the physical to the database level. This position works closely with other UBC IT teams to support campus enterprise network services as well as liaising with other academic and administrative clients, vendors, and industry peers.

Work Performed

1. Developing small modules of larger departmental applications and enhancing existing program logic of Student Housing and Community Services applications and other applications that the department supports.
2. Providing technical advice and proposing programming solutions for changes in business needs and processes within the department.
3. Working with other developers and analysts on designing modules of applications, developing ER diagrams and ETL processes when integrating with other applications.
4. Developing unit tests to ensure correctness of business functionality is developed.
5. Participating in code reviews and applies changes that are identified, ensuring that they are efficient and meet development standards.
6. Providing ad-hoc reporting with Microsoft Report Builder, Oracle, and other reporting tools by extracting data from the Oracle database.
7. Preparing programming documentation and flowcharts for department projects arising from changes in business processes.
8. Creating and maintaining documentation and procedures for systems-related processes using tools such as Microsoft Office.
9. Providing training for staff in the use of Student Housing and Community Services applications and other applications that the department supports.
10. Troubleshooting software/hardware interfaces on computer-controlled devices.

Core Duties

1. Programs small/discrete software application modules.
2. Conducts testing and debugging of small modules to ensure application meets specifications.
3. Prepares programming documentation for assigned programs.
4. Supports software development lifecycle, and applies and follows appropriate programming/development methodologies and best practices as instructed.
5. Maintains appropriate professional designations and up-to-date knowledge of current information technology techniques and tools.
6. Participates in project planning and implementation.
7. Builds and maintains good working relationships and collaborates with others to achieve client objectives.
8. Performs other related duties as required.

Minimum Qualifications
Undergraduate degree in a relevant discipline. Minimum of two years of related experience, or the equivalent combination of education and experience.

Preferred Qualifications

1. Knowledge and experience with PHP, SQL, JavaScript.
2. Proficient with Windows operating system and Internet Browser applications.
3. Effective and methodical troubleshooting skills.
4. Strong organizational and interpersonal skills, and the ability to communicate effectively both verbally and in writing.
5. The ability to work effectively with minimal supervision and prioritize under pressure to meet deadlines.
6. Ability to work independently and within a team.

Seniority level: Entry level

Employment type: Full-time

Job function: Engineering and Information Technology

Industries: IT Services and IT Consulting