Skip to main content
Upload your CV and find your next job on Indeed!

Advanced Excel jobs in Mumbai, Maharashtra

Sort by: -

People also searched:

excel

Job Post Details

Data Analyst
Harshad Jeweltech solution LLp
Andheri H.O, Mumbai, Maharashtra
₹3,50,000 - ₹6,00,000 a year
Permanent, Fresher, Full-time

Job details

₹3,50,000 - ₹6,00,000 a year
Health insurance, Paid time off, Paid sick time, Life insurance, Cell phone reimbursement, Leave encashment, Internet reimbursement, Provident Fund
Permanent, Fresher, Full-time
Andheri H.O, Mumbai, Maharashtra

Full job description

JOB DESCRIPTION
DATA ANALYST

Job Title

Data Analyst

Department

MIS / Data Analytics

Location

Mumbai, Maharashtra

Experience

2–5 Years

Employment Type

Full-Time

Industry

Manufacturing / Gems & Jewellery (Preferred)

1. Job Summary

We are looking for a detail-oriented Data Analyst to collect, validate, analyse, and interpret business data. The role involves preparing MIS reports and dashboards, working closely with internal teams, understanding business requirements, and sharing data-backed insights and practical inputs with management to support informed decisions and improve business performance.

2. Key Responsibilities

· Collect, consolidate, clean, validate, and analyse data from different departments and business systems.

· Prepare accurate daily, weekly, and monthly MIS reports within agreed timelines.

· Create, update, and maintain dashboards using Power BI, Excel, or other suitable reporting tools.

· Analyse sales, purchase, inventory, finance, service, and operational data to identify trends, gaps, and improvement opportunities.

· Participate in internal team discussions and meetings to understand business challenges, reporting needs, and department-wise requirements.

· Interact with stakeholders and department teams to gather information, clarify data points, and validate findings.

· Based on discussions, data analysis, and business interactions, provide clear observations, recommendations, and actionable inputs to teams and management.

· Follow up with teams on pending data, discrepancies, action points, and required report updates.

· Monitor departmental and business KPIs, highlight deviations, and support teams in understanding performance trends.

· Identify data errors and coordinate with concerned teams for timely correction.

· Automate recurring reports and improve reporting efficiency by reducing manual work.

· Use AI-enabled tools responsibly for data cleaning, analysis, formula creation, report preparation, trend identification, and summarisation; validate all outputs before use.

· Explore suitable AI and analytics solutions to improve reporting workflows and business productivity.

· Maintain data confidentiality and proper documentation of reports and dashboards.

· Present findings clearly to management and internal stakeholders.

3. Internal Coordination & Business Support

· Work closely with Sales, Purchase, Finance, Operations, Service, HR, and other teams to understand data and reporting requirements.

· Attend review meetings and record relevant data-related action points and follow-ups.

· Convert business questions and team feedback into measurable reports, dashboards, and analysis.

· Share relevant insights and suggest improvements to processes, reporting, and departmental performance.

· Provide data support for management reviews, business planning, and departmental performance discussions.

4. AI & Technology Usage

· Use AI tools and features in Excel, Power BI, or other approved platforms to support analysis and reporting.

· Use AI assistance for data summarisation, pattern identification, drafting report narratives, and improving workflow efficiency.

· Verify AI-generated formulas, calculations, summaries, and recommendations against source data before sharing.

· Do not upload confidential company, employee, customer, or financial information to unapproved AI platforms.

· Stay updated on relevant AI and analytics features that can add value to business reporting.

5. Required Skills & Qualifications

· Bachelor’s degree in Commerce, Business Administration, Statistics, Mathematics, Information Technology, or a related field.

· 2–5 years of experience in Data Analytics, MIS Reporting, Business Analytics, or a similar role.

· Advanced MS Excel skills: Pivot Tables, VLOOKUP / XLOOKUP, IF, SUMIF, COUNTIF, data validation, and data cleaning.

· Working knowledge of Power BI or Tableau and dashboard development.

· Basic to intermediate knowledge of SQL is preferred.

· Familiarity with AI tools and their practical use in data analysis and reporting.

· Strong analytical thinking, problem-solving skills, and attention to detail.

· Good communication and interpersonal skills to interact with cross-functional teams.

· Ability to explain data findings and provide practical, evidence-based inputs.

· Ability to manage multiple reporting requirements and meet deadlines.

6. Preferred Candidate Profile

· Experience in manufacturing, gems & jewellery, trading, or a similar business environment will be an added advantage.

· Experience in cross-functional coordination and management reporting.

· Ability to connect data insights with business requirements and recommend practical improvements.

· Proactive approach to identifying reporting gaps and improving processes.

· Comfortable participating in discussions and presenting findings to internal stakeholders.

7. Key Result Areas (KRA) & Key Performance Indicators (KPI)

Key Result Area (KRA)

Key Performance Indicator (KPI)

MIS & Report Delivery

Reports are accurate, complete, and submitted within agreed timelines.

Data Quality

Data discrepancies are identified, tracked, and resolved with relevant teams.

Dashboard Management

Dashboards are updated regularly and reflect agreed business KPIs.

Analysis & Insights

Useful trends, gaps, and actionable recommendations are identified and communicated.

Internal Coordination

Requirements and action points from team discussions are followed up and closed on time.

AI & Process Improvement

Suitable AI/automation opportunities are identified; outputs are validated and used responsibly.

Stakeholder Support

Management and departments receive clear, relevant, and timely analytical support.

8. Technical Skills

Skill

Requirement

MS Excel

Advanced – Mandatory

Power BI / Tableau

Working knowledge – Preferred

SQL

Basic to intermediate – Preferred

AI Tools

Practical familiarity – Preferred

MS Office

Good working knowledge

MIS & Dashboard Reporting

Mandatory

Pay: ₹350,000.00 - ₹600,000.00 per year

Benefits:

  • Cell phone reimbursement
  • Flexible schedule
  • Health insurance
  • Internet reimbursement
  • Leave encashment
  • Life insurance
  • Paid sick time
  • Paid time off
  • Provident Fund

Work Location: In person

Let Employers Find YouUpload Your Resume