Senior Analyst, SPSI (Datamart Expert), CFS Finance

Senior Analyst, SPSI (Datamart Expert), CFS Finance

Oversea-chinese Banking Corporation Limited
Singapore
6-10 years
Not Specified

Job Description


Job Description :
About the team
SPSI is part of Finance team in the Consumer Finance Division (CFS) of OCBC Bank Ltd. The primary responsibility of the 10-member team is focussed in the following two areas –
  1. Sales Incentive – Involves designing, planning & implementation of the sales incentive program for Singapore CFS. The team works with business & HR stakeholders to design the incentive schemes on an annual basis. The team will also ensure the correct implementation and payment to over 1000 sales staff across wealth and retail segments monthly as per the incentive scheme. They will also drive any internal, external or regulatory audits pertaining to sales incentive payment. The team will also review the incentive schemes on a regular basis to ensure that the schemes are driving the right behaviour based on in-depth data analysis.
  2. Sales Performance – Team focuses on delivering daily reports to sales management & sales persons (25), regular weekly & monthly performance analysis to drive overall productivity. The team will also engage with the stakeholders to review the overall sales productivity and performance of different group of sales staff and highlight areas of improvement to drive productivity.

About the Role
As the organization is going digital and decisions are being made based on data driven facts, we are looking for dynamic individuals with strong technical skills to join the team. The primary focus of the individual will be to develop the datamart for the team, automate existing reports (currently excel based), educate the existing team members and support in regular/ adhoc analysis. The individual should be a self starter and have had prior experience of working in datamart development. The role will involve lot of work with unstructured/ semi-structured data and the individual should be hands-on to manage and process the information to build a structured datamart for the bank.
Job Responsibilities
  1. Build, maintain & manage datamart with transactional and behavioral attributes. End to end responsibility of data warehouse, data lake and data quality
  2. Automate the existing reports & Incentive calculation (excel based) via SAS/ SQL queries
  3. Build data quality checks on the incoming data from upstream sources
  4. Work with large volume of unstructured & semi structured data to build a robust datamart
  5. Ensuring optimal accuracy and timeliness of data on a real-time basis
  6. Creating and maintaining optimal data pipeline architecture
  7. ETL process by collaborating with the internal and external teams within OCBC
  8. Support the team during planning exercise with adhoc analysis and data support.
  9. Train and guide the team members with technical skills
Qualifications
Required Skills & Experience
  1. 6-10 years of experience in datamart design, development/ implementation (preferably in a financial institution)
  2. Degree in Engineering, Science, Business Analytics from a reputed University
  3. Strong technical (must) skills – SAS Base/ Macro/ EG, SQL
  4. Good to have – Python, QlikView/ QlikSense, Tableau, VBA
  5. Experience in designing the datamart, data governance policies and practices
  6. In-depth knowledge of ETL process and framework
  7. UAT testing/ Designing of test cases will be an added advantage
  8. Ability to work with structured and semi-structured data
  9. Good presentation skills to present the findings to senior management
  10. Excellent written and verbal communication
  11. Knowledge of banking products and processes will be an added advantage
  12. Ability to work and interact with large, complex and diverse teams
  13. Experience of working in a startup environment will be a plus

*LI-JT

Job Details

Employment Types:

Function:

Similar Jobs

People Also Considered

Simple body text this will replace with orginal content