Senior Data Integration & Production Support Engineer

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 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.