6+ VLOOKUP Jobs in Mumbai | VLOOKUP Job openings in Mumbai

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 

An MIS Executive is responsible for managing data, generating reports, and supporting decision-making by maintaining accurate information systems—mostly using tools like Excel, databases, and reporting software.

🔹 Key Responsibilities

• Collect, clean, and manage large sets of data
• Prepare daily / weekly / monthly reports for management
• Create dashboards using tools like Excel, Google Sheets, or BI tools
• Analyze data trends to support business decisions
• Maintain and update databases regularly
• Coordinate with different departments for data requirements
• Ensure data accuracy and consistency
• Automate reports using formulas, macros, or scripts

🔹 Required Skills

• Strong knowledge of Microsoft Excel (VLOOKUP, Pivot Tables, Macros)
• Basic understanding of SQL (optional but valuable)
• Familiarity with reporting tools like Power BI or Tableau
• Good analytical and problem-solving skills
• Attention to detail
• Basic communication skills 

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

Key Responsibilities – Taxation & Financial Reporting

1. Income Tax

Preparation and filing of corporate/individual income tax returns.

Computation of advance tax and self-assessment tax.

Handling TDS calculations, payments, returns, and reconciliations.

Coordinating with tax consultants and managing income tax assessments/notices.

Ensuring compliance with all direct tax regulations.

2. GST Compliance

Preparation and filing of GST returns (GSTR-1, GSTR-3B, annual returns).

Reconciliation of GSTR-2A/2B with purchase registers.

Managing input tax credit (ITC) reconciliation and optimization.

Handling GST audits, notices, and departmental queries.

Ensuring timely payment of GST liabilities.

3. Balance Sheet & Financial Statements

Finalization of Balance Sheet, Profit & Loss Account, and Cash Flow Statements.

Month-end and year-end closing activities.

Ledger scrutiny and reconciliation of all major accounts.

Provisioning, accruals, and depreciation calculations.

Coordinating with statutory auditors for financial statement finalization.

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.