Support design and build of the business Data Warehouse / Datamart models, by understanding the business needs and identifying best practice solutions including documenting requirements, working with IT and SME’s, ETL development, testing etc
Support design and build of ETL processes utilizing tools such as SSIS, SSAS or others
Gain an understanding of the business, and apply this knowledge in developing automated reports and dashboards using Power BI, driven by the Data Warehouse / Datamart
Train and support other business functions to work with the Data Warehouse, and build their own dashboards
Plan and implement migration of legacy BI tools and solutions to newer architecture
Support Data Scientists, Actuaries, and others by helping to extract data, supporting building proof of concepts etc
Support good data governance by establishing data dictionaries, monitoring data quality, and preparing related documentation / dashboards
Strong knowledge and hands-on development experience with SQL Server and or Oracle
ETL knowledge and experience with SSIS, SSAS or similar
Experience with Power BI or other visualization solutions. Qlickview experience also a plus
Experience with cloud-based tools and solutions (in particular Azure cloud), ideally some knowledge of Datafactory and Databricks
Strong communication skills in English and Chinese candidate will be embedded within the business, sitting within the Data team and continually interacting with stakeholders across the business
Knowledge of insurance company products and operation and data is ideal
Strong at working in an agile and dynamic environment. Lead and manage IT aspects of the project as required
Candidate with less experience will be considered as Business & Data Analyst
Are you interested in working for a company that values its people and put's its customers and employees at the heart of everything we do?
Are you looking for growth opportunities beyond simply a career? Then Zurich could be just the place for you!
Our people are the heart & soul of Zurich. Together we are committed to delivering on our purpose - Let’s Create a Brighter Future Together!
Our ambition is to become one of the most responsible and impactful businesses in the world. To get there we hire and develop the best talent available.
With Zurich, you can expect to work on challenges that will help you grow and to collaborate with a diverse and inclusive global team.
People are Zurich’s most important asset. Their varied skills, perspectives and experiences drive innovation. And they reflect the breadth and diversity of our customers, suppliers, communities and investors around the world.
We are committed to attracting and retaining talented individuals from a variety of backgrounds and experiences. Zurich does not discriminate based on race, ethnicity, religion, national origin, sex, gender expression, gender identity, genetic information, age, disability, protected veteran status, marital status, sexual orientation, pregnancy or other characteristics protected by applicable law.
Location(s) : HK - Hong Kong