Data Engineer (SQL/Bi)

OPTIMUM SOLUTIONS (SINGAPORE) PTE LTD; Singapore; On-site; SGD 70,000 - 110,000; Full time

Job summary

OPTIMUM SOLUTIONS (SINGAPORE) PTE LTD represents a Singapore government organisation seeking a Data Engineer to join their Platform team. The role focuses on transforming cyber asset data into reliable datasets, dashboards and insights to support asset visibility, vulnerability management and incident response.

You will design data models, build pipelines, develop dashboards, monitor data quality and collaborate with analysts and infrastructure engineers to deliver actionable insights.

Qualifications

• 3+ years of experience in data engineering, analytics engineering or business intelligence.
• Strong SQL skills with data transformation experience (dbt, Spark).
• Hands-on with BI/visualisation tools such as Power BI, Tableau, Grafana or Superset.
• Experience in data modelling and integrating data from multiple sources.
• Understanding of data quality, validation and pipeline practices.
• Python and orchestration tools like Airflow, Dagster or Prefect are advantageous.
• Experience with cyber asset data, CMDBs or vulnerability scanners is a plus.

Responsibilities

• Design and maintain data models integrating data from multiple sources.
• Build and maintain data pipelines to clean, transform, enrich and validate data.
• Develop dashboards and visualisations for asset visibility and vulnerability tracking.
• Monitor data quality, pipeline health and data freshness; resolve data issues.
• Optimise queries and data refresh processes for reliable dashboards.
• Collaborate with Business Analysts and Infrastructure Engineers to deliver insights.
• Document data models, transformation logic and dashboard specifications.

Skills

Strong SQL skills

Data transformation tools

BI/visualisation tools

Data modelling

Data quality & pipeline practices

Python & orchestration tools

CMDBs/vulnerability data knowledge

Tools

dbt

Apache Spark

Power BI

Tableau

Grafana

Superset

Airflow

Dagster

Prefect

Job description

Our client is a Singapore government organisation looking for aData Engineerto join their Platform team. The role focuses on transforming cyber asset data into reliable datasets, dashboards and insights to support asset visibility, vulnerability management and incident response.

Responsibilities

• Design and maintain data models integrating data from multiple sources such as CMDBs, vulnerability scanners and agency systems.
• Build and maintain data pipelines to clean, transform, enrich and validate data.
• Develop and maintain dashboards and visualisations for asset visibility, vulnerability prioritisation and remediation tracking.
• Monitor data quality, pipeline health and data freshness, and resolve data issues.
• Optimise queries and data refresh processes to ensure reliable and responsive dashboards.
• Work with Business Analysts and Infrastructure Engineers to support agency requirements and deliver actionable insights.
• Document data models, transformation logic and dashboard specifications.

Requirements

• 3+ years of experience in data engineering, analytics engineering or business intelligence.
• Strong SQL skills and experience with data transformation tools such as dbt, Apache Spark or equivalent.
• Hands-on experience with BI and visualisation tools such as Power BI, Tableau, Grafana or Superset.
• Experience in data modelling and working with data from multiple sources.
• Strong understanding of data quality, validation and data pipeline practices.
• Experience with Python and orchestration tools such as Airflow, Dagster or Prefect is advantageous.
• Experience with cyber asset data, CMDBs or vulnerability scanners is a plus.