To design, develop, and optimization of enterprise-level data warehousing solutions.
Design and implement robust ETL processes using industry-standard tools and frameworks.
Develop and maintain conceptual, logical, and physical data models to support business analytics.
Collaborate with stakeholders and BA to gather business requirements (BRS) and translate them into detailed SRS and SDS documentation.
Ensure data accuracy, integrity, consistency, and availability across platforms and applications.
Provide technical leadership in data architecture and modelling best practices.
Work with business analysts and data consumers to define and deliver actionable insights and reporting.
Drive performance tuning, capacity planning, and scalability enhancements for data warehousing infrastructure.
Utilize Pentaho for data integration workflows, and Vertica for high-performance analytical processing is advantage.
Mentor junior team members and provide technical guidance.
Required Skills and Qualifications:
3 years and above of experience in data warehousing, ETL development, and data analytics.
Strong experience in data modelling (star schema, snowflake, normalization/denormalization).
Proficient in writing complex SQL queries and performance tuning.
Proven experience with ETL tools (Pentaho Data Integration is a plus).
Strong knowledge of data warehouse architectures and methodologies.
Experience with columnar databases like Vertica is a strong advantage.
Familiarity with SDLC processes, including active participation in BRS, SRS, and SDS documentation.
Solid understanding of data governance, data quality, and metadata management.
Excellent communication, problem-solving, and documentation skills.
Proficient in Malay
Job Type: Contract
Contract length: 12 months
Pay: RM4,000.00 - RM8,000.00 per month
Benefits:
Health insurance
Ability to commute/relocate:
Kuala Lumpur: Reliably commute or planning to relocate before starting work (Required)
Application Question(s):
Which of the following data mining tools are you experienced with?
How many years' experience do you have using SQL queries?
How many years experience do you have as a Data Engineer?
Have you worked in a role which requires a sound understanding of the software development lifecycle?
How long is your notice period?
How much is your current salary per month in RM?
How much is your expected salary per month in RM?
Education:
Bachelor's (Required)
Experience:
Pentaho: 3 years (Preferred)
Work Location: In person
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.