Background
The company is passionate about transforming investment management through data and system. To
support the mission of firmwide investment management transformation, the Project team is 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, the Project team is currently searching for a Business Intelligence (BI) and Reporting Engineer to be housed within the project team to work with stakeholders to produce organisation reporting and business intelligence needs. Business Intelligence Analyst will also be responsible to learn and analyse available data in IDW and putting it into a format that others can easily interpret.
Expected outputs are creation of ongoing reports as well as new reports for stakeholders touse in a business setting. The Business Intelligence (BI) and Reporting Engineer will be responsible for the delivery of this initiative while working together with the existing team during the tenure of the one-year contract and renewable.
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.
Knowledge, Skills, and Abilities
1. Proven work experience working with database and business intelligence system, and process automation.
2. Solid knowledge of database programming language to write code mainly SQL, NoSQL. Solid knowledge in visualisation tools to assist with dashboard development and report generation (e.g., MicroStrategy, Qlik, Power BI).
4. Strong foundation in SQL and a deep understanding of Entity-Relationship Diagrams (ERDs) and data mapping. This role involves extracting, transforming, and loading (ETL) data from various sources (Oracle, MSSQL).
5. Experience with facilitating data exchange between systems (e.g., API, SFTP).
6. Experience working in an Agile/Scrum development process, managing various projects, maintenance, technical support, etc.
7. Ability to build processes that support data transformation, workload management, data structures, dependency, and metadata.
8. Excellent analytic skills associated with working on structured and unstructured datasets.
9. Excellent problem solving and complex troubleshooting methods.
10. Excellent communication skills in both written and verbal.
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
