Senior Programmer Analyst - Vancouver, Canada - UBC

Description

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 day prior to the Posting End Date above.

Job End Date

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 analysis, design and review of existing or proposed system features and requirements and devises computer programs, systems and related procedures. This role will focus on the ongoing sustainment and continuous improvement of APIS and related systems.

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, 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.

Organizational Status

The incumbent is a member of the Integration Enablement Centre (IEC), and reports to one of the managers within Integration Enablement Centre who reports to the Technical Delivery Associate Director.

The IEC is responsible for the selection, acquisition or development, deployment and operation of the suite of applications related to enterprise data integration. The IEC works closely with

core UBC IT teams (e.g., NMC and Systems), and with ERP program and sustainment teams to ensure that all releases to production of integration applications are of the highest quality.

The incumbent is expected to lead small, interdisciplinary teams consisting of other Programmer Analysts, Business Analysts, and Quality Assurance Analysts to ensure the highest quality of solution delivery. When assigned to lead a team, this position focuses on ERP Refresh Program integrations, works very closely with the program s resources to ensure program success, and accepts direction from the Integration Architect and other Senior Programmer Analyst assigned to overall UBC API / Enterprise Data Objects (EDO) execution.

Additionally, the incumbent will interact directly with third party vendors, other University technology professionals and with faculty, staff and students.

Work Performed

Specific Duties

• Contributes to the UBC API strategy and promotes adoption throughout the organization.
• Designs, develops or 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.

Core Duties

• Up to April 2027, prepares all necessary application support processes and documentation to help transition APIs for long term sustainment post IRP STU go-live.
• 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.

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, Program Delivery.

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. Provides input/recommendations into the hiring and evaluation of staff.

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.

Preferred Qualifications

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.

Core Competencies:

Collaboration (Advanced - A):

Consistently fosters collaboration and respect among team members by addressing elements of the group process that impedes, or could impede, the group from reaching its goal. Engages the "right people," within and beyond organizational boundaries, by matching individual capabilities and skills to the team's goals. Works with a wide range of teams and readily shares lessons learned and credit for team accomplishments.

Communicating for Results (Advanced - A):

Converses with, writes reports for, and creates/delivers presentations to all levels of colleagues and peer groups in ways that support problem solving and planning. Seeks a consensus with business partners. Debates opinions, tests understanding, and clarifies judgments. Brings conflict into the open empathetically. Explains the context of multiple interrelated situations, asks searching, probing questions, and solicits expert advice prior to taking action and making recommendations.

Problem Solving (Advanced - A):

Diagnoses problems using formal problem-solving tools and techniques from multiple angles and probes underlying issues to generate multiple potential solutions. Proactively anticipates and prevents problems. Devises, facilitates buy-in, makes recommendations, and guides implementation of corrective and/or preventive actions for complex issues that cross organizational boundaries and are unclear in nature. Identifies potential consequences and risk levels. Seeks support and buy-in for problem definition, methods of resolution, and accountability.

Role Based Competencies:

Accountability (Advanced - A):

Sets enhanced objectives for self and others. Monitors performance trends and identifies opportunities to improve standards. Provides regular feedback and suggests alternative approaches necessary to ensure that organizational objectives and superior standards are achieved. Delegates responsibility and reallocates resources as needed to ensure that priorities are met for initiatives within area of responsibility.

Business Process Knowledge (Advanced - A):

Describes and documents critical cross-functional business process flows. Applies business process reengineering techniques and methods in analyzing process flow and accountability charts. Recommends and advocates substantive process enhancements and assesses both internal and external implications.

Information Systems Knowledge(Advanced - A):

Identifies means of integrating technical support requirements with enterprise processes and strategies. Identifies technological opportunities to meet client needs. Creates information system solutions to meet the needs of business stakeholders. Partners with appropriate technical consultants, experts, and managers to resolves complex problems across all IT solutions.