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

Responsibilities:

  • 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

Requirements:

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