Senior Data Engineer - Urgent Role

Job Responsibilities

1. Gather user requirement, data mapping and collaborate with related stakeholder within IT/Business to understand data requirements and deliver the data infrastructure that supports business goals.
2. Design ETL process according to business requirements, ensuring efficient data flow from source to destination.
3. Design & develop pipelines that automate data movement & transformation using available ETL tools from source data to target database for reporting & dashboard creation
4. Implement measures to ensure data accuracy and integrity throughout the ETL process. This includes data validation, cleansing, deduplication, and error handling to ensure reliable and usable data.
5. Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
6. Oversee and govern the expansion of existing data architecture by optimizing data query performance via best practices, addressing bottlenecks, and ensuring the ETL system is able to handle the volume, velocity, and variety of data.
7. Maintain ETL system by monitoring its performance, updating ETL scripts and workflows as business requirements change, and ensuring the system scales with data growth.
8. Pro-active support on end-to-end data migration project as it related to data move/transform from legacy to new system.
9. Creating and maintaining documentation for ETL processes, including data mappings, transformation logic, and data flow diagrams.
10. On-going quality control and corrections of the data in the central database to ensure the data accuracy, data quality and data completeness.
11. Provides operational support related to data.

Job requirements

• Minimum Degree in Information Technology, Computer Science, Management Information or equivalent. Data engineering certification (i.e, IBM Certified Data Engineer) would be an added advantage.
  Experience.
• Minimum 4 - 7 years related experience in Data Management / Data Warehouse / Data Analytics.
  Knowledge:
• Knowledge and experience of SQL knowledge is essential for this position. 
• Good understanding and knowledge in data warehouse design and concept with hands-on experiences in any ETL tools (especially Informatica)
• Experience in scripting language (i.e. Phython) is a plus
  Skills/Competencies:
• Excellent communication, writing, analytical thinking, problem-solving, troubleshooting, and interpersonal skills.
• Preferable: Microsoft Excel skills. Excellent analytical, data mining and tactical problem-solving abilities.