Job Summary: As a 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 translating it 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.
- Candidate must possess at least a Bachelor's Degree in Information Technology or related IT field.
A minimum of 2 years of 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, and 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.
Job Types: Full-time, Permanent
Pay: RM3,- 00 - RM6,000.00 per month
Benefits: - Maternity leave
Opportunities for promotion
Professional development
Schedule:
Application Question(s):- How long is your notice period
How much is your current salary / last drawn salary
- How much is your expected salary
Are you comfortable working in fully onsite setting
Experience:- Power BI: 2 years (Required)
Develop BI Dashboard: 2 years (Required)
