Epicareer Might not Working Properly
Learn More

Business Intelligence Analyst

Salary undisclosed

Apply on


Original
Simplified

Role: Business Intelligence Analyst

Job description:

The company is passionate about transforming investment management through data and system. To support the mission of firmwide investment management transformation, currently undertaking a few IT-related projects such as onboarding a new Investment Management Core System (ICMS), Investment Data Warehouse (IDW) systems, and others.

To assist with this initiative, Project team is currently searching for a Business

Intelligence (BI) Analyst to be housed within the project team to work with stakeholders to produce organisation reporting and business intelligence needs.

Principal Accountabilities :

1. Analyze reporting requirements and recommend to the project team on the best

method/approach for BI implementation.

2. Write and optimise data queries to retrieve, update, and manipulate data within data warehouse that meets specific business requirements via SQL Query/ Power Query.

3. Develop BI solutions (dashboard visualisation & reporting query) connected to the data warehouse for quality, maintainability, reusability, and rapid report/dashboard delivery (e.g., MicroStrategy, Qlik, Power BI).

4. Work with various stakeholders through various aspects of the data warehouse which include design, testing (SIT, implementation, and ongoing support of critical components such as database connectivity, data models, data warehouse

architecture, ETL processes, dashboarding tools, performance optimization, and

server processes.

5. Collaborate with internal and external stakeholders to fulfil data requests, covering extraction, new requirements, distribution, and disposal.

6. Refine and automate regular/repeated reporting tasks, track issues, optimise

extractions, and document changes in relation to data extraction and dissemination.

7. Perform administrative tasks to ensure project efficiency, including document

preservation, reporting, and maintaining data warehouse system and data services.

Education, Experience and Certifications :

1. Bachelor/Master's degree in Computer Science, Information Technology,

Management Information Systems, Business Administration, Engineering,

Mathematics, or Statistics

2. A minimum of 5 years related experience in SQL development, dashboarding and business solutions.

3. Experience in cloud database solution is an added advantage.

4. Well understanding of investment and market data is an advantage

Skills Required

Business Intelligence

NoSQL

Power BI