Data Analytics & Insight Manager, Banking

Peoplebank Hong Kong Limited; Hong Kong; On-site; HKD 900,000 - 1,300,000; Full time

Job summary

Peoplebank Hong Kong Limited seeks an Data Analytics & Insight Manager to drive end-to-end management information, data engineering, and visualization initiatives across commercial and digital banking channels. You will build interactive dashboards, optimize SQL-based data marts, and automate workflows with Python to deliver actionable insights for executives.

The role requires 5+ years of data analytics experience in banking, strong SQL and Python skills, and a solid data modeling foundation.

Qualifications

• University degree in Quantitative Analysis, Statistics, Computing, or a related discipline.
• At least 5 years of experience in data analysis, database management, software engineering, and reporting development.
• Strong hands-on capability in SQL, Python, or Excel VBA.
• Background in commercial or digital banking with a solid understanding of sales and service performance metrics is an advantage.
• Solid understanding of data modeling concepts, including facts/dimensions, KPI calculation logic, and data quality controls.
• Experience building production-grade reporting assets with visualization tools such as QlikSense, QlikView, or Tableau.

Responsibilities

• Deliver end-to-end MI and performance reporting across sales tracking, service productivity, conversion funnels, and channel performance.
• Translate business questions into analytical approaches, identifying performance drivers and providing actionable recommendations.
• Develop and maintain interactive dashboards with clear KPI hierarchies, drill-through designs, and optimized data models.
• Build robust datasets and data marts using modern ELT patterns, version-controlled transformations, and automated testing.
• Write efficient, maintainable SQL queries utilizing window functions, CTEs, and query optimization techniques.
• Automate reporting workflows and perform statistical analysis, segmentation, or forecasting using Python and SQL.

Skills

SQL

Python

Excel VBA

Data analysis

Data modeling

Tableau

QlikSense

QlikView

Tableau/BI tooling

Education

University degree in Quantitative Analysis/Statistics/Computing

Tools

SQL

Python

Excel VBA

QlikSense

QlikView

Tableau

Job description

Data Analytics & Insight Manager, Banking

Summary You will drive the end-to-end management information, data engineering, and visualization initiatives to deliver actionable performance insights across commercial and digital banking channels. By building interactive dashboards, optimizing SQL-based data marts, and automating workflows using Python, you will transform complex data into executive-ready narratives that directly influence strategic business decisions and optimize operational productivity.

Responsibilities

• Deliver end-to-end MI and performance reporting across sales tracking, service productivity, conversion funnels, and channel performance.


• Translate business questions into analytical approaches, identifying performance drivers and providing actionable recommendations.


• Develop and maintain interactive dashboards with clear KPI hierarchies, drill-through designs, and optimized data models.


• Build robust datasets and data marts using modern ELT patterns, version-controlled transformations, and automated testing.


• Write efficient, maintainable SQL queries utilizing window functions, CTEs, and query optimization techniques.


• Automate reporting workflows and perform statistical analysis, segmentation, or forecasting using Python and SQL.

Requirement

• University degree in Quantitative Analysis, Statistics, Computing, or a related discipline.


• At least 5 years of experience in data analysis, database management, software engineering, and reporting development.


• Strong hands-on capability in SQL, Python, or Excel VBA.


• Background in commercial or digital banking with a solid understanding of sales and service performance metrics is an advantage.


• Solid understanding of data modeling concepts, including facts/dimensions, KPI calculation logic, and data quality controls.


• Experience building production-grade reporting assets with visualization tools such as QlikSense, QlikView, or Tableau.