Data Warehouse Intern: Analyze & Visualize with SQL & Power BI

KLK OLEO; Petaling Jaya; On-site; MYR 13,000 - 27,000; Full time

Job summary

KLK OLEO is seeking an Intern (Business Solutions - Data Warehouse) based at Menara KLK, Mutiara Damansara. You will work on real ERP data, manage SQL Server tables and views, and clean data with SSIS/SSAS while performing Power BI analytics and Excel-based analysis.

You’ll join meetings with the team and stakeholders to deliver insights. The role requires a bachelor’s degree in CS/DS/IT or related technical field, with a basic understanding of SQL and data manipulation.

Qualifications

• Bachelor’s degree in CS/DS/IT or related technical field.
• Basic understanding of SQL and data manipulation techniques.
• Knowledge of SAP ECC6 and Microsoft products is a plus.
• Strong analytical and collaborative communication skills.

Responsibilities

• Handle real life transactional data from ERP systems.
• Manage tables and views in a SQL Server database to support analysis.
• Clean and prepare data using SSIS and SSAS.
• Perform exploratory data analysis with Power BI or Excel.
• Participate in team meetings and stakeholder discussions.

Education

Bachelor’s Degree in CS/DS/IT

Tools

SSIS

SSAS

SQL Server

Power BI

Power Automate

Power Apps

SharePoint

SAP ECC6

Job description

KLK OLEO is seeking an Intern (Business Solutions - Data Warehouse) based at Menara KLK, Mutiara Damansara. You will work on real ERP data, manage SQL Server tables and views, and clean data with SSIS/SSAS while performing Power BI analytics and Excel-based analysis.

You’ll join meetings with the team and stakeholders to deliver insights. The role requires a bachelor’s degree in CS/DS/IT or related technical field, with a basic understanding of SQL and data manipulation.