Programmer Analyst

Staff - Non UnionJob CategoryM&P - AAPSJob ProfileAAPS Salaried - Information Systems and Technology, Level CJob TitleProgrammer AnalystDepartmentDAE DG and BI, BICompensation Range$6, $9,701.42 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 DateAugust 14, 2024

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

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 incumbent will develop and maintain the reporting environment for the Development and Alumni Engagement (DAE) portfolio at UBC. They will undertake data extracts, data enrichment and provide statistical information relating to policy, procedural support, decision-making and research projects within these units. This role works with all levels of stakeholders within the DAE portfolio to help provide excellent support and service to help the university reach its fundraising and alumni engagement goals.

Organizational Status

Reports directly to the Associate Director, Business Intelligence, DAE. Can take directions from Senior Developers, Business Analysts and Project Managers.

Works with: Data Governance, Data Analytics and Records teams, DAE Information Systems team, DAE Finance and Donations Processing teams, AlumniUBC, Development Office, Annual Giving, Communications and Stewardship teams, UBC faculty and staff involved in external relations, UBC service providers.

Contacts: Internal staff and stakeholders; vendor support and account management personnel; UBC IT staff.

Work Performed

• Takes lead and is responsible for reporting and extracting information for faculties and departments across campus. This position will interact with business analysts, administrative staff and faculty in the University community to define the reporting needs;
• Will be required to conduct interviews or design sessions, system and data analysis, and documentation to facilitate end-user reporting requirements. Must be able to deliver end-user reports and dashboards using a variety of desktop and web reporting tools such as SSRS, Tableau, PowerBI or other tools as required;
• Obtains information from a variety of sources, including the complex institutional databases, in consultation with other units. These administrative systems are constantly growing and changing due to pressures from changing policies and procedures as well as to keep pace with new technological developments. Will be required to keep abreast of the database changes made to these administrative systems, test components that affect on-line access or batch reporting;
• Provides functional and technical training, system organization, consultation and recommendations for managing end-user reporting;
• Design, extraction and analysis of data through the creation and maintenance of computer programs to produce a Reporting Database /DataWarehouse, including data validation, testing, data cleansing and statistical reports from other university-wide systems such as Student Information System, Finance and HR Systems;
• Works with stakeholders and DAE Data Governance team to ensure accuracy in reports and dashboards, data outputs and data integrations;
• Works with end-users to define and execute test scenarios and ensure appropriate end user training for Business Intelligence solutions;
• Develops query tools and/or SQL procedures to query complex data structures and perform basic analysis;
• Defines test schedules and documents procedures for the technical solutions required to resolve data maintenance and dissemination;
• Maintains report inventory, data dictionary, and data model;
• Develops, implements, and maintains Extract, Transform, Load (ETL) processes and data marts;
• Analyzes and develops projects associated with end-user reporting. Creates the approach for the implementation of a reporting / business intelligence platform, facilitates data cleansing and creates database management approaches;
• Works with a team of developers who provide functional and technical training, system organization, consultation and recommendations for managing end-user reporting;
• All computing is done in a network environment. The analyst will be familiar with database concepts and will develop knowledge of how the functions of the department are reflected in the databases;
• Responsible for obtaining required training in development tools to support DAE s reporting environment;
• Acts as subject matter expert and technical support resource for specific data sets;
• Works with the DAE Information System project team to troubleshoot issues related to required reports and other data dissemination;
• Other duties as required;

Consequence of Error/Judgement

Given that the incumbent will work with very sensitive data, including payment card information and donor personal information, the Programmer Analyst is expected to follow all UBC Information Security Standards, and to exercise judgment, diplomacy and tact in all interactions. Standards of customer service are essential. Errors in reports or data pulls could have serious negative implications. Errors in accuracy, judgement, or ethics could result in a significant and wide-spread loss of credibility and reputation for the University and its initiatives since DAE has such a large public outreach, with millions of communications each year. A privacy breach could potentially affect all of our alumni and donors, resulting in significant fines, and irreparable damage to key UBC relationships.

Supervision Received

Works with a high degree of independence under the direction of the Associate Director, Business Intelligence. Work is reviewed in terms of achievement of high professional standards and broad project objectives and goals. Can take direction from Senior Developers, Business Analysts or Project Managers.

Supervision Given

May manage work-learn and co-op students and be responsible for their hiring, evaluation, and termination.

Minimum Qualifications

• Undergraduate degree in a relevant discipline (Computer Science degree preferred)
• Minimum of three years experience or the equivalent combination of education and experience
• Two or more years working with complex SQL databases in an enterprise environment required
• At least 1 year of experience working with Business Intelligence tools such as Tableau Desktop Professional and/or Tableau Server, PowerBI, QlikView, Excel PowerPivot, OBIEE, etc.
• Experience writing complex SQL queries, working with SQL Server Reporting Services (SSRS), executing test scripts, and working with MS Visio, MS Project, and/or MS Visual Studio required
• Experience implementing or working with web services required
• Experience with SDLC and application lifecycle management required
• 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

• Developing database-driven .NET applications (VB or C#) required
• Experience with Team Foundation Server (TFS) or other team-based application development and source control tools an asset
• Knowledge of ITIL frameworks an asset
• Experience with QA/QC frameworks and methodologies an asset
• Experience architecting or designing relational databases and working with Relational Database Mangement Systems (RDBMS) tools an asset

---