Context and environment
A university degree in Computer Engineering / Computer Science or related disciplines.
Good people management skills
A good knowledge of HR Information Systems processes and procedures
Excellent knowledge of Oracle, MS SQL Server, PostgreSql, SAP, and PL / SQL.
A background knowledge of reporting development and integration.
Good knowledge of system testing and debugging.
Exceptional MS Excel skill
Good communication skills and interpersonal skills
Excellent use of Power BI and / or other Business Intelligence applications.
A minimum of 10 years experience working in a similar position and environment
A. Application Support
a) Support all existing HR applications including but not limited to HR4U and HRDirect. b) Provide support to other employees on all HR systems.
Ensure effective use of HR Business Systems. c) Administer company-wide and local legacy applications
B. Application Development
a) Design database objects, including but not limited to tables, stored procedures, views, functions, queries. b) Carry out analysis and design of identified processes for automation.
c) Write codes to automate processes. d) Participate in testing of new and existing software modules. e) Fix bugs, provide enhancements and modifications when needed.
C. Database Design and Management
a) Design procedures to ensure availability of the HR Database at all times. b) Design queries, stored procedures and functions for analyzing HR Databases.
c) Monitor database performance and carry out database tuning when necessary. d) Carry out database upgrades when necessary.
D. HR Reports
a) Manage the Census process. Prepare initial data, liaise with HR Advisers and entity heads to provide updates. Upload final data to web census and provide census reports to HR Management.
b) Carry out organization chart updates and provide periodic org chart and manpower reports. c) Provide standard and ad-hoc reports as may be required by management.
a) Quarterly Census campaigns b) Managing employee data forecast and statistics c) Coordinates other reports from HQ e.g. SoGre t