Data Systems Specialist: ETL, Warehousing & Dashboards

Ambu; Seberang Perai; On-site; MYR 89,000 - 179,000; Full time

Job summary

Ambu Global Hub is seeking a Data Systems Specialist to join a global IT analytics team. You will manage data warehousing, ETL, data modelling, and governance to support enterprise reporting.

You'll work with SQL, Azure Data Factory, SSIS, Power BI, and data visualization tools to deliver reliable dashboards and self-service insights for business users. The role requires 3+ years in data warehousing/BI, strong data modelling skills, and fluency in English; certification in Azure/Data/Power BI is

Qualifications

• Minimum of 3 years solid in Data Warehousing, Data Engineering, or BI Development.
• At least 3 years experience with SQL, Data Integration, Data Quality Checks and Data Modelling.
• Proficiency in MS SSIS, Azure Data Factory, SQL, MS SQL Database, Azure DevOps, and Data Integration Tools.
• Experience with Power BI, ServiceNow, Qlik, Tableau, Python, or R is Beneficial.
• Strong understanding of Ralph Kimball methodologies.
• Experience with ETL development, Data Integration, and Data Warehousing.
• Ability to analyse complex, large data sets, data models, data mining, and segmentation for a global organization.
• Fluent in English.
• Microsoft Azure/Power BI/ETL tools certifications preferred.

Responsibilities

• Data Warehousing: Manage and maintain the data warehouse for integrity and availability.
• ETL Development: Build and maintain dynamic ETL processes and load data into the warehouse.
• Data Modelling and Design: Create data models for efficient querying and reporting.
• Performance Tuning and Optimization: Ensure data systems perform efficiently and monitor queries.
• Data Governance and Security: Implement data governance policies and access controls, ensure lineage and compliance.
• Report and Dashboard Development: Develop interactive dashboards and self-service reports for business users.

Skills

Data Warehousing

Data Engineering

BI Development

SQL

Data Integration

Data Quality Checks

Data Modelling

ETL Development

Data Governance

Power BI

Azure Data Factory

MS SSIS

Azure DevOps

Python

R

Tools

MS SSIS

Azure Data Factory

SQL

MS SQL Database

Azure DevOps

Power BI

Tableau

Qlik

ServiceNow

Job description

Ambu Global Hub is seeking a Data Systems Specialist to join a global IT analytics team. You will manage data warehousing, ETL, data modelling, and governance to support enterprise reporting.

You'll work with SQL, Azure Data Factory, SSIS, Power BI, and data visualization tools to deliver reliable dashboards and self-service insights for business users. The role requires 3+ years in data warehousing/BI, strong data modelling skills, and fluency in English; certification in Azure/Data/Power BI is