Data System Specialist

Ambu A/S; Malaysia; On-site; MYR 60,000 - 80,000; Full time

Job summary

Ambu A/S is seeking a Data Systems Specialist to join their global data and analytics team. The role involves managing the data warehouse, developing ETL processes, and ensuring data integrity and performance. Candidates must have a strong background in Data Engineering and SQL, and familiarity with tools like Azure Data Factory and Power BI.

This position offers a chance to work in a dynamic international environment, contributing to data governance and optimization efforts.

Qualifications

• Minimum of 3 years in Data Warehousing, Data Engineering, or Business Intelligence Development.
• At least 3 years of experience with SQL and Data Integration.
• Solid understanding of Ralph Kimball methodologies.
• Experience with ETL development and Data Integration.

Responsibilities

• Manage and maintain the data warehouse to ensure integrity.
• Implement ETL processes and develop data models.
• Ensure data systems perform efficiently.

Skills

Data Warehousing

SQL

ETL Development

Data Integration

Data Modelling

Data Governance

Azure Data Factory

MS SSIS

Power BI

Education

Certificates from Microsoft in Azure Data Platform

Tools

Azure DevOps

SQL Server

Tableau

ServiceNow

Qlik

Python

C++

C#

Job description

Ambu Global Hub is looking for a Data Systems Specialist. This data and analytic team is working in a global environment. By joining this team, you will be part of the large global IT team.

Role Responsibilities:

As a Data Systems Specialist / Data Engineer, you’ll be responsible for:-

1. Data Warehousing:

• Managing and maintaining the data warehouse to ensure data integrity and availability.
• Implementing data warehousing concepts and architecture, such as Ralph Kimball methodologies.
• Integrating data from various sources, ensuring seamless data flow and consistency across systems.
• Developing and maintaining data integration processes to support business operations.

2. ETL Development:

• Building and maintaining dynamic and complex ETL processes.
• Extracting, transforming, and loading data into the data warehouse.

3. Data Modelling and Design:

• Designing and creating data models that facilitate efficient querying and reporting.
• Ensuring data accuracy and consistency.

4. Performance Tuning and Optimization:

• Ensuring data systems perform efficiently.

5. Data Governance and Security:

• Implementing data governance policies and ensuring data security.
• Implementing access controls.
• Managing data lineage and compliance.

6. Report and Dashboard Development:

• Ability to understand or create interactive dashboards, reports, and visualizations for business users.
• Empowering business users with self-service reporting.

Qualifications:

• Minimum of 3 years solid in Data Warehousing, Data Engineering, or Business Intelligence Development (Must).
• At least 3 year(s) of experience with SQL, Data Integration, Implementing 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 for a global organization (Must).
• Certificates from Microsoft in Azure Data Platform, Azure Data Factory, Power BI, Database, ETL Tools, and SQL Server/Cloud Services (Preferred).
• Self-starter, principled, and driven to do the right thing for the organization (Preferred).
• Experience working in an Agile/Scrum environment.
• Knowledge of Medical industries or Medical Manufacturing business domains.