Data System Specialist

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 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

• 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.
• ETL Development:
• Building and maintaining dynamic and complex ETL processes.
• Extracting, transforming, and loading data into the data warehouse.
• Data Modelling and Design:
• Designing and creating data models that facilitate efficient querying and reporting.
• Ensuring data accuracy and consistency.
• Performance Tuning and Optimization:
• Ensuring data systems perform efficiently.
• Monitoring query performance.
• Fine-tuning data retrieval processes.
• Data Governance and Security:
• Implementing data governance policies and ensuring data security.
• Implementing access controls.
• Managing data lineage and compliance.
• 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).
• Fluent in English (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).

Bonus Points For

• Experience working in an Agile/Scrum environment.
• Knowledge of Medical industries or Medical Manufacturing business domains.