Intern Data Analyst

Pune - India

Monthly Salary: Not Disclosed

Posted on: 20 hours ago

Vacancies: 1 Vacancy

Job Summary

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.

Required Skills:

Advanced Excel VLOOKUP INDEX-MATCH data visualization tools data and regression analysis Pivot Tables Data Cleansing and Manipulation

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 fro...