BI Data Engineer: Dashboards & Data Modeling

Ambition Singapore; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

Ambition Singapore is seeking an experienced Data Engineer to join our data and analytics team in Singapore. The role focuses on delivering data pipelines, dashboards, and reliable data assets for business teams across the organization.

You will collaborate with business units to capture requirements, translate them into technical specifications, design data models, and build interactive Tableau dashboards powered by AWS Redshift, S3, and Glue.

Qualifications

• 3+ years of experience in data engineering, BI, or analytics.
• Proficiency in SQL for data querying, transformation and modelling.
• Hands-on experience with Tableau or equivalent BI tools for dashboard development.
• Experience with cloud data platforms (AWS preferred: Redshift, S3, Glue).
• Strong stakeholder engagement and ability to translate business needs into technical requirements.
• Experience in data modelling for analytics (star schema, dimensional modelling).

Responsibilities

• Partner with business units to understand data and reporting needs.
• Facilitate requirements workshops and interviews to document data requirements, KPIs, and reporting use cases.
• Translate business requirements into data specifications for the data engineering team.
• Act as liaison between business stakeholders and data platform team.
• Design and develop data transformation logic for curated datasets.
• Build and maintain data models in Redshift or the data lake zone.
• Ensure data accuracy, consistency, and completeness for reporting datasets.
• Apply data quality checks and validation rules for insights.
• Design and maintain dashboards and reports in Tableau (via Redshift or S3).
• Create near-real-time dashboards, ad-hoc analyses, and scheduled reports.
• Ensure dashboards are intuitive for non-technical users.
• Document data definitions, glossary terms, and dashboard logic in AWS Glue Catalogue.

Skills

SQL

Stakeholder engagement

Data modelling

Dashboards

Data warehousing

Tools

Tableau

Power BI

QuickSight

Amazon Redshift

Amazon S3

AWS Glue

Job description

Ambition Singapore is seeking an experienced Data Engineer to join our data and analytics team in Singapore. The role focuses on delivering data pipelines, dashboards, and reliable data assets for business teams across the organization.

You will collaborate with business units to capture requirements, translate them into technical specifications, design data models, and build interactive Tableau dashboards powered by AWS Redshift, S3, and Glue.