As a Consultant - BI Technical Consultant, you will be working with the Functional Consultant to develop BI model and ETL processes to populate data from various source systems into the BI data mart. The candidate will have strong SQL skills and dimensional data schema knowledge.
Design and develop ETL processes to populate data into data mart.
Develop BI dashboard and report using Business Intelligence tool.
Perform data profiling, data modeling and design of data mart schema.
Understanding functional specification and translate into technical specification.
Produce technical documentation such as Entity relationship diagram, data transformation flow, and systems Documentation.
Collaborate with other technical teams to deliver stable, highly available back end platforms.
You are a great fit if you have:
Candidate must possess at least a Bachelor’s Degree in Information Technology or related IT field.
Fresh graduate or minimum of 1 year working experience with one or more Business Intelligence tools like Google Data Studio, Power BI, QlikView, or Tableau.
Experience in developing Microsoft SQL Server Stored Procedures, Views, Scalar-Valued & Table-Valued Functions.
Experience in designing and building extract, transformation, and load (ETL) processes to convert operational transactional data into dimensions and fact tables.
Experience in Google Cloud Platform, Big Data, Python or R programming is an added advantage.
Knowledge in Business Intelligence / Data Warehousing implementation methodologies and architectures.
Ability to work under time pressure, manage multiple groups of users while maintaining a positive and patient attitude
Other position that you may interested
Related vacancy to the one you are viewing right now.
As Application Management Services (AMS) Consultant, you will be responsible for the day-to-day maintenance of the application systems in operation, including tasks related to identifying and troubleshooting application issues. Resolve…