Data Engineer: Warehousing, ETL & BI Analytics

Ambu; Penang; On-site; MYR 90,000 - 150,000; Full time

Job summary

Ambu in Penang, Malaysia is seeking a Data Systems Specialist / Data Engineer to own data warehousing, ETL development, modelling, and governance. You will maintain data integrity, build scalable data pipelines, and enable self-service reporting for business users.

The role requires hands-on experience with SQL, MS SSIS, Azure Data Factory, Power BI, and data integration tools, along with a solid foundation in Ralph Kimball methodologies and data security practices.

Qualifications

• At least 3 years in data warehousing, data engineering, or BI development.
• Experience with SQL, data integration, data quality checks and modelling.
• Proficiency in MS SSIS, Azure Data Factory, SQL Server and data integration tools.
• Familiarity with Agile/Scrum is a plus.
• Knowledge of medical manufacturing domain is beneficial.

Responsibilities

• Maintain and improve data warehouse integrity and availability.
• Design and optimize ETL processes and data flows.
• Create data models for efficient querying and reporting.
• Ensure data governance, security, and compliance.
• Develop dashboards and reports for business users.

Skills

SQL

Data Integration

Data Modelling

ETL Development

Power BI

MS SSIS

Azure Data Factory

Azure DevOps

Tools

MS SSIS

Azure Data Factory

SQL Server

Power BI

Tableau

Qlik

Job description

Ambu in Penang, Malaysia is seeking a Data Systems Specialist / Data Engineer to own data warehousing, ETL development, modelling, and governance. You will maintain data integrity, build scalable data pipelines, and enable self-service reporting for business users.

The role requires hands-on experience with SQL, MS SSIS, Azure Data Factory, Power BI, and data integration tools, along with a solid foundation in Ralph Kimball methodologies and data security practices.