Renata Mechatronics logo

MIS Executive/Business Analyst

Renata Mechatronics

4 - 6 years

Pune

Posted:15 hours ago

Job Description

  • Core Purpose:

    Collects, cleans, and structures operational data from enterprise systems (ERP, CRM, finance) into routine management reports and dashboards.

  • Analyzes business operations, gathers stakeholder requirements, and redesigns workflows or software systems to improve efficiency and profitability.
  • Key Responsibilities:

    • Build and maintain daily, weekly, and monthly KPI reports.
    • Perform data cleaning, validation, and routine database checks.
    • Monitor operational & ERP system performance.
    • Act as an interface between internal departments
  • Required Skills:

    • Advanced Excel (pivot tables, macros, lookups)
    • BI reporting tools like Power BI or Tableau.

  • Strong proficiency in Microsoft Excel with efficiency in understanding Macros and other tools.
  • Strong proficiency in handling multiple projects and multiple tools when it comes to data handling.
  • Strong proficiency in handling vast amounts of data.
  • Ability to clean data especially when it comes in multiple formats.
  • Experience in live projects that have been in place for at least one year.
  • Familiarity with Tableau and Power BI.
  • Knowledge of machine learning libraries like Pandas etc will be huge plus.
  • Strong ability to develop mini dashboards for the management as per their requirements.
  • Strong clarity of thought when it comes to determining what the final output needs to look like.
  • Ability to understand excel sheets that are prepared by other department members.
  • Ability to deduce what is wrong in an excel sheet.

Skills Required

Bi Data analysis Microsoft Consolidation Pivot Chart HLOOKUP Management reporting Advanced Excel

Learn the skills this job asks for

See your skill gap for Data Analyst →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Renata Mechatronics logo
Renata Mechatronics

RecommendedJobs for You

Renata Mechatronics logo

Pune

Renata Mechatronics logo

Pune