Datawarehouse Consultant (BI and Reporting Engineer)

JOB DESCRIPTION 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. 3. 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