Data Engineer

Ambu; Penang; On-site; MYR 90,000 - 150,000; Full time

Job summary

Ambu in Penang, Malaysia is seeking a Data Systems Specialist / Data Engineer to own data warehousing, ETL development, modelling, and governance. You will maintain data integrity, build scalable data pipelines, and enable self-service reporting for business users.

The role requires hands-on experience with SQL, MS SSIS, Azure Data Factory, Power BI, and data integration tools, along with a solid foundation in Ralph Kimball methodologies and data security practices.

Qualifications

• At least 3 years in data warehousing, data engineering, or BI development.
• Experience with SQL, data integration, data quality checks and modelling.
• Proficiency in MS SSIS, Azure Data Factory, SQL Server and data integration tools.
• Familiarity with Agile/Scrum is a plus.
• Knowledge of medical manufacturing domain is beneficial.

Responsibilities

• Maintain and improve data warehouse integrity and availability.
• Design and optimize ETL processes and data flows.
• Create data models for efficient querying and reporting.
• Ensure data governance, security, and compliance.
• Develop dashboards and reports for business users.

Skills

SQL

Data Integration

Data Modelling

ETL Development

Power BI

MS SSIS

Azure Data Factory

Azure DevOps

Tools

MS SSIS

Azure Data Factory

SQL Server

Power BI

Tableau

Qlik

Job description

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.