Opportunities (3 positions)

Fanshawe Toronto@ILAC•London, ON

6d•CA$40 - CA$47•Hybrid

About The Position

This role is dedicated to supporting the implementation of Phase 3 – Student of the college's 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.

Requirements

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, SQL Server database administration, SQL programming
Minimum five years ASP.NET, VB.NET, XML programming, Envision, Unidata and Uniobjects experience
An equivalent combination of education and experience may be considered
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

Nice To Haves

Experience with PowerBI, Salesforce, Workday , VBScript and JavaScript would be an asset

Responsibilities

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
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
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
Other Duties as Assigned

Benefits

Comprehensive Pension & Benefits
Defined-benefit pension plan (through the CAAT Pension Plan)
Dental coverage
Disability coverage
Travel insurance
Extended health coverage
Paid time off
Scheduled holiday closure (winter season)
Tuition & Professional Development
Reduced cost for select Fanshawe programs or courses for eligible employees and their dependents
Competitive compensation
Comprehensive Benefits Package
Defined benefit pension plan
Generous vacation and holiday entitlements
Full-time employees start at a minimum of 3 weeks of vacation per year
Prepaid leave/salary deferral plan
Subsidized maternity and parental leave
Family tuition program
Flexible work policy
Employee and Family Assistance Program
Corporate Discounts through CAUBO
Professional development and training opportunities
Tuition reimbursement and subsidy programs
Professional development leave
LinkedIn Learning
Lifetime retirement pension