Intern - Data Analyst

Responsibilities

• Reporting: Create and maintain detailed reports and dashboards to visualize key performance indicators (KPIs) and communicate findings to stakeholders effectively.
• Data Analysis: Perform thorough data analysis using Advanced Excel techniques to derive insights and identify trends from large datasets.
• Quality Assurance: Ensure data accuracy and integrity by conducting regular quality assurance checks and validation procedures.
• Data Cleansing and Manipulation: Clean, transform, and manipulate data as necessary to ensure accuracy and reliability for analysis purposes.
• Statistical Analysis: Utilize statistical methods and techniques to interpret data and provide actionable recommendations based on findings.
• Automation: Develop and implement automation processes using Excel macros and Power Query.
  

Desired Skill Set

• Strong proficiency in Advanced Excel, including Pivot Tables, Power Query, VLOOKUP, INDEX-MATCH, array formulas, data validation, conditional formatting, and other advanced functions.
• Experience working with large datasets and performing data and regression analysis using Excel.
• Familiarity with data visualisation tools such as Power BI.
• Excellent analytical and problem-solving skills with keen attention to detail.
• Ability to work independently as well as collaborate effectively in a team environment.
• Strong communication skills to convey insights clearly to non-technical stakeholders.