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. This position will be report to a supervisor based at Hong Kong and serving the clients in Asian countries.

Job Description (Responsibility)

• Understanding the requirements of Power BI, AI Agent and Machine Learning, and able to use various agents to do development task (“Agentic Data Engineering”).
• Analyze, Design, Develop and implement of Lakehouse and Data Warehouse solution with Microsoft Azure Technologies.
• Develop complex ETL / ELT job for Data Warehouse / Lakehouse primarily with Microsoft Fabric, Azure Synapse, Azure Integration Services and Azure DevOps.
• Create or update documentation with GenerativeAI 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:

• Able to work under minimal supervision, self-motivated, can-do attitude and excellent analytical mind.
• 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, SAP/Oracle/Dynamics 365/Salesforce are preferred.
• Proficient in spoken and written English is a MUST
• Proficient in spoken Cantonese is a MUST.