Excel Data Expert

2 weeks ago

Pithampur, Madhya Pradesh, India Medilux Laboratories Full time ₹ 9,00,000 - ₹ 12,00,000 per year

We are looking for a detail-oriented and analytical Excel Data Expert to manage, extract, analyze, and visualize data using Microsoft Excel and other tools. The ideal candidate will have strong technical skills in data manipulation, reporting, and dashboard creation, enabling business teams to make informed decisions through clear and actionable insights

Key Responsibilities:

  • Data Extraction & Cleaning:

  • Extract data from various sources (e.g., databases, spreadsheets, reports).

  • Clean, format, and organize raw data for analysis and reporting.

  • Use functions like VLOOKUP, INDEX/MATCH, TEXT, IF statements, etc., for data preparation.

  • Data Analysis & Transformation:

  • Analyze large datasets to identify trends, patterns, and inconsistencies.

  • Use pivot tables, Power Query, and advanced formulas to summarize and transform data.

  • Automate repetitive data tasks using Excel Macros/VBA (if applicable).

  • Data Presentation & Visualization:

  • Design clear and interactive Excel dashboards and reports.

  • Create charts and graphs to visualize data trends and KPIs.

  • Present data findings to stakeholders in a visually compelling format.

  • Reporting & Documentation:

  • Generate weekly/monthly/quarterly reports and performance metrics.

  • Document data processes and report templates for consistency and reuse.

  • Ensure data accuracy and integrity in all deliverables.

  • Collaboration & Support:

  • Work with cross-functional teams to understand data needs and deliver insights.

  • Provide Excel support and training to team members when needed.
  • Communicate complex data in a simple and actionable way.

Preferred Candidate -

  • Knowledge of business operations, finance, sales, or marketing data.
  • Familiarity with automation or reporting tools.
  • Proven experience as an Excel Analyst, Reporting Specialist, or similar role.

  • Expert-level proficiency in Microsoft Excel, including:

  • Pivot Tables

  • Power Query
  • Advanced Formulas & Functions
  • Charts & Conditional Formatting
  • Data Validation

  • (Optional) VBA & Macros

  • Strong analytical and problem-solving skills.

  • Attention to detail and ability to work with large data sets.
  • Excellent communication and presentation skills.

  • Manager

    1 week ago

    Pithampur, Madhya Pradesh, India Lupin Full time ₹ 4,00,000 - ₹ 12,00,000 per year

    Job Description • Define productivity metrics and align operating definitions with QC teams.• Simplify and digitize data for reporting QC productivity metrics.• Publish monthly QC productivity metrics reports for all labs.• Identify improvement levers for QC productivity and develop action plans to address them, reporting progress regularly.•...

  • Manager

    1 week ago

    Pithampur, Madhya Pradesh, India Lupin Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Job Description • Define productivity metrics and align operating definitions with QC teams.• Simplify and digitize data for reporting QC productivity metrics.• Publish monthly QC productivity metrics reports for all labs.• Identify improvement levers for QC productivity and develop action plans to address them, reporting progress regularly.•...

  • Manager

    1 week ago

    Pithampur, Madhya Pradesh, India Lupin Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Job Description• Define productivity metrics and align operating definitions with QC teams.• Simplify and digitize data for reporting QC productivity metrics.• Publish monthly QC productivity metrics reports for all labs.• Identify improvement levers for QC productivity and develop action plans to address them, reporting progress regularly.• Manage...

  • QC Executive RM/ FG

    2 weeks ago

    Pithampur, Madhya Pradesh, India Piramal Pharma Limited Full time

    Role Overview:The Lab QA/QC Reviewer will be responsible for the comprehensive review and approval of analytical data generated by the QC laboratory.This role ensures data integrity, compliance with regulatory guidelines, and facilitates resolution of quality investigations related to lab incidents.Key Responsibilities:Perform detailed analytical data review...

  • Process Quality Manager

    2 days ago

    Pithampur, Madhya Pradesh, India MAHLE Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    BU1 Powertrain and ChargingTogether, we move the world—we've been doing it for over 100 years. At MAHLE, as a leading international development partner and systems supplier to the automotive industry, we pursue the objective of making mobility more efficient, more environmentally friendly, more convenient, and more economical. As part of our dual strategy,...

  • Assistant Manager

    2 weeks ago

    Pithampur, Madhya Pradesh, India Gufic Group Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    The purpose of this role is to :-.The Group leader of Formulation and Development (Injectables) will oversee the design, development, and optimization of sterile injectable formulations. This role will lead a team of scientists and collaborate closely with cross-functional teams, including Analytical, Regulatory, Quality, and Manufacturing, to ensure...

  • Executive

    1 week ago

    Pithampur, Madhya Pradesh, India Lupin Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Job Description Join Lupin Limited's dynamic IT Operations team as an Executive dedicated to ensuring the highest standards of compliance and system integrity across our computerized software systems. In this role, you will take a proactive stance in validating computer system software and sustaining its validated status in strict accordance with Standard...

  • Executive

    2 weeks ago

    Pithampur, Madhya Pradesh, India Lupin Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Job DescriptionEnsure Computer System Software Validation and maintaining validated status of all computerized system software as per SOPs in line with cGMP guidelines.Identifying GAPs in current practices and plan mitigation for each GAP as per agreed time-line.Participating in various Internal, External and Regulatory Audits and their compliance...

  • Executive – QA

    1 week ago

    Pithampur, Madhya Pradesh, India Solis Hygiene PVT. LTD Full time ₹ 4,20,000 - ₹ 6,00,000 per year

    Job Title:Executive – QA / QCDepartment: Quality AssuranceLocation: PithampurKey Responsibilities:Develop and implement quality control procedures and standards for manufacturing processes.Conduct inspections and testing of raw materials (RM), packaging materials (PM), in-process, and finished goods (FG).Ensure compliance with regulatory requirements,...

  • Sr. Executive

    2 weeks ago

    Pithampur, Madhya Pradesh, India Gufic Group Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Role & responsibilities :Review of all QMS documents related to regulatory submissionsPrepare status of all documents related to submissionCo-ordinate with all stakeholders of plant for collection of documentsProvide all regulatory documents to HO-RA for submission.Evaluation of change control, deviations and out of specifications.Review of specifications,...