Manager, Analytics Infra & Technology Datamart Specialist

  • Competitive
  • Kuala Lumpur, Federal Territory, Malaysien
  • Festanstellung, Vollzeit
  • Hong Leong Bank Berhad
  • 18 Feb 18 2018-02-18

Manager, Analytics Infra & Technology Datamart Specialist

HLB is embarking on a comprehensive multi-year regional BIG DATA and Analytics transformational journey encompassing products, channels and services across the different markets. We are looking for people with previous decision science and credit analytics experience to lead different initiatives focused on improving decision management, risk analytics, and revenue enhancement across various consumer banking products.

We are looking for talents to work with business owners to ensure that the new/existing databases are consistent with the approved data architecture/governing. This role is required to produce/enhance database schema, analyse and design ETL solutions. Strong understanding of the business and the technical know-how for the data warehouse.

Roles & Responsibilities
• Design & develop ETL solution for the report/datamart
• Managing the database aspects of the reporting and analytics platform(s) to ensure that reporting jobs are successfully run and analytics data aligns to timeliness / completeness requirements.
• Identify and resolve data issues through configuration of data cleansing and de-duplication
• Integrating data sets (data import/export, data cleansing/QA).
• Working with database administrators to ensure that the data warehouse is tuned for optimal performance.
• Working with business analysts and project managers to develop and refine reporting and analytics requirements

Qualifications/Requirements:
• Minimum Bachelor's Degree in Computer Science / Business IT or equivalent
• Minimum 3 years of experience in Teradata, Oracle, and MSSQL, Data Warehouse and building efficient aggregate views
• Good knowledge/hands on of Teradata utilities with strong SQL proficiency and ability to write BTEQ scripts to transform data
• Write, test and implement Teradata Fastload, Multiload and Bteq scripts, DML and DDL
• Good knowledge/hands on experience in database design and development
• Good knowledge/hands on in ETL Tools e.g, SSIS, SAS DI and etc
• Strong analytical mindset, quantitative, problem-solving, and critical thinking skills
• Organised self-starter, able to work with little supervision
• Excellent interpersonal skills and the ability to maintain effective working relationships