Datawarehouse Consultant (BI and Reporting Engineer)JOB DESCRIPTION
Principal AccountabilitiesAnalyze reporting requirements and recommend to the project team on the best method/approach for BI implementation.
Write and optimise data queries to retrieve, update, and manipulate data within data warehouse that meets specific business requirements via SQL Query/ Power Query.
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).
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).
Collaborate with internal and external stakeholders to fulfil data requests, covering extraction, new requirements, distribution, and disposal.
Refine and automate regular/repeated reporting tasks, track issues, optimise extractions, and document changes in relation to data extraction and dissemination.
Perform administrative tasks to ensure project efficiency, including document preservation, reporting, and maintaining data warehouse system and data services.
Knowledge, Skills, and AbilitiesProven work experience working with database and business intelligence system, and process automation.
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).
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).
Experience with facilitating data exchange between systems (e.g., API, SFTP).
Experience working in an Agile/Scrum development process, managing various projects, maintenance, technical support, etc.
Ability to build processes that support data transformation, workload management, data structures, dependency, and metadata.
Excellent analytic skills associated with working on structured and unstructured datasets.
Excellent problem solving and complex troubleshooting methods.
Excellent communication skills in both written and verbal.
Education, Experience and CertificationsBachelor/Master's degree in Computer Science, Information Technology, Management Information Systems, Business Administration, Engineering, Mathematics, or Statistics.
A minimum of 5 years related experience in SQL development, dashboarding and business solutions.
Experience in cloud database solution is an added advantage.
Well understanding of investment and market data is an advantage.
CompanyAptude Technology Services Sdn.
Bhd., a New Era Technology company is a Kuala Lumpur, Malaysia based private company, offering IT Services like - ADMS, Data Analytics, Digital Transformation, Project Management, IT Infrastructure Support Services, etc.
to cater to the IT services needs of our customers in Malaysia.
Our company intends to build a greater capacity to undertake IT projects of bigger scale as well as to provide advance technology services to propel Malaysian reputation into international market by leaps & bounds.
We also intend to compete with the international market in Information Technology capabilities and create more employment opportunities and more innovative and creative minds in Malaysia.
Aptude Technology Services Sdn.
Bhd.
believes in delivering quality works and customers satisfaction, and this belief will not change or be compromised in the future.
In short, Aptude Technology Services Sdn.
Bhd.
looks at long term business and delivers what it promises.#J-18808-Ljbffr