Senior Business & Data Analyst
Zurich Insurance
full-time
Posted on:
Location Type: Hybrid
Location: Guang Zhou • 🇨🇳 China
Visit company websiteJob Level
Senior
Tech Stack
AzureETLPythonSQLSSIS
About the role
- Build / maintain business datamarts to visualize KPIs, metrics in reports / dashboards to empower data analytic capability across functional teams for Life Business
- Understand the Company’s business processes and applications, including their effect on data and reporting, apply the knowledge gained in designing datasets, reports and dashboards
- Analyze business data to identify actionable insights for management and stakeholders
- Drive analysis on customer segmentation / profiling and campaign performance
- Analyze and verify requirements for dashboards and reports by working with requesters, SMEs and partners
- Supporting the continuous enhancement, maintenance of datawarehouse, ETL processes, reports and dashboards
- Work with IT and partner teams for project implementation
- Prepare and execute test plan, test cases, as well as user training
- Assemble system performance statistics, analyze them and make changes for continuous performance / capacity improvements
- Understand / investigate data issues and derive solutions
- Create / maintain data dictionary, user guide and other related documentation
Requirements
- Bachelor degree with 3+ years of relevant experience in Data / BI domains
- Experience in data ingestion / ETL, data-modeling for datawarehouse
- Highly proficient in SQL
- Experience in PowerBI or similar visualization / dashboarding tools
- Experience in Microsoft SSIS or similar ETL tools
- Experience in Life Insurance (GI – General Insurance an advantage)
- Experience in Azure, Databricks, Python an advantage
- Excellent skill in writing and communicating in English / Mandarin / Cantonese
Benefits
- Health insurance
- Professional development opportunities
- Flexible working arrangements
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data ingestionETLdata modelingdata warehouseSQLPowerBIMicrosoft SSISAzureDatabricksPython
Soft skills
communicationanalysisproblem-solvingcollaborationtraining