Sr.Data Modeler

Tech Aalto Pte ltd; Singapore; On-site; SGD 120,000 - 190,000; Full time

Job summary

Tech Aalto Pte Ltd seeks an experienced Data Architect to design and maintain logical and physical data models for core banking, risk, compliance, and reporting domains. You will translate complex use cases into optimized data structures for operational and analytical workloads and guide the implementation of data warehouses and data marts.

The role requires 7-10 years in data architecture within banking/financial services, strong SQL skills, and expertise in tools like Erwin or PowerDesigner,

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field. Master’s degree is nice to have.
• 7-10 years of experience in data architecture, data modelling, or data management, preferably in the banking or financial services industry (must have).
• Basic knowledge of data governance (i.e DAMA-DMBOK).
• Deep expertise in logical and physical data modelling for core banking, risk, compliance, and financial reporting domains and various analytics use cases.
• Proficient in data modelling tools (e.g., Erwin, PowerDesigner, or similar).
• Advanced SQL skills and strong ability to work with large, complex financial datasets.
• Solid understanding of relational and dimensional modelling, financial expertise and data management.
• Intermediate understanding of regulatory compliance in the APAC region. Strong collaboration, communication, and documentation skills to engage with both business and technical stakeholders.

Responsibilities

• Partner with business stakeholders and technology teams to gather data requirements for banking products, transactions, customers, reporting and analytics.
• Design and maintain logical and physical data models reflecting core banking operations, risk management, compliance, financial reporting and analytics needs.
• Translate complex business use cases into normalized and de-normalized data structures optimized for both operational and analytical workloads.
• Implement and evolve data marts, data warehouses, and integration layers aligned with banking architecture.
• Collaborate with development teams on physical data model deployment and performance optimization for large financial datasets.
• Ensure data models adhere to data governance, data quality, and metadata management standards across banking domains.
• Provide data architecture documentation, data dictionaries, and lineage diagrams for regulatory, audit, and business usage.
• Support data lineage, metadata management, and data quality initiatives to enhance trust and transparency in data usage.

Skills

Data modelling

SQL

Data governance

Documentation

Collaboration

Communication

Education

Bachelor’s degree in Computer Science/Information Systems/Data Science or related field

Master’s degree preferred

Tools

Erwin

PowerDesigner

Job description

• Partner with business stakeholders and technology teams to gather data requirements specific to banking products, transactions, customers, reporting and analytics.
• Design and maintain logical and physical data models that reflect core banking operations, risk management, compliance, financial reporting / analytics needs.
• Translate complex business use cases into normalized and de-normalized data structures optimized for both operational and analytical workloads.
• Implementation and evolution of data marts, data warehouses, and integration layers aligned with banking architecture.
• Collaborate with development teams on physical data model deployment and performance optimization for large financial datasets.
• Ensure data models adhere to data governance, data quality, and metadata management standards across banking domains.
• Provide data architecture documentation, data dictionaries, and lineage diagrams for regulatory, audit, and business usage.
• Support data lineage, metadata management, and data quality initiatives to enhance trust and transparency in data usage.

Job Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field. Master’s degree is nice to have.
• 7-10 years of experience in data architecture, data modelling, or data management, preferably in the banking or financial services industry (must have).
• Basic knowledge of data governance (i.e DAMA-DMBOK).
• Deep expertise in logical and physical data modelling for core banking, risk, compliance, and financial reporting domains and various analytics use cases.
• Proficient in data modelling tools (e.g., Erwin, PowerDesigner, or similar).
• Advanced SQL skills and strong ability to work with large, complex financial datasets.
• Solid understanding of relational and dimensional modelling, financial expertise and data management.
• Intermediate understanding of regulatory compliance in the APAC region. Strong collaboration, communication, and documentation skills to engage with both business and technical stakeholders.