Senior Programmer Analyst

Staff - Non Union

Job Category
M&P - AAPS

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

Job Title
Senior Programmer Analyst

Department
OCIO | Enterprise Data & Business Intelligence

Compensation Range
$9,572.08 - $14,932.75 CAD Monthly

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
February 23, 2024

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 UDAP solutions for UBC, as well as complex campus-wide data sets to support business and operational decisions. They play an important role in the strategic development of consumable data for reports and dashboards across all campus organizations, and assist in maintaining the University Data Platform.
Organizational Status

Interacts directly with other University technology professionals and with faculty, staff and students. Reports to the Manager, Enterprise Data and Business Intelligence. On a daily basis, the incumbent will work under the direction of their direct manager, as well as Project or Program Managers while assigned to a development project.

The position takes a leadership role working with other Programmer Analysts, Data Architects, Business Analysts and Quality Assurance staff in ensuring the highest quality of both data and code is promoted into our UBC test and production environments. They are experts in Integrations, covering applications such as Workday, OpenAthens, Salesforce, as well as other application systems or third party modules that will require functional or data connectivity to UDAP.

Work Performed

Specific Duties:

• Takes an active interest in current and upcoming technologies and works with UBC IT architects to provide input into both the Application, Data and Technical architecture as they relate to the UDAP and development of integrations.

• Facilitates and conducts design and code reviews for other Programmer Analysts to ensure efficiency and adherence to development standards.

• Leads the coordination of the various UDAP design elements associated with ETL code, data integration, and script development. Senior Programmer Analysts will work closely with other developers, UX Architects/Designers and DBAs and ensure that designs are incorporated into Technical Specifications as required and specifications are updated as changes occur.

• Conducts testing of new or customized UDAP application modules to ensure application meets specifications.

• Conducts testing and validation of data when changes are directly or indirectly applied to UDAP.

• Participates in project planning and implementation.

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

Core Duties:

• 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 data, business processes and goals.

• Develops integration plans and system test plans, overseeing testing of new or modified applications and ensures data and applications meet specifications.

• 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 and code, prepares functional specifications, and builds prototypes.

• Provides expert advice on complex report, dataset, and 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 the data platform development lifecycle and applies and follows appropriate development methodologies and best practices.

• 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

The position takes a pro-active leadership role in ensuring the reliability and high availability of UBC mission critical 7x24 systems including data platform monitoring, tier 2 and tier 3 support, problem analysis and resolution, and ensuring services meet or exceed UBC business requirements.

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 operations of these system, or failure to meet contractual obligations for performance and availability will damage the reputation of UBC and UBC-IT. This could adversely impact the University community, including the large majority of students, faculty and staff, and could cost hundreds of thousands of dollars in lost productivity, funding and revenue.

Supervision Received
The Senior Programmer Analyst may also take direction from the Project Manager for Project based activities and tasks as assigned.
Supervision Given

Providing guidance, coaching and technical leadership to less experienced Programmer Analysts. Conducts peer reviews of the designs and code. Will also provide feedback to the Manager of Data & Business Intelligence, on other Programmer Analysts performance and recommendations for facilitating improvement.

In a project leader role, the Senior Programmer Analyst may direct and supervise work of other Programmer Analysts, Business Analysts, QAs, users and other staff assigned to projects.

May provide input/recommendations into the hiring, evaluation, discipline and termination of staff.
Qualifications

• Undergraduate degree in a relevant discipline.

• Undergraduate degree in Computer Science preferred.

• A minimum of 6 years of experience or the equivalent combination of education and experience.

• Demonstrated ongoing career development through active and self-motivated professional development.

• Very strong experience with designing, developing and implementing ETL jobs (Informatica and IICS preferred).

• An understanding of API’s and leading data integration technologies is an asset.

• Very strong understanding of data modeling, data profiling and data quality concepts and techniques.

• Very strong skills in and database design, and data warehouse architectures.

• Strong understanding and experience with Testing best practices/concepts.

• Very strong skills with relational databases (Oracle, MySQL, SQL Server, Oracle pl/sql in addition to ansi sql).

• In-depth knowledge of Workday and/or Student Information Systems is an asset.

• Strong Java skills including experience with the current versions/releases and an awareness of upcoming enhancements in the following technologies; JDK, Java Enterprise Edition (EE), Servlets, JSP, JSTL, UI Development tools and concepts (e.g. GWT, JSF, Swing, UX).

• Experience in cloud storage an asset.

• Experience building dashboards and reports is an asset (preferably Tableau or MS PBI).

• Experience using PHP, Drupal and/or Wordpress development tools/environments; .net, C Sharp development tools/environment; and MS SQL Server and/or MySQL would be an asset; as well as experience with Customer Relationship Management systems (CRM), workflow and rules engines, BPEL and ESB.

• Strong project management skills including a working knowledge of SDLC methodologies, preferably RUP and Agile methodologies (e.g. Lean, XP or Scrum).

• Collaboration - 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.

• Communication for Results - 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 - 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.

• Accountability - 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 - 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 - 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.