Business Systems Analyst (BI) (Finance)
Summary
Designs BI models and dashboards for finance teams, builds ETL pipelines, and analyzes customer data to drive marketing and lending decisions using SQL, Tableau/Qlik, and predictive modeling.
- Responsible for BI calculation models design and BI dashboards visualization for multiple business units and the management.
- Data analytics, BI algorithm developments well as data-related applications for data-driven business decision and marketing initiatives would be the primary focus.
- Participate in the end to end development cycle of systems from ideas generation, business requirement gathering, user testing, to enhancement.
- Implements system requirements by defining and analyzing business needs.
- Assist Senior Business Analyst with business process re-engineering initiatives.
- Coordinate with internal and external parties for evaluation, selection of applications and tools.
- Coordinate with BI vendors to design and build, ETL, Data warehouse, BI dashboard and analytics solutions for generating useful business insights.
- Communicate with business users on BI objectives and business needs on data, to formulate the design of BI dashboard for visualizing business dynamics and customer data.
- Build the calculation algorithm and customer data modeling for BI analytics.
- Perform analytics for identifying business insights and customer behavioral patterns for better shaping targeted marketing initiatives.
- Design and coordinate segmentation platform development for effective filtering of targeted customer list for data-driven marketing enablement.
- Design pilot exercises to explore suitable machine learning / AI technology for predictive models development.
- Support local and regional projects, contributing to business process design as well as migration plans and strategies.
- Perform systems release support to user acceptance test team or user department.
- Proactively recommend solutions to address business needs.
- Prepare system and operational support documentation.
- Level 2 support and system administration.
- Support and participate in various ad hoc assignments or tasks.
Job Requirements
- Bachelors in Data Science, Data Analytics, Business Analytics, Information Technology or related discipline.
- At least 5-years working experience with 2 years focusing on BI and data analysis and visualization.
- Proven experience in Banking, Finance, Accounting institutions or any other regulated industry sector will be an advantage.
- Experience in BI dashboard (Tableau or Qlik Sense or IBM Cognos BI / Insight or SPA BusinessObjects or etc.) design and BI + ETL implementation projects.
- Knowledge of relational databases programming (SQL), data profiling and data integration will be an advantage.
- Experience in correlation modeling, data predictive modeling, machine learning will be an advantage.
- Experience with Management Reporting / BI / Data warehouse.
- Knowledge of the money lending industry is a definite advantage.
- Positive "can-do" attitude, proactive, independent, self-motivated, result-oriented and able to work with challenges and continually keeps up to date with new technologies and adapt to fast changes.
- Good analytical, problem-solving, communication and presentation skills.
- Good command of English and Chinese (Putonghua is an advantage).