Data Analyst (Banking Enterprise Data Management)

Requirements:

- - Min bachelor degree or professional qualification in Computer Science with at least 3 years of work experience in banking industry, preferably with business / functional domain knowledge

- - Experience in gathering and documentation of business requirements

- - Strong knowledge in SQL and familiar with Banking products

- - Possess good analytical Skills and problem solving

- - Knowledge of architecting and modelling in systems integration, data warehousing, BI Tools, Big Data platforms and experienced in user of analytical/query and visualization tools. Must be able to query and understand database solutions.

- - Experience in designing, developing and documenting data-driven solutions: including capturing architecture, meta data systems, data dictionaries, databases and applications

- - good team player who possess drive and initiative

- - excellent written/oral communication skills to effectively interact with different stakeholders and external vendors, able to work independently under pressure.

Responsibilities:

- Assist Enterprise Data Management (EDM) on user queries, data investigation, user acceptance testing, data quality and completeness check, reconciliation, and documentation on EDAG.

- Gathering and documenting business requirements & functional specifications on data related initiatives.

- Perform data investigation and data analysis to support Bank wide users' queries on EDAG

- Perform data profiling and gap analysis, source to target mappings, data issue capturing, resolution and escalation.

- Provide end-to-end project delivery support, including requirements walkthrough, user acceptance testing, defect support, continuous validation and assisting with rollout activities.

- Able to construct medium to complex SQL queries for data quality checks, reconciliation and exception investigation

- Provide support to Bank wide users’ requests

- Build and manage dashboards for monitoring and analytical purposes.

- Documentation and Administrative support – coordination and assistance in the project implementation, system and process documentation, minutes taking etc.

- Foster strong working & collaborative relationships with the business & technology stakeholders.

Required Skills:

- Strong knowledge of SQL and familiar with banking products.

- Proficient in MS Excel Pivot Table, Vlookup etc.

- Possess good analytical skills and problem solving skills

- Soft skills, able to work independently with users on requirements gathering or issues investigation

- Familiar with general data architecture concept, including data warehouse and big data technology is preferred.

- Knowledge on Hadoop and Discovery tools (eg Qliksense, HUE)

- Familiar with Metadata tools (eg Informatica Metadata Manager)