Job Category

Job Profile

Job Title

Department

Compensation Range

The Compensation Range is the span between the minimum and maximum base salary for a position. The midpoint of the range is approximately halfway between the minimum and the maximum and represents an employee that possesses full job knowledge, qualifications and experience for the position. In the normal course, employees will be hired, transferred or promoted between the minimum and midpoint of the salary range for a job.

Posting End Date

Note: Applications will be accepted until 11:59 PM on the Posting End Date.

Job End Date

This position is expected to be filled by promotion/reassignment and is included here to inform you of its vacancy at the University.

At UBC, we believe that attracting and sustaining a diverse workforce is key to the successful pursuit of excellence in research, innovation, and learning for all faculty, staff and students. Our commitment to employment equity helps achieve inclusion and fairness, brings rich diversity to UBC as a workplace, and creates the necessary conditions for a rewarding career.

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.

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.

This position deals directory with the availability, reliability of various operations of the department and other administrative units.

Work Performed

Specific Duties:

• 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, according to detailed specifications using PL/SQL developer tools, phpDesigner tools and other in-house tools.

• Providing technical advice and proposing programming solution for changes in business needs and processes within the department.

• Working with other developers and analysts on designing modules of applications, developing ER diagrams and ETL process when integrating with other applications.

• Developing unit tests to ensure correctness of business functionality is developed.

• Participating in code reviews and applies changes that are identified, and to ensure that they are efficient and meet development standards.

• Providing ad-hoc reporting with Microsoft Report Builder, Oracle and other reporting tools by extracting data from the Oracle database.

• Preparing programming documentation and flowcharts for the department projects arise from changes in business process.

• Creating and maintaining documentation and procedures for systems related processes using tools such as Microsoft Office.

• Providing training for staff in the use of Student Housing and Community Services applications and other applications that the departments supports. Troubleshoot software/hardware interfaces on computer controlled devices that includes integration of electronic mailboxes, door access in residences, and POS terminals across campus.

Core Duties:

• Programs small/discrete software application modules.

• Conducts testing and debugging of small modules to ensure application meets specifications.

• Prepares programming documentation for assigned programs.

• Supports software development lifecycle, and applies and follows appropriate programming/development methodologies and best practices as instructed.

• Maintains appropriate professional designations and up-to-date knowledge of current information technology techniques and tools.

• Participates in project planning and implementation.

• Builds and maintains good working relationships and collaborates with others to achieve client objectives.

• Performs other related duties as required.

Consequence of Error/Judgement

Expected to make decisions regarding the programming and technical support through the application of basic information processing principles, theories and concepts. Expected to make decisions within established guidelines regarding the application of computing devices or programs to meet set requirements or makes decisions regarding solutions to defined problems. Errors made in programming can disrupt operations or have a disproportionately large financial impact if the programming module relates to the processing of fees.

This position deals directly with the availability, reliability of various operations of the department and other administrative units. Poor design, support or errors in implementation could have significant impact on student and staff, operational and financial consequences as well as result in significant loss of productivity and revenue.

• Demonstrates a commitment to enhancing one’s own awareness, knowledge, and skills related to equity, diversity, and inclusion

Preferred Qualifications

• Knowledge and experience with php, sql, javascript.

• Proficient with Windows operating system and Internet Browser applications.

• Up-to-date knowledge of current information technology techniques and tools is required.

• Effective and methodical troubleshooting skills.

• Strong organizational, interpersonal skills, and the ability to communicate effectively both verbally and in writing.

• The ability to work effectively with minimal supervision, and to prioritize and work effectively under pressure to meet deadlines.

• Ability to work independently and within a team.

Core Competencies

Collaboration:

• Actively solicits ideas and opinions from others to efficiently and effectively accomplish specific objectives targeted at defined business outcomes.

• Openly encourages other team members to voice their ideas and concerns.

• Shows respect for differences and diversity, and disagrees without personalizing issues. Utilizes strengths of team members to achieve optimal performance.

Communicating for Results:

• Conducts discussions with and writes memoranda to all levels of colleagues and peer groups in ways that support troubleshooting and problem solving.

• Seeks and shares relevant information, opinions, and judgments.

• Handles conflict empathetically. Explains the context of interrelated situations, asks probing questions, and solicits multiple sources of advice prior to taking action when appropriate.

Problem Solving:

• Applies problem-solving methodologies and tools to diagnose and solve operational and interpersonal problems.

• Determines the potential causes of the problem and devises testing methodologies for validation.

• Shows empathy and objectivity toward individuals involved in the issue.

• Analyzes multiple alternatives, risks, and benefits for a range of potential solutions. Recommends resource requirements and collaborates with impacted stakeholders.

Accountability:

• Sets objectives that meet organizational needs.

• Provides recommendations to individuals and teams on ways to improve performance and meet defined objectives.

• Monitors and provides feedback on individual and team performance against defined standards.

Information Systems Knowledge:

• Resolves escalated problems of technical support.

• Identifies root causes.

• Sets up and integrates new and enhanced information systems.

• Identifies customer needs and determines the appropriate approach to apply and ensure resolution.

• Solicits the input of appropriate technical experts and managers as required.

Initiative:

• Seeks out new challenges that require risk taking.

• Determines the resources, team support, and technical needs necessary to enable success and procures them.

• Keeps responding to the challenge in spite of obstacles and setbacks.