Senior Systems Development Analyst, VP Development and Alumni

Description

VP Development and Alumni is currently seeking a Full-time Temporary Senior Systems Development Analyst for approximately 3 months.

The Office of Development and Alumni exists for the mutual benefit of the University of Calgary and its stakeholders and coordinates donations of gifts to the University, as well as engagement with UCalgary alumni and the broader community.

Reporting to the Manager, Data Systems, the Senior Systems Development Analyst is responsible for supporting the development, maintenance and error-free operation of Development and Alumni's core business system applications that are used by more than 200 individuals across campus for the purpose of managing information and relationships with donors, alumni, and other key stakeholders. This position also ensures data and systems integrity and works with business users throughout Development and Alumni to gather and respond to highly technical requirements. The work done by the incumbent is very complex and requires significant in-depth knowledge and expertise, as it directly impacts the functionality and operations of  Development and Alumni's primary technologies.

The incumbent develops complex SDK customizations impacting the core integrity of these systems, leads data quality management, oversees the implementation of APIs, and develops ETL processes for the import and extraction of meaningful data. The Senior Systems Development Analyst liaises regularly with key stakeholders across the department, gathers business requirements, builds and implements solutions, and mentors more junior team members.

Current Regular, Sessional or Recurring Part-time (RPT) Support Staff applying on this Temporary position are strongly encouraged to review Article 42.06 - Job Opportunities of the University and AUPE Local 052 collective agreement. In advance of accepting a Temporary position, affected employees are required to seek written confirmation from their manager as to whether their Regular, Sessional or RPT position will be available to return to at the conclusion of the temporary assignment.

Summary of Key Responsibilities (job functions include but are not limited to):

• Work with key business and technical staff across Development and Alumni to gather complex business requirements and propose and develop innovative solutions to problems.
• Program advanced C# and other scripts to improve system effectiveness and user functionality.
• Develop integrations between a variety of Development and Alumni technologies, including Blackbaud (BB) CRM, BB Information Systems, and Marketo, among others.
• Work with data stewards to ensure access to information and the interpretation of data is accurate.
• Provide advanced level support for technical problems.
• Lead projects with multiple stakeholders and provide guidance/oversight to more junior Data Team staff.
• Build and perform database and ETL tasks, as well as provide support to the Analytics & Reporting team.
• Develop, monitor, and maintain automated processes.
• Guide Development and Alumni's technological infrastructure and use outside of UCalgary IT accountabilities. Ensure that application and system development follow proper University and departmental standards and procedures.
• Identify needs and problematic areas and establish data maintenance query schedules and automation.
• Create data quality and other reports in Power BI and/or SSRS.
• Identify linkages and interdependencies within and between systems so that downstream effects of all changes are accounted for.
• Analyze and resolve issues with current and planned systems for Development and Alumni and its stakeholders.
• Identify and initiate opportunities to streamline operations and improve efficiency and effectiveness.

Qualifications / Requirements:

• Post-secondary education in IT or data with 5 or more years of advanced experience with relational databases and software development.
• Additional certification in business intelligence and analytics is strongly desired.
• Previous progressive experience using Blackbaud CRM is required, particularly within a University environment.
• Business analysis experience/working with business users is required.
• Excellent knowledge of relational database management concepts and experience with relational database management systems are required.
• Very strong programming skills in C# or VB.Net and other current technologies are required, as is significant experience with software development and in designing, building, and implementing customizations in enterprise systems.
• Experience with managing IT changes, release management, process mapping and software testing is preferred, including experience with Jira and ServiceNow platforms.
• Advanced knowledge of Microsoft Office and SQL Server suites, along with Power BI.
• Good working knowledge of MS Teams is desirable.
• Accuracy and attention to detail are essential, with the ability to spot errors and inconsistencies in data and reports.
• Knowledge of data management and data extraction's best practices, with experience in ETL processes (Extraction, Transform and Loading).
• Experience in problem-solving and troubleshooting in a team environment.
• Strong aptitude to understand new technologies and processes and to learn and use other tools as required.
• Extensive experience supporting Blackbaud CRM in a University environment is critical for this role.

Application Deadline:  October 2, 2024.

We would like to thank all applicants in advance for submitting their resumes. Please note, only those candidates chosen to continue on through the selection process will be contacted.

This position is part of the AUPE bargaining unit, and falls under the Technical Job Family, Phase 2.

For a listing of all management and staff opportunities at the University of Calgary, view our Management and Staff Careers website. 

About the University of Calgary

UCalgary is Canada's entrepreneurial university, located in Canada's most enterprising city. It is a top research university and one of the highest-ranked universities of its age. Founded in 1966, its 36,000 students experience an innovative learning environment, made rich by research, hands-on experiences and entrepreneurial thinking. It is Canada's leader in the creation of start-ups. Start something today at the University of Calgary. For more information, visit ucalgary.ca.

The University of Calgary has launched an institution-wide Indigenous Strategy committing to creating a rich, vibrant, and culturally competent campus that welcomes and supports Indigenous Peoples, encourages Indigenous community partnerships, is inclusive of Indigenous perspectives in all that we do.

As an equitable and inclusive employer, the University of Calgary recognizes that a diverse staff/faculty benefits and enriches the work, learning and research experiences of the entire campus and greater community. We are committed to removing barriers that have been historically encountered by some people in our society. We strive to recruit individuals who will further enhance our diversity and will support their academic and professional success while they are here. In particular, we encourage members of the designated groups (women, Indigenous peoples, persons with disabilities, members of visible/racialized minorities, and diverse sexual orientation and gender identities) to apply. To ensure a fair and equitable assessment, we offer accommodation at any stage during the recruitment process to applicants with disabilities. Questions regarding [diversity] EDI at UCalgary can be sent to the Office of Equity, Diversity and Inclusion ([email protected]) and requests for accommodations can be sent to Human Resources ([email protected]).

Do you have most but not all the qualifications? Research show that women, racialized and visible minorities, and persons with disabilities are less likely to apply for jobs unless they meet every single qualification. At UCalgary we are committed to achieving equitable, diverse, inclusive and accessible employment practices and workplaces and encourage you to apply if you believe you are right for this role. 

We encourage all qualified applicants to apply, however preference will be given to Canadian citizens and permanent residents of Canada.