Qualifications:
- Candidate must possess at least Bachelor’s Degree in Computer Science
- Proficient in SQL Server Query (intermediate to advanced) is a must
- Proficient in ETL Tools (SSIS)
- Proficient in Data Warehouse concept (Fact, Dim, Star Schema, Snowflake Schema) is a must
- Proficient in DAX syntax
- Proficient in OLAP
- Proficient in Power BI
Job description:
- Create and manage ETL from data source
- Create fact and dim table
- Manage OLAP cube and measure
- Display data on presentation layer (power BI, tableau/ qlickview, etc)
- Handle Datawarehouse Management inquiry & ad hoc request from business users.
- Manage ETL batch job monitoring