Posted on 2021-10-11

Sr Data Analyst / Senior System Analyst – Data warehouse - Retail / FMCG (ETL / SSIS)(HKD40k – 50k)

Lloyd Karson International Limited

The client is a growing Retail group, is now seeking a new headcount for Senior Data Analyst / Senior System Analyst – Data warehouse - Retail / FMCG (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 Analyst / Senior System Analyst – Data warehouse – Retail / FMCG (ETL / PowerBI)(HKD40k – 50k) role or find out more, please click "Apply Now" or send your resume to arthurwong(at) quoting the reference: 137214

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
  • 35,000 - 55,000 / month (negotiable)
Job Function
  • Quarry Bay
Employment Term
  • Permanent
  • Full-time
  • 5 years
Career Level
  • Middle management level
  • Degree
  • 5-day week
  • Dental plan
  • Flexible working hours
  • Insurance plan
  • Shuttle bus