Graduate Trainee

Job Responsibilities:

• Understanding and documenting business logics from existing system including SSIS, SSRS and store proceduresfrom SQL Server
• Assisting the team to design and build the business data models and dataset
• Building notebook for data cleansing and data transformation
• Preforming data testing and validation to ensure reliability and accuracy of data
• Developing automated reports and dashboards using Power BI, driven by the Data Warehouse / Datamart
• Training and supporting other business functions to work with the Data Warehouse, and build their own dashboards
• In our team, we are working on a migration project, which involves large scale of data and report migration from oldsystem/tools to the new one. As a Data Analyst intern, you will assist on this project and earn end-to-end experiencefrom the ETL process and building BI report.

Job Requirement:

• Experience with SQL and Python programming
• Knowledge on ETL concept and SQL Server, experience with ETL tool and SQL Server will be an advantage
• Experience with Power BI or other visualization solutions
• Strong communication skills in English and Chinese – candidate will be embedded within the business, sitting withinthe Data team and continually interacting with stakeholders across the business
• Bonus: has experience with cloud-based tools and solutions (Azure/ AWS/ Google Cloud Platform)

Why Zurich

At Zurich, we like to think outside the box and challenge the status quo. We take an optimistic approach by focusing on the positives and constantly asking What can go right? 

We are an equal opportunity employer who knows that each employee is unique - that’s what makes our team so great! 
Join us as we constantly explore new ways to protect our customers and the planet.
 

• Location(s):  HK - Hong Kong