Job ref no.: CT3128011-01#9786

Senior Data Engineer/ Senior System Analyst – Data warehouse - Insurance (ETL / PowerBI)(40k – 50k)

Recruit Logic Limited

The client is a global prestigious MNC Insurance Group, is now seeking a new headcount for Senior Data Engineer/ Senior System Analyst – Data warehouse - Insurance (ETL / PowerBI) (HKD40k – 50k) to join their team


  • Design, build and maintain datawarehouse / datamart models - a centralized repository of integrated data from various data sources, and required components such as ETL processes, reports and dashboards
  • Design and create end-to-end ETL processes utilizing tools such as MS SQL Server Integration Services (SSIS), SSAS or others 
  • Utilize Microsoft Power BI and SQL Server Reporting Services in designing and building reports and dashboards
  • Define and create business datamarts / datasets, measures, KPIs and dashboards to empower data analytic capability across functional teams for Life Business
  • Study and understand the Company’s business processes and applications, including their effect on data and reporting, and applies the knowledge gained in designing datasets, reports and dashboards
  • Identify and document requirements for DWH components, dashboards and reports by working with IT and SMEs
  • Prepare test plan, test cases / scripts, perform testing and user training 
  • Assemble performance statistics, analyzes them and makes recommendations for improvements
  • Establish data dictionary and other related documentation


  • Bachelor degree with minimum 5 years of relevant experience in Business / Requirement Analysis, Data Transformation & Visualization, preferably in insurance industry
  • Proven experience in data-mapping, ETL process, data-modeling and reporting / dashboard functions is required
  • Sound experience using Microsoft Azure, Microsoft SQL Server, SSIS, SSRS, SSAS, PowerBI 
  • Good knowledge of insurance products, operations, policy admin system would be an advantage
  • Good analytical, problem solving and communication skills  
  • Able to articulate business processes / requirements to all levels
  • Proficient working independently and in a team setting
  • Have can-do attitude and willing to go the extra mile
  • Possess excellent skill in writing and communicating in both English and Cantonese

If you would like to apply for this Senior Data Engineer/ Senior System Analyst – Data warehouse – Insurance (ETL / PowerBI)(HKD40k – 50k) role or find out more, please click "Apply Now" or send your resume to arthurwong(at) quoting the reference: 137315

All applications applied through our system will be delivered directly to the advertiser and privacy of personal data of the applicant will be ensured with security.
More job information
Job ref no. CT3128011-01#9786
Job Function
  • Quarry Bay
Employment Term
  • Permanent
  • Full-time
  • 5 years
Career Level
  • Middle management level
  • Degree
  • 5-day week
  • Dental plan
  • Discretionary bonus
  • Insurance plan
  • Medical plan