Data Management Analyst

Summary: The Business analyst is a hands-on role to develop detailed business requirements, conduct stakeholder interviews to gather necessary requirements and collaborate with the development team to automate/migrate reporting capabilities and business intelligence. This data initiative project will enable the bank to streamline and reduce manual processes, and gain deeper insights into their business while meeting increasing regulatory and risk compliance requirements. The ideal candidate possesses fundamental understanding of Financial Services Industry (FSI) experience with in data and analytics domain.

Proficiency in speaking and writing in Chinese/Mandarin is MANDATORY for managing communications with the Head Office.

Responsibilities:

• Develop business and functional requirements for report automation/migration and system implementation
• Assist the team leads in eliciting business requirement from the business stakeholders, manage the planning and execution of requirements gathering workshop
• Conduct stakeholder meetings independently, with minimal supervision, to gather necessary requirements, and develop detailed business requirements document
• Design and maintain workflows based on requirements collected, able to provide solutions by analyzing requirements received from multiple teams and technical capability
• Design and implement data lake ingestion and data warehouse construction
• Develop SQL queries in the reporting platform to extract data from data lake and data warehouse to build automated reports
• Collaborate with IT teams during SDLC cycle, not limited to, includes BRD discussion, data warehouse construction, coding troubleshooting, UAT testing, etc.
• Lead the User Acceptance Testing, develop UAT plan and create test cases, report testing status/progress
• Assist in addressing issue identified in day-to-day operations by collaborating with concerned stakeholders for effective issue resolution
• Create and maintain user manuals and procedures related to reports automated, as needed
• Manage all project management activities, including but not limited to, status updates, project plan updates/maintenance, socialization of deliverables with the stakeholders etc.
• Proactively identify and mitigate risks before they become roadblocks

Education and Experience Requirements:

• Bachelor/Master degree in finance or related field
• Advanced degree in data analytics, business analysis, etc. is preferred

Skills and Knowledge:

• 4+ year experience in data management and business analysis, preferably in the banking sector
• Should have experience on data integration, data warehouse, data migration, report automation and process management tools
• Should be able to read and write SQL
• Should understand the architecture and concept of data lake and data warehouse related knowledge and design
• Must have strong written and verbal communication skills and suitable in teamwork environment
• Must be proactive and analytical to evaluate and solve problems independently
• Must be able to work under pressure with the team and deliver results in a timely manner
• Must be willing to learn, self-driven and responsible