Bi Intern
CurrentI am currently working on a cloud-based property investment and management platform targeting the Data Integration of New Zealand and Australia property data. I’m also designing the Data Warehouse Solution for the visualization and reporting services. My main responsibilities are as follows:*Data cleansing and standardization using MS Excel and Power Query for complex structured and unstructured datasets extracted from multiple government data sources* Designing of the Data Warehouse and SSIS package consistent with the existing design* Creating SQL queries, stored procedures, and functions to implement medium-to-complex business logic for reporting and analysis purposes* Creating, maintaining, and optimizing SSRS reports using a data warehouse as the data source.* Using SSQL Server, SSIS, Power Query, SSRS and Power-BI to develop data driven business solution* Creation of SQL queries, stored procedures, and functions to implement medium-to-complex business logic for reporting and analysis purposes* Working as an individual as well as in a team to complete task in a timely manner* Participating in team meetings and lodge project status via scrum updates* Supporting and providing guide for mentees on their basic to advanced tasks
