Application Developer

Role : Application Developer
Job Type: Contract
Duration : 12 months (renewable)

Roles and Responsibilities

• Work closely with Product Owner for the development, implementation and maintenance of Business Intelligence (BI) and Data warehouse projects. Scope of work includes:
  a) Work closely with stakeholders to gather their requirements
  b) Develop data warehouse and data marts on premises and on the cloud
  c) Design and develop reports, dashboards and interactive visualizations
  d) Provide system documentation, ensure proper version control, and change management of programs
  e) Provide operational maintenance and support for non-production environments
  f) Handle incidents and service request management to resolve issues within the Service Level Agreement
  g) Engage users to implement enhancements/refinements based on changes in business requirements and timeline agreed upon with users
  h) Work with appointed personnel to support and provide response to regular audits or reviews for the projects and work on the follow-up action and recommendation from the audit findings
  i) Conduct testing of software patches or upgrades, and work with Facilities Management team for the production deployment
• Support Product Owner in conducting regular clinics and user training/briefing (with training materials) to raise BI competency for users.
  
  Knowledge and Skills
  
• Tertiary Education in relevant fields is preferred
• Understand key concepts in data modelling, data processing, data warehouse, data management and data security
• Hands-on experience in SQL programming language
• Hands-on experience in a data warehouse project
• Hands-on experience in visual analytics, preferably using Power BI or Tableau
• Experience in one or more of the following:
  a) Creating tables, views and partitioning in SQL and PostgreSQL database
  b) Creating ingestion scripts using Microsoft SQL Server Integration Services (SSIS), Database Migration Services (DMS) or AWS Glue
  c) Azure cloud platform, AWS S3 or Athena
  d) Creating data pipelines using AWS Lambda, ECS Container task or Eventbridge
  e) ER Studio data modeling
• Advantageous to have experience in the following:
  a) Data masking, encryption or data virtualisation
  b) Microsoft Sharepoint
  c) Azure DevOps, JIRA or Bamboo
  d) Unix scripting for secure file transfers
  e) Develop marts using SQL Server Analytics Services (SSAS)
  f) Dot Net programming (e.g. C#)
  g) Kafka
• Strong analytical, logical thinking and problem-solving skills
• Willing to learn and adapt. A good team player with excellent communication skills (written and spoken)
• Excellent communication skills, both oral and written
• Passing mark in an online developer test
  
  Due to sensitivity of system, only Singaporean or Singaporean PR should apply.