Senior Data Engineer

Company Description

HSO is a trusted advisor and one of the world's leading Microsoft Data & AI, Business solution and implementation partners, dedicated to helping organizations accelerate digital transformation. Founded in 1987, HSO has a global presence with over 33 offices across the Americas, Europe, and Asia.

Job Description (Responsibility)

• Understanding the requirements of Power BI, AI Agent and Machine Learning.
• Analyze, Design, Develop and implement of Lakehouse and Data Warehouse solution with Microsoft Azure Technologies.
• Develop complex ETL / ELT job for Data Warehouse / Lakehouse.
• Create or update documentation in support of development, which may include detailed specifications and data flow diagrams.
• End to end involvement with the team from development, implementation, UAT till go-live support.

Requirements:

• Degree in Computer Science / Information Technology and / or relevant disciplines
• At least 3 years working experience related to building Lakehouse or Data Warehouse, and ETL development. Build from zero is highly appreciated.
• Proficiency level of MS SQL and Python is a must.
• Knowledge about Microsoft Fabric, Azure Data Factory, Azure Synapse Analytics, Databricks, Azure Data Lake, Microsoft Purview is a plus.
• Excellent knowledge of medallion architecture design, software development processes.
• Knowledge in using BI tools, SSIS, SSAS is an added advantage.
• Knowledge in data governance, database security, Azure network security is an added advantage.
• Prior experience in any CRM/ERP/POS/ECOM is a plus, Dynamics 365 is preferred.
• Good analytical mind, self-motivated and able to work under minimal supervision.
• Proficient in spoken and written English is a MUST
• Proficient in spoken and written Mandarin is a MUST