Global Data Warehouse Engineer – ETL & Analytics

Ambu A/S; Penang; Hybrid; MYR 90,000 - 150,000; Full time

Job summary

Ambu Global Hub is seeking a Data Warehouse Developer to join a global IT team. You will manage the data warehouse, develop ETL processes, and design data models to support dashboards and reporting for business users.

The role emphasizes data governance, security, and self-service analytics in a multinational environment. The ideal candidate has 3+ years in data warehousing/BI, strong SQL and ETL skills, and familiarity with Kimball methodologies.

Qualifications

• Minimum 3 years in Data Warehousing or BI development (Must).
• At least 3 years with SQL, Data Integration, Data Quality Checks and Data Modelling (Must).
• Proficiency in MS SSIS, Azure Data Factory, SQL, MS SQL Database, Azure DevOps, and Data Integration Tools (Must).
• Experience with Power BI, ServiceNow, Qlik, Tableau, C, C++, C#, Python, or R (Beneficial).
• Solid understanding of Ralph Kimball methodologies (Must).
• Experience with ETL development, Data Integration, and Data Warehousing (Must).
• Ability to analyse complex, large data sets, data models, data mining, and segmentation techniques (Must).
• Microsoft Azure-related certificates (Preferred).
• Experience in Agile/Scrum environments.
• Knowledge of Medical industries or Medical Manufacturing domains.

Responsibilities

• Data Warehousing: Managing and maintaining the data warehouse to ensure data integrity and availability.
• ETL Development: Building and maintaining dynamic and complex ETL processes; extracting, transforming, and loading data.
• Data Modelling and Design: Designing data models for efficient querying and reporting.
• Performance Tuning and Optimization: Ensuring data systems perform efficiently.
• Data Governance and Security: Implementing governance policies, access controls, data lineage and compliance.
• Report and Dashboard Development: Creating dashboards, reports, and visualizations for business users with self-service reporting.

Skills

SQL

Data Integration

Data Quality Checks

Data Modelling

Power BI

Azure Data Factory

SSIS

Azure DevOps

Python

R

Agile/Scrum

C#

Education

Microsoft Azure Certifications (preferred)

Tools

SSIS

Azure Data Factory

SQL Server

Azure DevOps

Power BI

ServiceNow

Qlik

Tableau

Job description

Ambu Global Hub is seeking a Data Warehouse Developer to join a global IT team. You will manage the data warehouse, develop ETL processes, and design data models to support dashboards and reporting for business users.

The role emphasizes data governance, security, and self-service analytics in a multinational environment. The ideal candidate has 3+ years in data warehousing/BI, strong SQL and ETL skills, and familiarity with Kimball methodologies.