Developer, Data Warehouse

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 looking for a Data Warehouse Developer. 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.

About Ambu

Ambu has been bringing the solutions of the future to life since 1937. Today, millions of patients and healthcare professionals worldwide depend on the efficiency, safety and performance of our single-use endoscopy, anaesthesia, and patient monitoring solutions. We continuously look to the future with a commitment to deliver innovative quality products that have a positive impact on patient care and the work of healthcare professionals. Headquartered near Copenhagen in Denmark, Ambu employs approximately 4,500 people in Europe, North America and the Asia Pacific.