IT Student - Business Applications and AI (Contract)

Orillia; Central Ontario; Hybrid; CAD 23,000 - 33,000; Full time

Job summary

The City of Orillia is seeking an IT Student - Business Applications and AI to assist in modernizing processes using Microsoft Power Suite and AI tools. You will work across IT and municipal departments, building no-code/low-code solutions and developing reports to support decision making.

This contract role offers flexible work arrangements, with up to two days per week from home, and a four-month term starting soon.

Qualifications

• Currently enrolled in, or a recent graduate from, a university program in Information Technology or Business with interest in IT.
• Strong knowledge of Microsoft Office, especially Excel and Word; familiarity with Teams, SharePoint, and Power Suite is an asset.
• Experience with AI concepts or courses is an asset.
• Excellent attention to detail, writing and communication, and ability to work independently and in a team.
• Ability to map workflows and document business processes for improvement.
• Valid Ontario G-class license with access to a vehicle.
• Criminal Record Check will be required at the employment start date.

Responsibilities

• Perform research and recommendations on IT topics including leveraging Office 365 for new processes.
• Build no-code/low-code tools using Microsoft Power Automate, Power Apps, Power BI, and SharePoint to streamline processes.
• Maintain the City’s AI data bank and update AI guidelines and reports.
• Prepare briefs, business cases, and presentations for senior management on IT strategy and products.
• Gather requirements and document existing processes; liaise with other municipalities for best practices.
• Collaborate with other business units to optimize and automate processes using BPM techniques.
• Design reports and conduct analysis using SQL queries, dashboards, and data migration tools.
• Provide IT support as part of the IT team.

Skills

Power Automate & Power Apps

Power BI

SQL

Communication skills

Teamwork

Education

University program in IT or Business

Tools

Power Automate

Power Apps

Power BI

SharePoint

Job description

IT Student - Business Applications and AI (Contract)

JOB DESCRIPTION The City of Orillia has an exciting opportunity for a University Student or a recent graduate in Information Technology (IT) or Business Student who will work directly with the Manager of Information Technology Services as an IT Student - Business Applications and AI in the Business Development, Tourism and Modernization Division of the Corporate Services Department. The emphasis for this position is to use modern technology such as the Microsoft Power Suite, AI tools etc. to improve and automate business processes and solve business problems. The position provides the opportunity to work across all disciplines within Information Technology and all municipal departments. The position will have the opportunity to build a network of vendor and municipal contacts. The City of Orillia does not use Artificial Intelligence in the hiring process. All job applications are reviewed personally by the appropriate Department/Division. This recruitment is to fill a seasonal/contract position.

DUTIES

• Perform research, make recommendations and converse with experts on a wide range of Information Technology topics including leveraging Office 365 for new and innovative business processes.
• Build no-code/low-code tools using Microsoft Power Automate, Power Apps, Power Bi, SharePoint lists or internal ERP workflow tools to streamline business processes.
• Maintain the City's Artificial intelligence (AI) data bank and update the AI Guideline and reports.
• Write briefs, prepare business cases and perform presentations to the Senior Management team regarding recommendations on future IT strategy, products and approaches.
• Gather business requirements and document existing business processes. Liaise with other municipalities to determine best practices.
• Work with other Business Units to optimize and automate business processes using Business Process Optimization techniques.
• Design custom reports and perform business analysis using tools such as SQL queries, Group Policies, PowerShell scripts and dashboards (e.g., Power BI) for business decision-making and data cleansing/migration.
• Perform Project Management Tasks including the documentation of requirements, and the installation of new equipment and software.
• Work as a member of the I.T. team to provide technical support to the organization.

QUALIFICATIONS

• Currently enrolled in, or a graduate of a University program with in one or more of the following fields of study: Computer Science, Information Management, Information Science, Computer Engineering Technology, or Business with a keen interest in information technology.
• Excellent knowledge of Microsoft Office products including excel and word. Familiarity with other Microsoft products such as Teams, SharePoint, and the Power Suite would be an asset.
• Artificial intelligence knowledge or completion of AI courses is an asset.
• Knowledge of research and forecasting techniques.
• Exceptional attention to detail, writing, interpersonal and communication skills with the ability to work independently and as a team.
• Experience charting workflows and flowcharts for process improvement.
• Must possess a valid class ‘G’ Ontario driver’s license with access to a reliable vehicle.
• The successful candidate will be required to provide a current and acceptable Criminal Record Check, at their expense, prior to the employment commencement date.

Compensation for this position is $20.24 per hour for up to 35 hours per week, with flexibility based on the successful candidate's availability during the contract period of approximately four months. This position provides the successful candidate with the flexibility to work from home up to two days per week. Interested candidates are invited to submit their application by October 23, 2026 at noon.

Note: The City of Orillia is committed to an inclusive, barrier-free environment. Accommodation will be provided in all steps of the hiring process. Please advise the City of Orillia Human Resources Department if you require any accommodations to ensure you can participate fully and equally during the recruitment and selection process. We thank all applicants that apply and advise that only those to be interviewed will be contacted. In accordance with the Municipal Freedom of Information and Protection of Privacy Act, personal information is collected under the authority of the Municipal Act 2001,S.O. 2001, c. 25., and will be used for the purpose of candidate selection. Questions about this collection should be directed to the Freedom of Information Coordinator, City of Orillia, 50 Andrew St. S., Orillia ON L3V 7T5