Business Intelligence (BI) Technical Consultant

Job Summary : As a Bl 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. Job Responsibilities : 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. Qualifications : Candidate must possess at least a Bachelor's Degree in Information Technology or related IT field. A minimum of 1 year working experience with one or more Business Intelligence tools like Google Data Studio, Power Bl, QlikView, or Tableau. Experience in developing Microsoft SOL 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. Strong command of the English and comfortable with process/functional documentation. Self-motivated with attention to detail. Organizes own workload, sets priorities and works within deadlines. Excellent organization, communication and interpersonal skills. Ability to process assignments in an efficient, accurate and timely manner. Able to work with minimum supervision, as well as able to contribute to team development. Professional certification will be an added advantage. Experience in automotive industry an added advantage. * Only shortlisted candidates will be notified.