![UBC](https://www.energyjobline.com/sites/default/files/styles/squared_logo/public/job-logo/get-logo.php__312744.png?itok=tLK5MbQl)
Programmer Analyst
1 month ago
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, 2024Note: 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
-
Programmer/Analyst
2 months ago
Vancouver, British Columbia, Canada PHSA Full timeJob Summary:The Programmer/Analyst develops and maintains complex new and existing clinical and business application systems within IM/IT which impact several functional areas throughout the PHSA. The Programmer/Analyst designs, programs, tests and implements clinical and business applications as well as maintaining application code. The Programmer/Analyst...
-
Programmer Analyst II
1 month ago
Vancouver, British Columbia, Canada UBC Full timeStaff - Non UnionJob CategoryM&P - AAPSJob ProfileAAPS Salaried - Information Systems and Technology, Level DJob TitleProgrammer Analyst IIDepartmentUBC IT | Academic Systems | TechnicalCompensation Range$8, $12,952.33 CAD MonthlyThe Compensation Range is the span between the minimum and maximum base salary for a position. The midpoint of the range is...
-
Senior Programmer Analyst
7 hours ago
Vancouver, British Columbia, Canada UBC Full timeStaff - Non UnionJob CategoryM&P - AAPSJob ProfileAAPS Salaried - Information Systems and Technology, Level EJob TitleSenior Programmer AnalystDepartmentTechnical | Delivery | Leadership | Integrated Renewal Program Student | Enrollment and Academic Facilities | Integrated Renewal Program StudentCompensation Range$9, $15,380.75 CAD MonthlyThe Compensation...
-
Programmer Analyst II
6 days ago
Vancouver, British Columbia, Canada The University of British Columbia Full timeJob SummaryThe University of British Columbia seeks a highly skilled Programmer Analyst II to design and develop complex computer application solutions for existing systems within the Faculty of Arts. This role will involve providing web services and application support for various departments, schools, and units, serving faculty, staff, and students across...
-
Programmer Analyst
3 weeks ago
Vancouver, British Columbia, Canada Pantheon Design Ltd Full timePosition OverviewPantheon Design Ltd is seeking a skilled Software Developer to join our dynamic team. This role involves creating and enhancing software applications to meet the needs of our clients.Educational BackgroundBachelor's degree in a relevant fieldFocus on Computer Science or Software EngineeringKey ResponsibilitiesDevelop, modify, and test...
-
GIS Programmer/Analyst
1 month ago
Vancouver, British Columbia, Canada City of Vancouver Full timeGIS Programmer/AnalystRequisition ID: 41949 OrganizationLocated on the traditional, ancestral and unceded lands of the xwməθkwəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səlilwətaɬ (Tsleil-Waututh) Peoples, Vancouver has a commitment to becoming a City of Reconciliation. Vancouver consistently ranks as one of the world's most liveable cities...
-
Business Systems Analyst
6 hours ago
Vancouver, British Columbia, Canada UBC Full timeStaff - Non UnionJob CategoryM&P - AAPSJob ProfileAAPS Salaried - Information Systems and Technology, Level DJob TitleBusiness Systems AnalystDepartmentTechnical | Delivery | Leadership | Integrated Renewal Program Student | Enrollment and Academic Facilities | Integrated Renewal Program StudentCompensation Range$8, $12,952.33 CAD MonthlyThe Compensation...
-
Analyste de réclamations immobilières
11 hours ago
Vancouver, British Columbia, Canada Intact Full timeÀ propos du posteNous recherchons un Analyste de réclamations immobilières pour rejoindre notre équipe de stratégie et de transformation des réclamations dans l'Ouest.En tant qu'Analyste de réclamations immobilières, vous utiliserez vos connaissances techniques et votre expérience d'ajustement pour effectuer des examens de dossiers internes de...
-
Analyste de réclamations immobilières
24 hours ago
Vancouver, British Columbia, Canada Intact Full timeÀ propos du posteNous recherchons un Analyste de réclamations immobilières pour rejoindre notre équipe de stratégie et de transformation des réclamations dans l'Ouest.En tant qu'Analyste de réclamations immobilières, vous utiliserez vos connaissances techniques et votre expérience d'ajustement pour effectuer des examens de dossiers internes de...
-
Core Operations Business Analyst
3 weeks ago
Vancouver, British Columbia, Canada BC Centre for Excellence in HIVAIDS Full timeCore Operations Business Analyst BC Centre for Excellence in HIV/AIDS IMPORTANT NOTE: Only Canadian Citizens, legal residents or residents with a legal work permit will be considered. POSITION STATUS: This is a temporary full-time role with potential for extension. COMPENSATION: $67, $93,310.80 LOCATION: BC Centre for Excellence in HIV/AIDS ...
-
Lead Software Integration Analyst
3 weeks ago
Vancouver, British Columbia, Canada British Columbia Lottery Corporation Full timeAbout BCLC BCLC is dedicated to creating positive outcomes for our stakeholders. Lottery | Casino | Sports As a socially responsible organization, we align our operational strategies with our mission to contribute to a better society. Our commitment is reflected in our actions, which aim to generate benefits for communities and the environment. We invite...
-
Actuarial Analyst
4 days ago
Vancouver, British Columbia, Canada Intact Full timeAnalyseur Actuariat - Rejoignez notre équipe en croissance Nos employés sont au cœur de ce que nous faisons de mieux : aider les gens, les entreprises et la société à aller de l'avant dans les bons moments et à être résilients dans les moments difficiles. En vous joignant à notre équipe, vous contribuerez à ces efforts aux côtés de gens...
-
Technical Program Manager
1 day ago
Vancouver, British Columbia, Canada Hengam Full timeAbout the RoleWe are seeking a highly skilled Technical Program Manager to join our team at Hengam. As a Technical Program Manager, you will be responsible for leading IT projects and ensuring their successful delivery.Key ResponsibilitiesProject Management: Assign IT projects to systems analysts, programmers, and other computer technicians, and coordinate...
-
IT Project Lead
1 day ago
Vancouver, British Columbia, Canada Hengam Full timeAbout the RoleWe are seeking a highly skilled Technical Program Manager to join our team at Hengam. As a Technical Program Manager, you will be responsible for leading IT projects and ensuring their successful delivery.Key ResponsibilitiesProject Management: Assign IT projects to systems analysts, programmers, and other computer technicians, and coordinate...
-
Technical Lead
12 hours ago
Vancouver, British Columbia, Canada BCLC Full timeJob Summary:The Senior Programmer Analyst will work with the Lottery Games Team to build, deploy, and support Integration services in BCLC's Lottery platform. This role will proactively resolve complex technical issues and use innovative thinking in the development and delivery of solutions and broader issues resolution.Key Responsibilities:Perform...
-
Property Claims Analyst
2 days ago
Vancouver, British Columbia, Canada Intact Full timeNos employés au cœur de notre mission Nos employés sont la clé de notre succès. En rejoignant notre équipe, vous contribuerez à aider les gens, les entreprises et la société à prospérer dans les moments difficiles et à être résilients dans les moments difficiles. Un environnement de travail stimulant Nous offrons un milieu de travail où vous...
-
Analyste en Planification des Effectifs
3 weeks ago
Vancouver, British Columbia, Canada Intact Financial Corporation Full time $51,600 - $77,400Chez Intact, nos collaborateurs sont au cœur de notre mission : soutenir les individus, les entreprises et la société dans les moments favorables et les périodes difficiles. En intégrant notre équipe, vous participerez à ces initiatives aux côtés de professionnels expérimentés et passionnés.Nous offrons un environnement où vous aurez accès aux...
-
Technical Project Management Lead
3 weeks ago
Vancouver, British Columbia, Canada Hengam Full timePosition OverviewWe are seeking a dedicated Technical Program Manager to oversee and coordinate various IT initiatives at Hengam. This role is crucial in ensuring the successful implementation and management of technology projects within our organization.QualificationsEducation: Master's degree in a relevant field.Experience: A minimum of 5 years in a...
-
IT Program Management Specialist
3 weeks ago
Vancouver, British Columbia, Canada Hengam Full timePosition OverviewWe are seeking a skilled Technical Program Manager to oversee and guide our IT initiatives at Hengam. This role involves a blend of strategic planning, project management, and team leadership to ensure successful implementation of technology solutions.QualificationsEducation: Master’s degree in a relevant field.Experience: A minimum of 5...
-
Electrical Engineer
1 day ago
Vancouver, British Columbia, Canada ENERGEX Full timeAbout the RoleWe are seeking an experienced Electrical Engineer to join our team at ENERGEX. As an Electrical Engineer, you will play a key role in the design, development, and operation of our electrical generation and distribution networks.Key ResponsibilitiesDesign and Development: Conduct feasibility studies, design operation and performance research of...