Walk-in | Data Analyst

Spectra Medical India; Chennai; On-site; INR 600,000 - 1,200,000; Full time

Benefits offered by this job

Power BI training

Job summary

Spectral Medical India seeks a data analyst to extract data from Excel, Google Sheets, and databases, and build dashboards linking KPIs across industries. The role emphasizes translating data into actionable visuals for stakeholders in Chennai.

The candidate will leverage Pivot tables and Power BI to deliver interactive reports, enabling data-driven decision making for business insights.

Qualifications

• Proficiency with Excel formulas (HLOOKUP, VLOOKUP) and data extraction.
• Experience creating dashboards and KPIs across industries.
• Strong collaboration with stakeholders and ability to present insights.

Responsibilities

• Extract data from Excel, Google Sheets, and databases using advanced formulas.
• Collaborate with stakeholders to understand requirements and provide insights through visualizations.
• Develop dashboards to track KPIs across industries.
• Design reports using pivot tables to analyze large datasets.
• Utilize MS Office tools like Power BI to create interactive reports.

Skills

Excel

Google Sheets

Pivot tables

Power BI

Data visualization

HLOOKUP

VLOOKUP

Stakeholder collaboration

Tools

Power BI

Job description

Roles and Responsibilities

• Extract data from various sources such as Excel sheets, Google Sheets, and other databases using advanced formulas like HLOOKUP, VLOOKUP, Pivot tables, etc.
  
• Collaborate with stakeholders to understand their requirements and provide insights through visualizations.
  
• Develop dashboards to track key performance indicators (KPIs) for businesses across different industries.
  
• Design reports using pivot tables to analyze large datasets and present findings effectively.
  
• Utilize MS Office tools like Power BI to create interactive reports.