Data Systems Engineer

American International School of Johannesburg, Outside of US & Canada

Job Level

Mid-level position

Post Date

04/21/2018

Job Category

Engineer / Architect

Sector

Systems / Operations
Information Technology

Job Status

Areas of Responsibility

Data / Database
Network / Systems

Link to Job Posting

Working closely with the Director of Technology and Senior Data Systems Engineer, The Data Systems Engineer will be responsible for the day to day and long-term integrity of AISJ data. They will be responsible for making sure that data collected by various school divisions and departments are accurately and efficiently entered in the relevant databases. Additionally, they will assist in the management of various learning and content management systems. The Data Systems Engineer will be expected to play a role in the conversion of data, entry of data into the different systems and the creation of reports while providing a high level of support and best practice knowledge to administrators and teachers in accordance with the learning goals of the school.

QUALIFICATIONS

Matric Certificate
ITIL
MCSE BI, MCSE Data Analytics
BSc degree in Computer Science or relevant field

PREFERRED SKILLS AND EXPERIENCE

3 or more years PL/SQL and T-SQL experience
In-depth understanding of how technology integrates in the enterprise
Significant and successful experience using different Database Systems in the enterprise, eg MS SQL, Oracle, MySQL, PostgreSQL
Significant and successful experience using reporting systems, eg Oracle APEX, SQL Reporting server
Expert Level Microsoft Excel Skills
Data modeling and Dashboards eg, PowerBI, Qlik View
Oracle and Microsoft SQL Database administration
JavaScript, HTML/HTML5, and XML web development experience
Active Directory Administration
Oracle SQL Developer

GENERAL RESPONSIBILITIES:

Support teachers and administrators with the different Database systems with their relevant UI. Including but not limited to PowerTeacher, PowerSchool, PowerTeacher Pro, Finalsite, etc
Administer and maintain different databases
Set-up and review of security access
Ensure data accuracy
Support data processing and integration with other platforms
Support different data gathering tools and ensure reporting is up to date and accurate (Currently using Ecollect)
Work with relevant departments to ensure the smooth and ongoing operations of the emergency alert system for SMS, E-Mail and Voice Notes (Currently using Alert Solutions)
Drive and establish the management of different data Standard Operating Procedures
Ensure smooth operations of Database systems by running administrative tasks
Coordinate the troubleshooting and the support calls with external providers
In collaboration with communications provide maintenance and troubleshooting support on the school website.
Support the Senior Data Systems Engineer with data table structures, forms, reports, and queries
Development of reports and queries to support business needs
Work with the Senior Data Systems Engineer to identify single points of failure and to work out Disaster Recovery plans
Stay abreast of latest technology and work with IT Manager on potential upgrades
Perform and support other tasks as identified by the Technology Director

ATTRIBUTES:

Friendly and personable demeanor
Ability to communicate effectively with others both verbally and in writing
Ability to collaborate with I.T team to maintain standards and SLA’s
Great attention to detail
Excellent organizational and coordination abilities
Self-starter and self-motivator
Ability to take ownership and responsibility
Possess the drive to learn and is adaptable to change/new technologies
Ability to critically analyze a symptom, diagnose a fault, plan and take appropriate action
Ability to work under extreme pressure
Willing to work overtime when and if needed
Ability to participate in and establish collaborative working relationships