Advanced Excel jobs in Mumbai, Maharashtra
- Harshad Jeweltech solution LLpAndheri H.O, Mumbai, Maharashtra
- We are looking for a detail-oriented Data Analyst to collect, validate, analyse, and interpret business data.
- Collect, consolidate, clean, validate, and analyse…
- Skyleaf ConsultantsMumbai, Maharashtra
- Proficiency in MS Excel (advanced skills), including pivot tables, v-lookups, and complex formulas.
- Collect, analyse, and interpret data from various internal…
- View all Skyleaf Consultants jobs - Mumbai, Maharashtra jobs
- Salary Search: MIS Executive salaries in Mumbai, Maharashtra
- KennectHybrid work in Mumbai, Maharashtra
- Opportunity to work on automation and advanced reporting.
- We are looking for an MIS analyst who can work with raw datasets, build business logics using Excel,…
- View all Kennect jobs - Mumbai, Maharashtra jobs - Analyst jobs in Mumbai, Maharashtra
- Salary Search: MIS analyst salaries in Mumbai, Maharashtra
- Goldmedal Electricals Pvt LtdMalad, Mumbai, Maharashtra
- Strong advanced Excel (pivots, Power Query, lookups, data modelling).
- Qualification:* CA / CMA / MBA (Finance) preferred; B.
- Attention to detail and ownership.
- View all Goldmedal Electricals Pvt Ltd jobs - Malad, Mumbai, Maharashtra jobs - Management Information Systems Manager jobs in Malad, Mumbai, Maharashtra
- Salary Search: Assistant Manager – Dashboards & MIS (Strategy & Planning) salaries in Malad, Mumbai, Maharashtra
- See popular questions & answers about Goldmedal Electricals Pvt Ltd
- BiltraxVashi, Navi Mumbai, Maharashtra
- The incumbent will be responsible for managing technical data workflows, ensuring accuracy of project specifications, and leading a team of 8–10 associates.
- Firmway Services Pvt LtdSakinaka, Mumbai, Maharashtra
- We are looking for a talented professional with deep expertise in Accounts Payable (AP) / Accounts Receivable (AR) accounting, coupled with hands-on experience…
View similar jobs with this employerUnistanz Software Pvt LtdMumbai, Maharashtra- We are looking for a Data Analyst with 3 - 5 years of experience to support data-driven decision-making.
- We are looking for a Data Analyst with 3 - 5 years of…
- View all Unistanz Software Pvt Ltd jobs - Mumbai, Maharashtra jobs
- Salary Search: Data Analyst salaries in Mumbai, Maharashtra
- See popular questions & answers about Unistanz Software Pvt Ltd
- Generic Engineering Constructions and Project LTDUnknown, Maharashtra
- Experience Required: 3–5 Years.
- We are looking for an experienced MIS & Data Analyst who can manage reporting, analyze business data, create dashboards, and…
- Etraveli GroupMumbai, Maharashtra
- Advanced Spreadsheet Skills: Proficient in Excel and Google Sheets, including advanced formulas (INDEX/MATCH, XLOOKUP, nested logic), pivot tables, and data…
- Etraveli GroupMumbai, Maharashtra
- Advanced Spreadsheet Skills: Proficient in Excel and Google Sheets, including advanced formulas (INDEX/MATCH, XLOOKUP, nested logic), pivot tables, and data…
- MaerskMaharashtra
- As a Procurement Associate, you will support procurement operations related to IT services, software procurement, contractor management, and P2P processes.
- View all Maersk jobs - Mumbai, Maharashtra jobs - Executive jobs in Mumbai, Maharashtra
- Salary Search: Procurement Executive salaries in Mumbai, Maharashtra
- See popular questions & answers about Maersk
- Frootle India Private LimitedMumbai, Maharashtra
- Dealing in innovative International Home, Kitchen, Entertainment and Wellness products for the India market.
- Ecovacs -* Robotic Vacuum Cleaner.
- Bridge Et Al.Remote in Mumbai, Maharashtra
- Employment Type: Full-Time | Remote.
- The organisation is committed to advancing sustainability outcomes through robust data management, transparent reporting,…
- Foxberry Technology Pvt LtdMumbai, Maharashtra
- Exposure to large-scale datasets and advanced BI tools.
- Strong proficiency in Excel (advanced functions, pivoting, lookups, Power Query).
- View all Foxberry Technology Pvt Ltd jobs - Mumbai, Maharashtra jobs
- Salary Search: Data Analyst salaries in Mumbai, Maharashtra
- JLLMumbai, Maharashtra
- Candidates with advanced analytics and BI tool exposure are preferred to support future dashboard and automation initiatives.
- View all JLL jobs - Mumbai, Maharashtra jobs
- Salary Search: MIS Executive salaries in Mumbai, Maharashtra
- See popular questions & answers about JLL
- SSIZ InternationalSantacruz West, Mumbai, Maharashtra
- Perform advanced data analysis using MS Excel, including complex formulas, Pivot Tables, Power Query, lookups, conditional formulas, and data validation.
People also searched:
Job Post Details
Data Analyst
Data Analyst
Job details
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