Senior Data Modeller – Enterprise Data Architecture

Accion Labs; Kuala Lumpur; On-site; MYR 180,000 - 320,000; Full time

Job summary

Accion Labs in Kuala Lumpur, Malaysia, is hiring a Senior Data Architect to lead enterprise data modelling across conceptual, logical, and physical layers. You will establish standards, design scalable data structures for analytics and self-service data consumption, and ensure consistency across business domains.

You will collaborate with architecture, engineering and BI teams to optimise data models for Snowflake, Lakehouse and BI tools like Power BI, Tableau and Looker.

Qualifications

• 8+ years of experience in data warehousing, analytics and data modelling.
• Experience supporting large-scale data warehouse or analytics platforms.
• Experience reviewing and improving existing data warehouse and data mart designs.
• Experience working with cross-functional business and technology teams.

Responsibilities

• Lead the design and review of enterprise data models across conceptual, logicaland physical layers.
• Establish and maintain enterprise data modelling standards and best practices.
• Develop scalable data structures that support business reporting, analytics and self-service data consumption.
• Ensure consistency and integration across multiple subject areas and business domains.
• Collaborate with business and technical stakeholders to align data structures with business requirements.
• Review and assess existing data warehouse and data mart designs.
• Support data warehouse modernisation and transformation initiatives.
• Identify modelling gaps, redundancies and opportunities for optimisation.
• Ensure data models support future analytical and operational requirements.
• Contribute to target-state data architecture and modelling frameworks.
• Partner with BI teams to improve semantic layer design.
• Enable self-service analytics capabilities.

Tools

Snowflake Schema Design

Slowly Changing Dimensions

Dimension Table Design

Fact Table Design

Conceptual, Logical and Physical Data Modelling

Power BI

Tableau

Qlik

Looker

Microsoft Fabric

Databricks

Snowflake

BigQuery

Amazon Redshift

Microsoft Purview

Informatica

Job description

Accion Labs in Kuala Lumpur, Malaysia, is hiring a Senior Data Architect to lead enterprise data modelling across conceptual, logical, and physical layers. You will establish standards, design scalable data structures for analytics and self-service data consumption, and ensure consistency across business domains.

You will collaborate with architecture, engineering and BI teams to optimise data models for Snowflake, Lakehouse and BI tools like Power BI, Tableau and Looker.