Senior Programmer Analyst

Staff - Non Union

Job Category
M&P - AAPS

Job Profile
AAPS Hourly - Information Systems and Technology, Level D

Job Title
Senior Programmer Analyst

Department
Energy & Water Finance | Office of the Comptroller | VP Finance and Operations

Compensation Range
$53.05 - $82.73 CAD Hourly

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
March 27, 2024

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

Job End Date

Dec 31, 2024

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 Senior Programmer Analyst leads the data analysis and extraction of customer and account data from the Energy and Water Services (EWS) Utilities Management System (UMS). The role also requires that the Senior Programmer Analyst provide analysis and documentation of any internal business logic within the UMS system that cannot be captured via data extraction processes. This position leads the analysis, design and review of existing or proposed system features and requirements and devises computer programs, systems and related procedures for the UMS project.

The Senior Programmer Analyst works collaboratively with the Data Migration Analyst, Enterprise Data Governance, and UMS project team members to analyze EWS data requirements, locate UMS data within the system, and then provide data extracts when requested. When possible, re-usable UMS data extraction methods will be created in order to minimize potential rework. This position is a key Integration Architect to design the UBC Application Programming Interface (API) and API-centric integrations for the UMS system, and the incumbent leads the analysis, design and review of computer application solutions for existing complex or campus-wide computer systems, in the context of enterprise data integration.

This position will need to work closely with UBC IT technical resources currently responsible for maintaining the UMS system in order to extract the most current data from the system or refresh staging databases needed for data migration purposes. The incumbent will participate in UMS data extraction processes and will be required to assist UMS vendors with data migration efforts.  

This position may work closely with analysts, technical leads, managers and developers from UBC IT, the Enterprise Resource Planning (ERP) program, sustainment teams, and the broader IT community. The incumbent will lead in the design and implementation of data integration solutions, including and especially aspects of the UBC API, as necessary, to satisfy the ongoing data integration needs of the University and the UMS systems.  This is a hands-on delivery role within a multi-disciplinary technical and business team.

Organizational Status

The Senior Programmer Analyst is a member of the Energy and Water Services department reporting directly to the Associate Director, Finance, the primary working sponsor for the UMS project.  Work will also be directed and reviewed by the Senior Project Manager, Program Delivery for the UMS project. 

The incumbent is expected to work collaboratively with the UMS project team while under the supervision of the Associate Director, Finance. Additionally, the incumbent will work directly with third party vendors, other University technology professionals, and with EWS staff. When working with the UMS project team, this position focuses on UMS data extractions and migrations and when required reverse engineering business requirements from the system environment. Additionally, the position will work closely with other project data migration specialists to ensure project success, and will accept direction from the UMS Senior Project Manager.

Work Performed

Specific Duties

• Designs, develops and leads the development of UBC APIs and API-centric data integrations, which includes investigating, analyzing, estimating, designing, developing, testing, documenting, and implementing on-time and to budget.
• Ensures overall quality of the development work and strives for zero defects.
• Offers extensive expertise and knowledge to associates.
• Designs robust, highly disciplined and maintainable data migration processes, and when requested will assist with building staging data repositories; develop data profiling, quality and cleansing requirements.
• Defines detailed data integration strategies, approaches, and plans under the guidance of the Integration Architect.
• Contributes to the evaluation and selection process of software products for data integrations projects, and advises on options, risk, cost vs. benefits, and impacts on business processes and goals.
• Defines standards, structures, and techniques for integration solutions.
• Serves as an integration specialist for functional analysts to help define, estimate, and propose solutions for data integration challenges.
• Develops proofs-of-concept and data migration prototypes to help illustrate approaches to technology and functional problems.
• Creates technical design documents to communicate solutions that will be implemented by the development team.
• When required will assist with the creation of technical design documents to communicate solutions that will be implemented by the development team.
• Participates in design and code reviews with other data migration analysts to ensure efficiency and adherence to development standards.
• Coaches and trains other data migration analysts on the construction of components necessary to extract and migrate data.
• Build and maintain working relationships and collaborates with others to achieve client objectives.

Core Duties

• Provides technical leadership in the analysis and review of data migration requirements with users, business analysts, architects and team members.
• Designs, develops and programs specialized custom software, prepares functional specifications, and builds prototypes.
• Develops system test plans, oversees data migration testing of new or modified applications and ensures that outcomes meet specifications.
• Leads the development of data migration plans and for the incorporation of plans into data migration testing process.
• Ensures documentation of data migration procedures and changes to new or modified modules, tests activities/results, error handling and backup/recovery procedures.
• Provides expert advice on data migration design tasks and issues, and will contribute to ongoing planning and development of system implementation
• Provides technical expertise, training, and consultation to other staff
• When requested provides ongoing maintenance and operational support for applications
• Supports software development lifecycle and applies and follows appropriate programming/development methodologies and best practices as instructed.
• Performs other related duties as required.

Consequence of Error/Judgement

Information Technology plays a key role in enabling the University to achieve its goals of becoming one of the world’s leading post-secondary institutions. The incumbent plays a significant role in the implementation of enterprise-wide systems and processes. Should these projects not be completed successfully or the results not support the activities of the University, this could compromise the University s ability to achieve its strategic goals and vision. Inability of systems and processes to support the University s needs could seriously compromise daily business activities.

The incumbent takes an active, participatory role in ensuring the reliability and availability of UBC mission critical 24x7x365 systems including application monitoring, tier 2 support, problem analysis and resolution, and ensuring services meet or exceed customer service levels at all times. Errors in judgment, poor planning, or failure to act decisively could have a detrimental effect on these systems. Unreliable systems and code errors that disrupt the reliable operations of these system will damage the reputation of the University.

Supervision Received

Works autonomously in accordance with general instructions as to methods and procedures. Work is reviewed in terms of achievement of desired results. Reports to the Associate Director Finance and work is reviewed by the Senior Project Manager, Program Delivery for the UMS project.   
Supervision Given

Provides guidance, coaching and technical leadership to less experienced Programmer Analysts. Conducts peer reviews of the designs and implementations of colleagues. Provides feedback to Managers on other Programmer Analysts performance and makes recommendations for facilitating improvements.

Directs and coordinates the work of other Programmer Analysts, Business Analysts, QA Analysts, users and other staff assigned to projects.

Minimum Qualifications

Undergraduate degree in a relevant discipline. Minimum of eight years of related experience including at least two years of managerial experience, or the equivalent combination of education and experience.
- Willingness to respect diverse perspectives, including perspectives in conflict with one’s own

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

Preferred Qualifications

• Extensive experience with Utilities Management Systems (UMS).

• In-depth knowledge and experience of applications and supporting business requirements.

• Experience with data analysis and modeling, relevant development tools, specific application and system architecture.

• Experience working with both technical and non-technical clients. Ability to effectively handle multiple tasks and priorities while working under pressure to meet critical, time sensitive deadlines. Strong organizational and planning skills.

• Very good oral and technical written communication skills.

• Very good working knowledge of programming/scripting/markup languages for Utilities Management Systems.

• Strong working knowledge of enterprise integration patterns and integrations

• Good understanding and experience with data modeling, data mapping, data structures, and data integration of Utilities Management Systems.

• Good project management skills/

• Strong analytical and problem-solving skills demonstrated through troubleshooting complex technical problems.