TC ITECH

Consulting | Full Time

BI Technical Consultant

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.

In this role, you will:

  • 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