Applications Development

Job Description:

The Applications Development (Appdev) Specialist role is to help enable the company make their jobs efficient thru technology and to manage and secure the information systems of the company.
The Appdev Specialist develops applications or integration programs based on the requirements and specifications prepared by the Business Systems Analyst. The Appdev Specialist also provides support to applications/ business systems as needed. The Appdev Specialist reports to the Information Systems Manager

• Applications Development and Application Sourcing
  • Stays abreast with the emerging and latest technologies on applications development to support business requirements
  • Helps in the technical evaluation of proposed packaged software
  • Stays up-to-date on the latest trends and aligns systems procurement and development initiatives to support sustainability
  • Develops applications and creates integration programs based on the specifications provided by the business systems team and/or external consultants
  • Handles development of all other reports outside the Business Intelligence tool including but not limited to automated email reports, SSRS and In-house application (eg. EPORTAL) reports
  • Designs business system applications and databases which are properly normalized and optimized using relevant application and database design tools and methodologies
  • Creates and documents database scripts, program codes, functions and procedures that make up the business system applications
  • Documents all modifications made on existing database scripts and procedures
  • Maintains backups of previous versions of program source codes, database scripts and database procedures
  • Implements and manages application version control
  • Conducts first line testing prior release to business systems team and conducts second-line troubleshooting for concerns raised but the business systems and/or the end users
  • Handles maintenance of application databases to ensure that performance is at its optimal level; this includes truncating of logs, proposing upgrades on server specs to the technical team, etc
• Data Management
  • Handles data warehousing, architecture, modeling and archiving using structured and non-structured query languages
  • Handles all ETL (Extract, Transform, Load) requirements for business intelligence; optimizes ETL scripts to minimize run time
  • Ensures integrity of data across databases or data warehouses
  • Stays abreast with the emerging and latest technologies on data management including but not limited to big data technologies
•  Applications Support
  • Ensures accuracy of data and availability of systems; ensures all scheduled jobs, APIs and other integration programs are running and completed on time
  • Handles application support as needed
  • Coordinates with technical consultants on projects specs and other technical issues
•  Security and Compliance
  • Enforces the Data Access Policy; conducts regular audits of system/ data access rights
  • Helps ensure compliance to other IT Security Policies including Network Policy, Office Computing Policy, Email and Internet Policy and Mobile Computing and Mobile Storage Device Policy and Data Access Policy
  • Helps ensure compliance to all external regulatory requirements regarding security
•  Performance Indicators
  • System/ Application Availability (up time) and reliability (data accuracy)
  • Usability of systems/ applications
  • Optimized design of database, application including automated/ programmed reports
  • Projects are rolled-out within budgeted time and cost
  • Support services availability and efficiency
  • Compliance to all policies, SOPs and core values

Job Requirements

• Bachelor’s Degree in any IT-related course, i.e., Computer Science, Math
• Must have working experience with the Object-Oriented development tools
• Must have experience with the different Relational Database Management Systems
• Knowledge on the leading web development tools
• Has an Analytical and thorough approach in solving and debugging applications
• Has the ability to learn new and relevant application development tools and methodologies
• Must have Analytical Ability; problem solving skills, innovative & creative thinker; good communication skills and effective interpersonal skills, passionate for work, team player