6 VLOOKUP Jobs in Mumbai | VLOOKUP Job openings in Mumbai

Job Title: Corporate Quality MIS Analyst – Automotive / Wiring Harness

Company: Vi-Son Cables Pvt. Ltd.

Location: Mumbai – Corporate Office

Experience: 3–7 Years

Industry: Automotive / Auto Components / Wiring Harness

Job Summary

We are looking for a Quality MIS Analyst with experience in the Automotive, Wiring Harness or Auto Components industry to manage Corporate Quality MIS and reporting. The role will be responsible for consolidating quality data from all plants, analysing KPIs and preparing reports and dashboards for Management.

Key Responsibilities

• Consolidate plant-wise Quality MIS, KPIs and performance reports.
• Analyze PPM, rejection, rework, FPY, customer complaints, CAPA and 8D.
• Prepare MIS reports, dashboards, trend analysis and Management presentations.
• Coordinate with Plant Quality Teams for timely and accurate data.
• Identify quality trends, deviations and improvement areas.
• Maintain standardized Corporate Quality MIS and databases.

Key Requirements

• 3–7 years of experience in Automotive / Wiring Harness / Auto Components Quality.
• Strong knowledge of Quality MIS, Quality KPI reporting and data analysis.
• Proficiency in MS Excel, Pivot Tables, VLOOKUP/XLOOKUP, dashboards and PowerPoint.
• Knowledge of 7 QC Tools, 8D, CAPA and Root Cause Analysis.
• Strong analytical, coordination and communication skills.

Key Responsibilities

• Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
• Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
• Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
• Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
• Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
• Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
• Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
• Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.
• Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.

Required Skills & Qualifications

• Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.

• Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
• Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
• Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
• Good communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
• Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.

Location-Mumbai-Vileparle

Working Days/Time – 6 days /10 AM -7 PM

Key Responsibilities

• Prepare and maintain daily, weekly, and monthly MIS reports
• Collect and validate data from multiple departments (Sales, Operations, Finance)
• Analyze data and highlight key trends, variances, and insights
• Develop and maintain dashboards using Excel or BI tools
• Ensure accuracy and consistency of data across reports
• Automate repetitive reports using advanced Excel or macros
• Support management with ad-hoc reports and analysis
• Coordinate with stakeholders to resolve data discrepancies
• Maintain proper documentation of reports and processes

Required Skills

• Strong knowledge of Microsoft Excel (Advanced Level)
• (Pivot Tables, XLOOKUP/VLOOKUP, IF, INDEX-MATCH)
• Good analytical and problem-solving skills
• High attention to detail and accuracy
• Ability to handle large datasets

Qualifications

• Bachelor’s degree (B.Com / BBA / BSc IT / similar)
• 1–2 years of experience in MIS / Reporting / Data handling roles 

Job Title: MIS Operations Executive

Location: Mumbai, Maharashtra

Industry: Insurance

Experience Required: 1 -5 Years

Job Summary:

We are seeking a detail-oriented and analytical MIS Operations Executive to support data management, reporting, and operational efficiency within our insurance business. The ideal candidate will be responsible for generating accurate reports, maintaining databases, and assisting in decision-making through data insights.

Key Responsibilities:

• Prepare daily, weekly, and monthly MIS reports related to sales, operations, and performance metrics
• Collect, analyze, and validate data from multiple sources to ensure accuracy and consistency
• Maintain and update databases, dashboards, and reporting systems
• Support business teams with ad hoc data requests and analysis
• Identify trends, discrepancies, and areas for improvement in operational processes
• Ensure timely submission of reports to management
• Coordinate with cross-functional teams (sales, underwriting, claims) for data requirements
• Assist in automation of reports using Excel or MIS tools

Key Skills Required:

• Strong proficiency in MS Excel (Pivot Tables, VLOOKUP, formulas)
• Basic knowledge of MIS reporting and data analysis
• Good analytical and problem-solving skills
• Attention to detail and accuracy
• Ability to manage deadlines and multitask
• Good communication and coordination skills

Preferred Qualifications:

• Bachelor’s degree in Commerce, Business Administration, or related field
• Familiarity with insurance processes (policies, claims, underwriting) is a plus
• Knowledge of tools like Power BI, SQL, or advanced Excel will be an advantage

Salary: As per industry standards

Working Hours: Full-time

Career Growth: Opportunity to grow into senior MIS roles, data analytics, or operations management within the insurance domain

Job Title: CRM Executive

Location: Thane (Majiwada)

Age Requirement: Up to 30 Years

Experience: 1–2 years (Pharma industry – Cardio-Diabetic segment preferred)

Responsibilities:

• Manage and maintain customer databases, ensuring accuracy and completeness.
• Coordinate with sales and marketing teams to support CRM activities.
• Generate and analyze reports using MS Excel (Pivot, VLOOKUP, etc.).
• Ensure timely communication with clients and internal teams.
• Support day-to-day CRM operations to drive efficiency and client satisfaction.

Key Skills:

• Strong communication & coordination skills.
• Proficiency in MS Excel and data management.
• Pharma experience in Cardio-Diabetic segment is mandatory.

Note: This is a top priority position – immediate joiners will be preferred.