Application Specialist

Nexus International School Malaysia; Putrajaya; On-site; MYR 50,000 - 70,000; Full time

Job summary

An educational institution based in Putrajaya seeks a Database Report Developer to manage and design reports using SQL and Power BI. This role includes maintaining school applications, supporting data integration, and ensuring compliance with data policies. Candidates should possess a Bachelor's degree in Computer Science and have 2-3 years of relevant experience. Strong SQL and PL/SQL skills are essential alongside troubleshooting and analytical abilities. The position promises a dynamic work environment focused on optimizing academic data systems.

Qualifications

• Minimum 2–3 years in database management and reporting roles.
• Prior experience in an educational environment is an advantage.

Responsibilities

• Develop and manage reports using PL/SQL and SQL Server.
• Create dashboards and visualizations for school leadership.
• Administer and maintain core school applications.
• Manage and optimize Microsoft SQL Server databases.
• Provide training and support on institutional systems.

Skills

Strong SQL & PL/SQL scripting experience

Hands-on experience with Microsoft SQL Server

Ability to build reports and dashboards using Power BI

Understanding of data structures in academic systems

Knowledge of API integration and ETL processes

Strong troubleshooting skills

Education

Bachelor’s degree in Computer Science or related field

Tools

Power BI

SSRS

Microsoft SQL Server

Job description

A. JOB PURPOSE

The role involves developing and managing reports using PL/SQL, Microsoft SQL Server, Power BI, SSRS, and other reporting tools to provide technical support and maintenance for institutional systems that manage academic, administrative, and operational data. This includes systems such as Student Information Systems, Visitor Management and other Application systems.

B. KEY RESPONSIBILITIES

1. Analytics & Reporting

• Design, develop, and maintain reports using SSRS, Power BI, and other reporting tools
• Create dashboards and visualizations to support school leadership and operational teams.
• Automate recurring reports and ensure timely delivery.

2. Integration & Data Flow

• Support integration between institutional systems (Student Information System, Finance, HR, LMS, etc.).
• Monitor and troubleshoot data synchronization processes.

3. System Support & Maintenance

• Administer and maintain core school applications, including user management, permissions, and module configurations.
• Troubleshoot and resolve system issues promptly to minimize downtime.
• Liaise with Academic PIC to configure term dates, reporting cycles, grading structures, cohorts, and academic settings.
• Give advice to the Module owner when there is any update from the iSams system and other application systems.
• Liaise with system vendors and third-party providers for escalated issues.
• Provide functional support to teachers, coordinators, and administrative users.

4. Database Management

• Manage and optimize Microsoft SQL Server databases across multiple systems.
• Develop and maintain PL/SQL scripts for data extraction, transformation, and loading (ETL).
• Ensure data integrity, security, and compliance with school policies.

5. Documentation & Training

• Maintain technical documentation for processes, reports, and system configurations.
• Provide training and support to staff on using institutional systems and reporting tools effectively.

C. JOB SPECIFICATION

Key Skills & Requirements

Education & Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.

Technical Skills & Experience

• Strong SQL & PL/SQL scripting experience (queries, stored procedures, data extraction).
• Hands‑on experience with Microsoft SQL Server (views, scheduled jobs, DB maintenance).
• Ability to build reports and dashboards using Power BI and SSRS.
• Understanding of data structures in academic systems (attendance, grades, timetable, cohorts) will be anadded advantage.
• Experience managing application platforms, preferably iSAMS or similar SIS/MIS will be an added advantage.
• Knowledge of API integration, ETL processes, and data synchronization across systems.
• Strong troubleshooting skills for application, database, and integration issues.

Experience

• Minimum 2–3 years in database management and reporting roles.
• Prior experience in an educational environment is an advantage.

Soft Skills

• Analytical and problem‑solving skills.
• Communication and stakeholder management.
• Ability to work independently and as part of a team.

The job holder’s responsibility for promoting and safeguarding the welfare of children and young persons for whom s/he is responsible, or with whom s/he comes into contact will be to adhere to and ensure compliance with the School’s Safeguarding Policy and Procedures at all times. If in the course of carrying out the duties of the role, the job holder identifies any instance that a child is suffering or likely to suffer significant harm either at school or at home, s/he must report any concerns to the School’s / Designated Safeguarding Lead or to the Principal or indeed to the Safeguarding Governor so that a referral can be made accordingly to the relevant third party services.