Data Systems and App Development Specialist

Founded in 1879, Lakefield College School is a leader among Canada’s independent boarding and day schools and prides itself on its reputation for providing a strong, caring community, a well-rounded program, and a transformational student experience on one of the largest waterfront campuses in the country. Of our total student population of 400, we have 270 students who live on campus, coming from over 45 countries. LCS is a coeducational high school committed to its mission of challenging and enabling students to reach their individual potential in mind, body, and spirit.

A challenging academic program prepares our high school students to pursue their post- secondary passions in a variety of fields. Our spectacular 315-acres campuses, located just 1.5 hours northeast of Toronto, allow students to be outdoors every day, enjoying a variety of sports, arts, co-curricular programs and experiential learning opportunities across the curriculum. Lakefield College School has a proud 141-year history of educating some of Canada's finest young leaders. Our graduates go on to successful careers in all aspects of business, politics, social services, academia, and the arts. We are particularly proud to have been the alma mater for His Majesty King Felipe VI of Spain and four Rhodes Scholars.

Position Summary

The Data Systems & App Development Specialist identifies, creates, manages, enhances, designs & develops databases, their structures and processes to ensure the efficient and effective implementation of data architecture at LCS and in the cloud. This role involves providing resources and building practices to support the academic and non-academic data portfolio of the school. This individual will architect, design, and maintain scalable cloud infrastructure solutions. This individual will be expected to facilitate successful large-scale data migrations, while working on multiple concurrent initiatives.

Responsibilities:

Develop, test and deploy front-end and back-end database solutions (including, but not limited to MS SQL, MySQL, SQL Server Integration Services, Relational and Non- Relational Databases) both locally and in the cloud. This will involve creating tables, views, indexes, partitions, developing stored procedures, functions, triggers, and more.

Duties include:

• Develop and maintain custom applications, to support innovation and new initiatives

• Analyze existing applications, document the current processes and perform impact analysis

• Documentation of current processes and newly added processes and up-keeping of Data Dictionary

• Develops an overall understanding and capacity to use our database systems, processes and dependencies

• Designs queries and reports as requested

• Prepares users by conducting training, providing information, resolving problems, building awareness of processes

• Builds capacity among colleagues to access data independently with the goal of creating a sustainable organization or structure

• Takes responsibility for the management of any incoming data by creating input structures and developing appropriate workflows

• Working closely with the Director of Information Systems, the candidate will ensure data integrity during any transitions

• Ensure timely synchronization of data resources

• Maintains content integrity of the database by verifying entered data by reviewing, correcting, deleting, or re-entering data; combining data from various systems to eliminate duplication of data

• Aligns with the school’s strategic vision, goals, initiatives, and plans

Skills/Education:

• A degree or diploma in Computer Science, Information Technology, or a related field to perform duties as a Database Specialist, Developer and Cloud Architect

• Experience working with database development both locally and in the cloud

• Experience with creating libraries and frameworks to design and implement APIs

• Thorough understanding of relational and non-relational database structures

• Experienced in creating database structures with MS SQL, MySQL, and SQL Server integration services

• Interpersonal savvy with the ability to maintain confidentiality and discretion

• Comfortable and flexible in researching and learning new products, processes, skills and competencies

• Excellent time management, problem-solving, and communication skills

Technical Requirements

• Professional experience working with Google Cloud, G-Suite and AWS

• Professional experience working with databases, preferably in an academic environment

• Knowledge of Windows Server and Linux environments

• Comfortable with working on both Mac and Windows operating systems

• Coding experience with PHP, Node.js, ASP, and/or Python

Schedule:

• Monday to Friday, 8:30 – 4:30

Why LCS?

You’ll have the opportunity to work with some of the most enthusiastic staff members you’ve ever met. You’ll witness all of the things that make the best boarding schools great. You’ll become part of a community. But more importantly, you will grow. You’ll do challenging work you love and be part of a success story that you can be proud of.

How to apply:

Please complete your profile and submit your resume information through the Careers Section of our website on or before October 11, 2021.

Please Note: LCS is committed to providing accommodation for persons with disabilities. Please visit our Accessibility page for further details or contact our Human Resources department, hr@lcs.on.ca, for any information in an alternate format.

Lakefield College School is an inclusive, caring community. We believe in the dignity and worth of all individuals. We embrace diversity and practice equity. We lead with empathy to create a sense of belonging for all. We are committed to equal employment opportunities for persons of all cultures, colours, ancestries, religions, sexes, national origins, sexual orientations, ages, marital statuses, disabilities, gender identities and veteran statuses. 

We respectfully acknowledge that Lakefield College School is located on the Treaty 20 Michi Saagiig territory and in the traditional territory of the Michi Saagiig and Chippewa Nations, collectively known as the Williams Treaties First Nations, which include: Curve Lake, Hiawatha, Alderville, Scugog Island, Rama, Beausoleil, and Georgina Island First Nations.

Lakefield College School respectfully acknowledges that the Williams Treaties First Nations are the stewards and caretakers of these lands and waters in perpetuity and that they continue to maintain this responsibility to ensure their health and integrity for generations to come.