DataMart Engineer

Atome; Kuala Lumpur; On-site; MYR 120,000 - 180,000; Full time

Benefits offered by this job

Public transportation access

Insurance coverage (dental, optical, &

Gym and fitness claims

Training and development opportunities

Career growth exposure

Job summary

Hytech, a leading management consulting firm, is seeking a data analytics professional in Kuala Lumpur to design, develop, and maintain data marts supporting business analytics and reporting. You will build and optimize ETL/ELT pipelines, translate requirements into dimensional models, and collaborate with Sales, Finance, and Operations to deliver actionable datasets.

You will work with Databricks, AWS data services, and SQL/Python to ensure data quality, performance, and governance.

Qualifications

• Strong experience in data mart / data warehouse modeling (Kimball methodology preferred).
• Hands-on experience with Databricks (Spark, PySpark).
• Solid experience in AWS data services (e.g., S3, Glue, Redshift, Lambda).
• Proficiency in SQL and at least one programming language (Python preferred).
• Experience building and maintaining ETL/ELT pipelines.
• Understanding of data partitioning, indexing, and performance tuning.

Responsibilities

• Design, develop, and maintain data marts to support business analytics and reporting needs.
• Build and optimize ETL/ELT pipelines using scalable data processing frameworks.
• Translate business requirements into dimensional models (star/snowflake schemas).
• Ensure data quality, consistency, and reliability across datasets.
• Collaborate with business stakeholders to deliver actionable datasets.
• Work closely with Data Analysts and BI teams to enable self-service analytics.
• Implement data governance, documentation, and best practices across the data layer.
• Monitor and troubleshoot pipeline performance and data issues.

Skills

Dimensional modeling

Databricks

AWS data services

SQL

Python

ETL/ELT pipelines

Tools

Databricks (Spark, PySpark)

AWS S3

AWS Glue

Redshift

Lambda

Job description

Posted on 2026-08-07

Job List

Hytech is a leading management consulting firm headquartered in Australia and Singapore, specialising in digital transformation for fintech and financial services organisations. We deliver end-to-end consulting services and provide robust middle- and back-office solutions that enable our clients to optimise operations, enhance efficiency, and stay ahead in a fast-evolving digital landscape.

With more than 2,000 professionals worldwide, Hytech has a strong and growing international presence, with offices across Australia, Singapore, Malaysia, Taiwan, the Philippines, Thailand, Morocco, Cyprus, Dubai, and beyond.

Key Responsibilities

• Design, develop, and maintain data marts to support business analytics and reporting needs
• Build and optimize ETL/ELT pipelines using scalable data processing frameworks
• Translate business requirements into dimensional models (star/snowflake schemas)
• Ensure data quality, consistency, and reliability across datasets
• Optimize query performance and data storage for efficient downstream consumption
• Collaborate with business stakeholders (Sales, Finance, Operations) to deliver actionable datasets
• Work closely with Data Analysts and BI teams to enable self-service analytics
• Implement data governance, documentation, and best practices across the data layer
• Monitor and troubleshoot pipeline performance and data issues

Technical Requirements

• Strong experience in data mart / data warehouse modeling (Kimball methodology preferred)
• Hands-on experience with Databricks (Spark, PySpark)
• Solid experience in AWS data services (e.g., S3, Glue, Redshift, Lambda - depending on stack)
• Proficiency in SQL and at least one programming language (Python preferred)
• Experience building and maintaining ETL/ELT pipelines
• Understanding of data partitioning, indexing, and performance tuning

Nice to have

• Practical experience in defining and enforcing data security rules (e.g., data classification, access control policies, masking strategies, audit mechanisms

What We Offer

• Easy access to public transportation (LRT & KTM).
• Corporate insurance coverage, including dental, optical, and outpatient claims.
• Gym and fitness claims.
• Ongoing training and development opportunities.
• Exposure to exciting projects that support career growth and professional development.