Senior Programmer Systems Analyst

University of British Columbia•Vancouver, BC

3d•CA$10,155 - CA$15,842

About The Position

The Senior Programmer Analyst leads the analysis, design and review of existing or proposed system features and requirements and devises computer programs, systems and related procedures. The Senior Programmer Analyst works collaboratively with the Integration Architect to design the UBC Application Programming Interface (API) and API-centric integrations, 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. The incumbent plays a leading role in all aspects of the planning, analysis, design and implementation and operation of an enterprise-scale data integration solution for the University of British Columbia that transforms the processes and systems by which data is exchanged between major and minor systems at the university. Working 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 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 University s major ERP programs. This is a hands-on delivery role within a multi-disciplinary technical and business team.

Requirements

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

Nice To Haves

Experience in Mulesoft programming is preferred.
Experience in designing, developing and implementing medium to large scale software applications and integrations primarily using Java or Java-based tools to implement SOAP-based web services or RESTful APIs an asset.
Demonstrated knowledge of and experience working with Enterprise Application Integration tools (ETLs, ESBs, etc.) implementing Enterprise Integration Patterns.
Demonstrated experience leading multi-disciplinary teams consisting of Programmer Analysts, Business Analysts and Quality Assurance Analysts.
General knowledge and/or experience of standard industry methodologies for large COTS implementation programs.
Very good oral and technical written communication skills.
Very good working knowledge of programming/scripting/markup languages such as Java, Groovy, Python, Perl, HTML, XML, JSON, etc.
Strong working knowledge of SOAP/REST concepts and technologies: XSD, XSLT, XPATH, WSDL, SOAP APIs, WS-, JSON Schema, RAML/Swagger, RESTful APIs, and OAuth2, both using and implementing.
Strong working knowledge of enterprise integration patterns include message oriented integrations that leverage technologies such as ActiveMQ, JMS and STOMP.
Good understanding and experience with data modeling, data mapping, data structures, and data integration including the following concepts and technologies: SOA, ETLs, ESBs, MOMs, EAI, enterprise integration patterns, SQL/DDL/DML.
Experience using ESB, ETL and RDMBS tools such as Oracle Data Integration Suite, MuleSoft AnyPoint Studio and ESB; Pentaho Data Integration Suite; Talend Data Integration Suite; Oracle RDBMS; MS SQL Server; and/or MySQL.
Good understanding and practical experience with many of the following: Object Oriented Analysis and Design concepts, design techniques and patterns; UML concepts; ORM frameworks; web application frameworks; software development methodologies and tools (e.g. build management, code repositories, version control, continuous integration and continuous deployment); test-driven design; behaviour-driven design.
Good project management skills including a working knowledge of SDLC methodologies, preferably Agile methodologies (e.g. Lean, XP or Scrum).
Strong analytical and problem solving skills demonstrated through troubleshooting complex technical problems.
Strong working knowledge of Full Stack development with expertise in Java, JavaScript, PostgreSQL, HTML, CSS, JSON, and ZK Framework.
Demonstrated working knowledge of source code management tools and best practices.
Very good understanding and experience with QA methodologies, especially for Full Stack development.
Demonstrated knowledge and experience of database optimization and best practices.
Strong understanding of data structures and algorithms such as Arrays, Linked Lists, Stacks, Queues, Searching and Sorting algorithms.
Demonstrated knowledge and experience working with Service Now and Atlassian APIs.
Proven experience leading Requirements Workshops and documenting business as well as technical requirements.
Strong working knowledge of creating and maintaining UML and data flow diagrams.
General knowledge of Change Management approaches and best practices.
Practical experience with key components for AI systems including AI orchestration, AI agents, RAG, A2A, MCP, tool calling, model training/fine-tuning.
Good understanding and experience with AI governance including accountability, transparency, fairness, privacy and security.
Hands-on experience building AI-enabled integrations using LLMs for search, summarization, and automated decision workflows.

Responsibilities

Contributes to the UBC API strategy and promotes adoption throughout the organization.
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; build master data repositories; develop data profiling, quality and cleansing requirements.
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.
Serves as an integration specialist for functional analysts to help define, estimate, and propose solutions for data integration challenges.
Develops proofs-of-concept and prototypes to help illustrate approaches to technology and functional problems.
Defines detailed data integration strategies, approaches, and plans under the guidance of the Integration Architect.
Defines standards, structures, and techniques for integration solutions.
Creates technical design documents to communicate solutions that will be implemented by the development team.
Facilitates and conducts design and code reviews for other Programmer Analysts to ensure efficiency and adherence to development standards.
Coaches and trains other Programmer Analysts in the construction of components necessary to clean, transform, and migrate data.
Build and maintain working relationships and collaborates with others to achieve client objectives.
Conducts Requirements Workshops to solicit business requirements and work with various technical teams to document technical requirements and detailed solution design.
Create and maintain test cases from business and technical requirements.
Works with different teams to conduct various types of QA activities to drive a successful project delivery
Provides technical leadership in the analysis and review of existing or proposed system features and integration, security, scalability and performance requirements with users, business analysts, architects and team members.
Leads the evaluation and selection process for application packages, and advises on options, risk, cost vs. benefits, and impacts on business processes and goals.
Develops system test plans, oversees testing of new or modified applications and ensures applications meet specifications.
Develops integration plans and ensures for the incorporation of plans into integration testing process.
Ensures documentation of functions and changes to new or modified modules, tests activities/results, error handling and backup/recovery procedures.
Designs, develops and programs specialized custom software, prepares functional specifications, and builds prototypes.
Provides expert advice on complex system design issues and contributes to ongoing planning and development of systems enhancements.
Packages in house developed applications for production or integrates vendor supplied applications.
May manage small to medium sized projects.
Provides technical expertise, training, and consultation to other staff.
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.
Maintains appropriate professional designations and up-to-date knowledge of current information technology techniques and tools.
Performs other related duties as required.
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.
Provides input/recommendations into the hiring and evaluation of staff.