Internship Opportunity – IT & Data Analytics Intern

Data Analytics Intern (vacancy available Jan-Apr27)

About the role

We are looking for a motivated and analytical IT & Data Analytics Intern to join our team and support various data, reporting, Excel, and IT-related projects.

This role is suitable for students who are interested in Data Analytics, Business Intelligence, Microsoft Excel, data management, reporting, and IT process improvement. You will have the opportunity to work with real company data, improve existing calculation and reporting processes, and assist in developing more structured and efficient data solutions.

What you'll be doing

• Data Analytics & Data Management

  • Collect, organize, clean, and validate data from different sources.

  • Structure and maintain datasets to ensure data is accurate, consistent, and easy to analyze.

  • Identify missing, duplicated, inconsistent, or incorrect data and assist in resolving data issues.

  • Perform basic data analysis to identify trends, patterns, and useful business insights.

  • Assist in preparing data summaries and analysis for management and internal teams.

  • Maintain proper data documentation, definitions, and calculation logic.

  Microsoft Excel & Calculations

  • Develop and maintain Excel spreadsheets for business and operational requirements.

  • Create and improve Excel formulas for calculations and data processing.

  • Work with functions such as XLOOKUP, VLOOKUP, INDEX/MATCH, IF/IFS, SUMIFS, COUNTIFS, FILTER, TEXT, and other relevant functions.

  • Create and maintain Pivot Tables, Pivot Charts, dashboards, and data summaries.

  • Develop reusable Excel templates to standardize calculations and reporting.

  • Review existing spreadsheets and improve their structure, formulas, and usability.

  • Assist in troubleshooting Excel calculation and data-related issues.

  • Reduce manual work by developing more efficient Excel-based solutions.

  Reporting & Business Intelligence

  • Assist in preparing daily, weekly, and monthly reports.

  • Convert raw data into meaningful tables, summaries, and visual reports.

  • Assist in developing dashboards and KPI reports.

  • Support the preparation of management reports and business performance analysis.

  • Assist in identifying opportunities to improve reporting accuracy and efficiency.

  • Where applicable, assist with Power BI dashboards and data visualization.

  IT & Process Improvement

  • Work closely with the IT team to support data-related and system-related projects.

  • Assist in improving internal workflows and data processes.

  • Support data migration, consolidation, and restructuring projects.

  • Assist in documenting system processes, data structures, workflows, and calculation methods.

  • Identify repetitive manual tasks and explore opportunities for automation.

  • Assist with Microsoft 365, Power Automate, VBA, or other tools used for process automation.

  • Support other IT and data-related projects as assigned

What we're looking for

• Currently pursuing a Diploma/Degree in Information Technology, Computer Science, Information Systems, Data Analytics, Business Analytics, Statistics, or a related field.

• Good understanding of Microsoft Excel.

• Strong interest in Data Analytics and Business Intelligence.

• Basic understanding of data cleaning, data structuring, calculations, and analysis.

• Good analytical and problem-solving skills.

• Strong attention to detail and accuracy.

• Able to work with large amounts of data and identify inconsistencies.

• Willing to learn new IT and data-related tools.

• Able to work independently and as part of a team.

Skills That Will Be an Advantage

Candidates with knowledge or experience in any of the following will have an added advantage:

• Advanced Microsoft Excel

• Pivot Tables & Pivot Charts

• Power BI

• Power Query

• Power Automate

• VBA / Excel Macro

• SQL / Database

• Microsoft 365

• Data visualization

• Dashboard development

• Basic programming or scripting

• Data cleaning and transformation

What we offer

• During the internship, you will gain practical exposure to:

  • Real-world data analytics and data management

  • Advanced Excel and business calculations

  • Data cleaning and data structuring

  • Reporting and dashboard development

  • Business Intelligence concepts

  • Data visualization

  • Process improvement and automation

  • Microsoft 365 and IT systems

  • Working with real operational and business data

  • Translating business requirements into practical data solutions

  
  

About us

MLM Packaging Sdn. Bhd. is a leading provider of high-quality packaging solutions for a variety of industries. With over 20 years of experience, we are committed to delivering innovative and sustainable packaging products to our customers. Our team of dedicated professionals is driven by a passion for excellence and a commitment to continuous improvement.

If you're ready to kickstart your IT career, we'd love to hear from you. Only Final Year Interns need apply.