Position Title: Senior Data Systems Analyst
THE RIDLEY DIFFERENCE
Founded in 1889, Ridley College is a co-educational boarding and day school with over 700 students in JK to grade 12 from more than 50 countries worldwide. The Ridley experience integrates a traditional liberal arts education with individual learning enhanced by the principles of positive psychology, the International Baccalaureate continuum program, a learner-driven culture and campus community, exceptional athletics and dynamic arts programs, and a commitment of service to others. This unique combination prepares meaningful and flourishing lives by teaching the habits of mind, body and spirit, and the values needed to lead in a global society.
Ridley College is located on 90 acres in St. Catharines, Ontario in the heart of the Niagara Peninsula and is comprised of a stunning blend of century old buildings housing modernized technology.
Ridley offers the prospect of being part of a high-performance team in a nourishing workplace community that encourages collaboration, innovation, inclusivity and curious minds, and where grit and perseverance are assets. Joining the team at Ridley means you are committed to life-long learning and development, have integrity, and value being of service in a richly diverse community. We cultivate the full potential in each of our students by having a caring, committed and world-class team. Attracting, developing and retaining people who thrive in Ridley’s positive education culture that recognizes and celebrates individual strengths is critical to our success.
Ridley College is looking for a full-time Senior Data Systems Analyst to oversee, and participate in, the processes for accurate data collection, processing, modeling, and analysis of the school’s database systems.
Technical lead in the design, build, configuration, maintenance, capacity planning & security of the school’s database services, middleware & third-party applications that support academic, athletic and business needs;
Provide data modeling solutions that support strategic decisions and uncover optimization opportunities; Document and recommend options that support business decisions, ensuring the identification of any business impacts, risks and mitigation strategies;
Monitor and assess the overall health and performance of the school’s database systems by proactively analyzing systems, logs, and exception reports to generate and support KPIs. Collaborates with IT team members to develop innovative solutions to meet need identified by the KPIs;
Oversee and manage data in Ridley’s Blackbaud CORE and associated modules as well as lead the installation of critical upgrades as required;
Ensure the coordination and management of efficient data flow and essential integration across the school’s data platforms (Blackbaud, Proof, MS, etc.);
Support the data recovery disaster plan ensuring there are regularly scheduled and performed database back-up and recovery operations; regularly review the data recovery policies and procedures to identify opportunities for improvement;
Alongside the Database Analyst, monitor and maintain the security of database systems by writing procedures, functions and triggers to control the flow of data, monitoring logs and reviewing system access privileges, allocating disk space for users, creating and maintaining users, user permissions, system privileges, and passwords, and performing other administrative tasks at the operating system level;
Handles database incidences by delivering a resolution; Perform cause analysis as well as recommend and implement preventative techniques and applicable corrective action plans;
Collaborates on and develops complex queries, ad-hoc forms and reports in support of department operations, requirements, and staff needs;
Develops and maintains adequate system-related documentation to facilitate implementation and/or adoption of system changes;
Design and conduct presentations regarding available data and data analysis techniques to school leaders, faculty, and staff to support the department’s vision of becoming data informed organization;
Implement appropriate database settings and configurations to ensure compliance of provincial laws and school board policy in the area of information systems;
Research industry standard guidelines & best practices for database & applications management; reading professional publications; maintaining personal networks; participating in professional organizations, communities and annual conferences;
Work with vendors, consultants, and contractors to resolve issues when required;
Develop and regularly maintain vendor relationships to stay abreast of new products or product enhancements that will aid in the development and execution of the IT project roadmap;
Ensure the ongoing protection and integrity of the school’s information technology assets.
Post-secondary diploma or university degree in computer science or related discipline;
5+ years related experience performing database administration functions;
At least one relevant industry certification/designation such as Azure Fundamentals, Microsoft SQL, etc., is preferred;
Advanced understanding of MS SQL Server, Advanced Analytics, Microsoft Azure Database products and Microsoft Office (Excel);
Proficient in one programming language (preferably Python with Pandas/NumPy experience);
Scripting experience with Powershell for MS Office 365, MS Teams and Azure AD is an asset;
Previous experience in the administration of the Blackbaud application with a strong focus on K-12 Core, Raiser’s Edge, EMS, TMS, SIS and LMS, including scheduling and report cards, is highly preferred;
Strong knowledge of visualization tools such as PowerBI;
Ability to perform complex research, analysis, and reporting of large datasets on a wide range of operational and programmatic subjects;
Hands on experience creating data dashboards, reports, and visualizations to highlight trends and strategic opportunities/progress;
Proven experience identifying potential data anomalies by performing regular data audits that check data integrity, quality, retention and backup;
Knowledge of project management methodologies/process such as requirements management, analysis and design, testing, implementation, deployment, change configuration, and management, etc.
Ridley College offers a positive and inclusive workplace community with a competitive compensation package; innovative, challenging and rewarding opportunities; a learning environment that promotes professional development and personal growth; active community involvement; and, a beautiful campus setting in the heart of Niagara that engages and inspires our employees to flourish.
Qualified applicants are encourages to upload their application here.
Position will be posted until it is filled.
As a condition of employment, a satisfactory Vulnerable Persons Screening Report must be provided. While all applicants are thanked for their interest, only those chosen for interviews will be contacted.
Ridley College is committed to fostering an inclusive, accessible and equitable environment where everyone feels respected, valued and supported. Accommodations are available for applicants with disabilities throughout the recruitment process. If you are selected to participate in the recruitment process, please inform Human Resources of the nature of any accommodation(s) that you may require in respect of any materials or processes used in order to ensure your equal participation.
“We inspire flourishing lives to transform our globe.”
- Day & Boarding School
- St. Catharines