Lloyd Karson is an international leading provider of permanent recruitment, contract professionals and talent management services worldwide.We assists corporations in identifying, assessing and recruiting mid-level management to senior executive talent across various industries. With our headquarter in Australia, we are expanding our business reach across Asia Pacific.
The Hong Kong office specializes in human resources & business support, information technology, sales & marketing, accounting & finance, property & construction, supply chain, and logistics & procurement.
The client is a global prestigious MNC Insurance Group, is now seeking a new headcount for Senior Data Analyst / 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 Analyst / 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)lloydkarson.com quoting the reference: 137212
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.