Application Support-Production Support

amIT Global Solutions; Putrajaya; On-site; MYR 120,000 - 180,000; Full time

Job summary

Jora Malaysia is seeking a senior data modelling professional to build and optimize data models for reporting across diverse data sets. You will translate business requirements into robust source-to-target mappings and design both transactional and dimensional data structures.

You will write complex SQL, profile data, and contribute to data warehouse projects, collaborating with stakeholders to standardize models and improve data governance practices.

Qualifications

• Experience designing Operational and Data Warehouse data models.
• Ability to translate business requirements into data models and mappings.
• Strong SQL writing and data profiling for transformations.
• Proficient in OLTP/OLAP conceptual, logical and physical modelling.
• Knowledge of ETL principles and data governance practices.

Responsibilities

• Build and maintain data models for reporting disparate data sets.
• Gather, distil and harmonize data requirements and design coherent models.
• Write complex SQL and map source to target with ETL transformations.
• Contribute to database design for transactional and dimensional models.
• Normalize/denormalize data structures and introduce hierarchies where needed.
• Develop and implement data warehouse projects independently.
• Collaborate with data consumers and suppliers to standardize models.

Skills

Data modeling

Requirements gathering

SQL proficiency

Database design

Data warehouse

Stakeholder management

ETL

Data modelling tools

SQL vs NoSQL

Communication

AWS cloud

MDM / Data governance

Data visualization

Informatica

Tools

Erwin

SAP PowerDesigner

Informatica

Tableau

SAS VA

SQL Server

Oracle

Job description

Jora Malaysia will close on 9th September 2026. Thank you for being with us, we are cheering you on as you continue your career journey.

• Build and maintain out of standards data models to report disparate data sets in a reliable, consistent and interpretable manner.
• Gather, distil and harmonize data requirements and to design coherent Conceptual, logical and physical data models and associated physical feed formats to support these data flows.
• Articulate business requirements and build source-to-target mappings having complex ETL transformation. Write complex SQL statements and profile source data to validate data transformations.
• Contribute to requirement analysis and database design - Transactional and Dimensional data modelling.
• Normalize/ De-normalize data structures, introduce hierarchies and inheritance wherever required in existing/ new data models.
• Develop and implement data warehouse projects independently.
• Work with data consumers and data suppliers to understand detailed requirements, and to propose standardized data models.
• Contribute to improving the Data Management data models. Be an influencer to present and facilitate discussions to understand business requirements and develop dimension data models based on these capabilities and industry best practices. Requirements
• Extensive practical experience in Information Technology and software development projects of with at least 5+ years of experience in designing Operational data store & data warehouse.
• Extensive experience in any of Data Modelling tools – Erwin/ SAP power designer.
• Strong understanding of ETL and data warehouse concepts processes and best practices. Proficient in Data Modelling including conceptual, logical and physical data modelling for both OLTP and OLAP.
• Ability to write complex SQL for data transformations and data profiling in source and target systems.
• Basic understanding of SQL vs NoSQL databases. Possess a combination of solid business knowledge and technical expertise with strong communication skills. Demonstrate excellent analytical and logical thinking.
• Good verbal & written communication skills and Ability to work independently as well as in a team environment providing structure in ambiguous situation.
• Good to have Understanding of Insurance Domain
• Basic understanding of AWS cloud Good understanding of Master Data Management, Data Quality and Data Governance.
• Basic understanding of data visualization tools like SAS VA, Tableau
• Good understanding of implementing & architecting data solutions using the informatica, SQL server/Oracle