· 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 visualisations
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 MOM’s business requirements and timeline agreed upon with users
h) Work with MOM’s 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 MOM users.
1. Knowledge and Skills
1. Tertiary Education in relevant fields is preferred
2. Understand key concepts in data modelling, data processing, data warehouse, data management and data security
3. Hands-on experience in SQL programming language is a must
4. Hands-on experience in a data warehouse project
5. Hands-on experience in visual analytics, preferably using Power BI and Tableau
6. Experience in Data Engineering:
a) Data Engineering on AWS Cloud platform, including Lambda, Step Functions, ECS, ECR, Glue, Athena, RDS, SSM, Eventbridge, API Gateway, SQS
b) Python & containers development
c) Creating tables, views and partitioning in SQL and PostgreSQL database
d) Creating ingestion scripts using Microsoft SQL Server Integration Services (SSIS)
e) Data modelling, preferably in ER Studio
7. Advantageous to have experience in the following:
a) Denodo, SQL Polybase
b) Azure DevOps, GitLab, JIRA, Confluence
c) Microsoft Sharepoint development
d) Unix scripting for secure file transfers
e) Dot Net programming (e.g. C#)
f) Kafka / AWS Kinesis
8. Strong analytical, logical thinking and problem-solving skills
9. Willing to learn and adapt. A good team player with excellent communication skills (written and spoken)
10. Excellent communication skills, both oral and written
Due to sensitivity of system, only Singaporean or Singaporean PR should apply.
