Senior Programmer/Database Administrator - Initiatives/Opportunities

fanshawec; London; Hybrid; CAD 57,000 - 66,000; Full time

Benefits offered by this job

Comprehensive Pension & Benefits

Vacation and holiday closure

Tuition & Professional Development

Inclusive campus environment

Job summary

Fanshawe College is seeking a capable Initiatives/Opportunities role to support the Phase 3 Enterprise Resource Planning Student Information System migration. You will analyze, design, and implement data integrations, reports, and interfaces while collaborating with stakeholders across campus.

Under the Director of Enterprise Solutions, you will provide senior programming, systems analysis, design and database administration expertise, and mentor team members while ensuring project timelines and

Qualifications

• 3 year diploma/degree in Computer Programming, Computer Science, Software Engineering, Information Technology or related field
• Minimum five years computer programming experience including at least three years experience in project management, systems analysis, systems design
• Minimum five years ASP.NET, VB.NET, XML programming experience
• Five years experience with SQL Server, SSIS, and SSRS
• Experience with PowerBI, Salesforce, Workday a plus

Responsibilities

• Analyze processes, systems and programs to resolve problems and improvements
• Gather user requirements and develop design solutions
• Collaborate with end-users in requirements gathering and release management
• Review and QA system changes (code, configuration, scripts)
• Develop and maintain enterprise database interfaces (APIs, ETLs)
• Ensure data backup and recovery procedures are in place

Skills

Analytical thinking

Problem solving

Organizational skills

Communication skills

Stakeholder management

Education

3 year diploma/degree in Computer Programming, Computer Science, Software Engineering, Information Technology or related field

Tools

PowerBI

Salesforce

Workday

VBScript

JavaScript

Job description

Interested in growing your career at Fanshawe College?

Fanshawe College thrives because of its people. We foster a culture of excellence and see opportunities to turn potential into impact. Leading with empathy, belonging, unity, learning and courage, we guide the learning journey of our students, ensuring they are ready for work and life, today and tomorrow.

Working at Fanshawe College

Fanshawe College is committed to the principles of hybrid work and may offer this option to employees whose work can be performed in an alternate location, without adverse impact to the operations of the College, inclusive of our Student and Staff experience. Confirmation of hybrid work options available to you will be clarified upon hire and may be subject to change based on the duties required of your position. Successful candidates will be required to perform work within Ontario and must be available to work on campus, as required.

Posting Closing Date: October 6, 2026

Campus Location: London, ON

Department: ISS1 Information Systems Services

Employment Group: Support

Pay Details: $41.20 Hourly

Worker Sub-Type: Fixed term (Fixed Term)

Time Type: Full time

Remote Type: Hybrid

Contract End Date: July 31, 2028

Hours of Work per Week: 35

Job Description

Note:Previous applicants need not re-apply for this position. Your previously received application will be considered.

This position is an Initiatives/Opportunities position and is subject to the terms of the Full-Time Support Staff Collective Agreement aside from Article 15.

Note: One Temporary Full-Time vacancy is available with a contract duration of 2 years from the date of hire. This position is deemed a critical vacancy.

Payband: $41.20 - $47.57 per hour(Payband I)

Hours: Monday to Friday, 8:30 a.m. to 4:30 p.m.; Averaging of hours applies according to the Support Staff Collective Agreement (Appendix C)

Work Mode: Hybrid - This position requires minimum 1 day onsite per week.

Why this Role isImportant

This role will be dedicated to supporting the implementation of Phase 3 – Student of the colleges Enterprise Resource Planning Student Information System Migration. The analysts will help support key initiatives regarding the conversion, migration, integration and reporting of data from legacy to future systems.

Under the supervision of the Director, Enterprise Solutions, provides senior programming, systems analysis, systems design and database administration expertise in the development and support of the College's information systems; provides training and support to Programmer/Analysts and Programmers as needed.

HowYou’llMake anImpact

Project Management, Systems Analysis and System Design

• Analyzes processes, systems and programs to resolve problems and introduce enhancements
• Reviews existing processes and develops an understanding of user requirements
• Identifies alternative solutions and makes recommendations to Manager or end users to meet the requirements
• Designs complex systems
• Prepare programming specifications
• Provides project management involving project teams
• Collaborates extensively with end-users in requirements gathering, prototyping and release management

Programming and Code Review

• Performs quality assurance by reviewing, testing, and approving system changes (code, configuration settings, scripts) by Programmer/Analysts and Programmers
• Accountable for programmer compliance in documenting activity, changes, and tasks in application life cycle management tools (ie. Team Foundation Server)
• Codes/Programs to approved specifications

Database Developer and System Integration

• Creates and manages database objects
• Subject Matter Expert for enterprise database schemas, entities, attributes, and objects
• Responsible for query and modifying data
• Creates and manages stored procedures, functions, and triggers
• Accountable for optimizing system performance and integrity
• Designs, Develops, Tests, Deploys, and Maintains supported enterprise database interfaces (ie. APIs, ETLs and batch interfaces for systems such as Colleague)
• Ensures users have appropriate system and database access
• Ensures appropriate database back-up and recovery procedures are in practice

WhatYou’llBring

• 3 yeardiploma/degree in Computer Programming, Computer Science, Software Engineering, Information Technology or related field
• Minimum five years computer programming experience including at least three years experience in project management, systems analysis, systems design
• Minimum five years ASP.NET, VB.NET, XML programming experience
• Mandatory five years experience with SQL Server, SQL Server Integration Services, and SQL Server Reporting Services
• An equivalent combination of education and experience may be considered
• Experience with PowerBI, Salesforce, Workday, VBScript and JavaScript would be an asset
• Advanced analytical and problem-solving abilities
• Strong organizational and prioritization skills, with the ability to manage competing priorities and lead multiple initiatives
• Demonstrated ability to work independently and foster collaboration across teams including training and supporting of team members
• Excellent verbal and written communication skills
• Ability to build strong relationships with stakeholders and effectively gather, clarify, and translate business requirements into technical solutions

What This Opportunity Offers

• Comprehensive Pension & Benefits: Join a defined-benefit pension plan(through the CAAT Pension Plan)that delivers predictable lifetime retirement income, plus dental, disability, travel insurance and extended health coverage.
• Vacation:Enjoy paid time off and benefit from a scheduled holiday closure that offers additional rest and time with family during the winter season
• Tuition & Professional Development: Continue your learning journey - eligible employees and their dependents can take select Fanshawe programs or courses at a reduced cost
• Inclusive, Meaningful Campus environment: Work alongside passionate colleagues in an inclusive culture that values diversity, drives student success, and connects you to the local community and campus life.

Fanshawe College uses Workday to manage recruitment and hiring processes.

Educational Credentials

While transcripts are not required for the interview, they are mandatory as a condition of employment.

Equity, Diversity and Inclusion

Fanshawe College is an equal opportunity employer. We are committed to equity, value diversity, and welcome applicants from diverse backgrounds.

Accommodation

Fanshawe College provides accommodations to job applicants with disabilities throughout the hiring process. If a job applicant requires an accommodation during the application process or through the selection process, the hiring manager and the recruiter leading the recruitment will work with the applicant to meet the job applicant’s accommodation needs. Accommodation requests per the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act can be emailed to: [e-mail]

Land Acknowledgement

Fanshawe College would like to acknowledge and honour the Anishinaabe, Lotinuhsyuní and Lenape people of southwestern Ontario as the traditional owners and custodians of the lands and waterways where Fanshawe College is located.

We thank all applicants for their interest; however, only those chosen for an interview will be contacted.