Senior Data Architect & Analyst: Data Warehouse Leader

Asia Gulf Cloud; Singapore; On-site; SGD 150,000 - 210,000; Full time

Job summary

Asia Gulf Cloud is seeking a Senior Data Analyst with a Data Architect mindset to design the data warehouse and data lake layers using a design-first approach. You will bridge business requirements with high-performance data engineering, leading cross-functional collaboration with Data Engineering and business teams.

You will drive enterprise blueprinting, regulatory data modeling, and the implementation of complex KPIs such as AUM and risk metrics, while ensuring data accuracy and a single

Qualifications

• Excellent command of English and Chinese; ability to lead meetings and draft technical docs.
• Deep knowledge of business metrics such as customer experience, accounting, regulatory or risk.
• Proven ability to design data models based on industry best practices.
• Expert in Dimensional Modeling (Star/Snowflake) and 3NF.
• Strong familiarity with AWS EMR (Spark/Hive) and Airflow orchestration.

Responsibilities

• Enterprise blueprinting: lead logical and physical data warehouse design across DWD/DWS/ADS layers.
• Proactive requirement engineering to capture data needs before requests.
• Architectural oversight to ensure data logic migration from Redshift to EMR maintains accuracy.
• Gatekeeper of data accuracy and integrity.
• Design data flows meeting regulatory standards with clear data lineage.
• Build foundational data warehouse models and complex KPIs like AUM and risk metrics.
• Coordinate global standardization to unify data definitions across regions.
• Understand or self-teach data model use cases for real-time and batch analytics.
• Stakeholder communication as data team representative and product owner.

Skills

Advanced SQL

Data modeling

Dimensional modeling

3NF normalization

Power BI (DAX)

AWS QuickSight

Python for data manipulation

AWS EMR (Spark/Hive)

Airflow

Tools

AWS EMR (Spark/Hive)

Airflow

Spark

Hive

Python

Power BI

AWS QuickSight

Job description

Asia Gulf Cloud is seeking a Senior Data Analyst with a Data Architect mindset to design the data warehouse and data lake layers using a design-first approach. You will bridge business requirements with high-performance data engineering, leading cross-functional collaboration with Data Engineering and business teams.

You will drive enterprise blueprinting, regulatory data modeling, and the implementation of complex KPIs such as AUM and risk metrics, while ensuring data accuracy and a single