Working closely with the Director of Technology and IT manager, the Senior Data Systems Engineer is responsible for planning, implementing, creating data systems that support and facilitate the school’s technological vision. Provide guidance and mentorship for the IT support team, while providing a high level of support and best practice knowledge to administrators and teachers in accordance to the learning goals of the school. The Senior Data Systems Engineer’s role is to develop and implement and support data systems across the organization, ensuring high levels of data availability, integration and automation. The Senior Data Systems Engineer is responsible for leading and developing ongoing data integration initiatives, data exchange between various systems, and the automation of data exchange. The Senior Data Systems Engineer will in addition evaluate and advise on all technology components, such as software, hardware, and networking capabilities, for data systems and applications.

• Data Systems Integration: Point-to-point data integration between security, website/portals, SMS, Canteen Point of sales and Library database systems. Develop and maintain SQL export from Student Information System to remote server folder, batch script to move csv files to a folder on the destination server.
• Database administration:
  • Manage regular backup and restore of database systems: Ensure database and data system backups are running daily on production server. Restore backups on a sandbox server before restoring on production.
  • Manage technical database extension works: Create customizations and added functionalities to the student information system and extend the student information system database schema to create new tables.
  • SSIS Package creation: Create SSIS packages to schedule tasks within the MS SQL Management studio. Extract filed data into a csv file that is imported into the student information system
  • Write extensive and complex SQL queries in both Oracle DB and MS DB: Apply advanced level SQL skills in both Oracle and MS DB servers in order to create/update reports/dashboards.
  • Develop robust, reliable hands-off automations of common, frequent and repeated data integration, exchange and business routines
  • Always ensure data security and privacy
  • Create data visualizations dashboards
• Web Development
  • jQuery framework – exercise advanced skills in using jQuery to manipulate the DOM
  • Front End: HTML, CSS, JavaScript, both AngularJS and Angular 2
  • API: Create and manage data exchange with third parties via API
  • Back End: Program in PL/SQL, T-SQL and PHP coupled with the frameworks listed above.
  • Apache Web Server: Maintain and manage SSL certification, patches and the relevant modules needed to run the successful web requests.
  • Create plug-ins and applications within the current Student Information System to perform specific functions.
  • Create customized data entry screens to collect and streamline data entry from various system users
• Student Information System (PowerSchool) Administration

Process and support:

• • Years and terms
  • User account and data management, permissions and security
  • Scheduling, grading and report cards
  • Plugin management
  • Document Management System
  • Training: Empowering system users to be self-reliant in using the systems for regular, repeated tasks with little or no supervision
  • Process automation: Continuously look to automate tasks that can be done by the system to save time, increase efficiency, accuracy and reliability.
  • Work with the Admissions team to support the admissions/enrolment system integration with SIS
  • Continually develop, refine and improve the year-on-year (beginning & end) student data processes built inside the SIS, such as annual re-enrolment
  • Create and maintain custom pages and plugins for data systems
• General data systems responsibilities:
  • Lead the integration of various complex data systems
  • Plan, design, and implement identified special projects for the school
  • Oversee the evaluation of data system performance and recommend improvements where needed
  • Coordinate the troubleshooting and the support calls with external providers
  • Coordinate the creation of new database extensions to accommodate data entry
  • Design and oversee data table structures, forms, reports, and queries
  • Lead the development of reports and queries to support business needs
  • Manage the development and updating of technical and functional documentations for required data systems
  • Coordinate the development and updating of Standard Operating Procedures for data systems
  • Perform root cause analysis of complex system problems and provide corrective action
  • Participate in regular staff meetings, staff training programs, supervisory sessions
  • Take responsibility for the development of positive team relationships as requested
  • Work with the IT Manager to identify single points of failure and to develop and maintain Disaster Recovery plans
  • Make recommendations to the IT Manager on budget items
  • Make recommendations to the IT Manager for improving data-related processes
  • Perform and support other tasks as identified by the Director of Technology

Required Qualifications

Matric Certificate

ITIL

MCSE BI, MCSE Data Analytics

BSc degree in Computer Science or relevant field

Preferred Skills and Experience

• At least five (5) years expert/advanced level skills and experience:
• PL/SQL and T-SQL
• Oracle SQL Developer
• Oracle APEX and SQL reporting
• Microsoft Excel (E.g. Vlookups, pivot tables)
• JavaScript, HTML/HTML5, and XML web development
• MS SQL Server, SSIS, SSAS, SSRS
• Data modeling
• Active Directory administration and integration
• Analytical and design skills
• Project management skill and experience

Negotiable