Kshethra Group logo

Senior Mis Analyst

Kshethra Group

5 - 8 years

3 - 4 Lacs

Bengaluru

Posted:15 hours ago

Job Description

We are looking for a detail-oriented and analytical MIS Analyst to manage, maintain, and analyse business data related to sales, customer leads, site operations, accounts, and project performance. The candidate will be responsible for preparing regular MIS reports, maintaining accurate databases, tracking business performance, and providing meaningful insights to management for decision-making.

Role & responsibilities

  1. Prepare daily, weekly, and monthly MIS reports related to sales, leads, bookings, collections, and project performance.
  2. Maintain and update sales databases, customer records, lead trackers, and other business-related reports.
  3. Track and analyse sales performance, targets, achievements, and conversion ratios.
  4. Monitor customer leads from various sources and prepare lead status and follow-up reports.
  5. Prepare reports on plot bookings, registrations, agreements, cancellations, and customer collections.
  6. Coordinate with Sales, Accounts, CRM, and Operations teams to collect and validate data.
  7. Develop and maintain Excel dashboards, pivot tables, and automated reporting formats.
  8. Identify data discrepancies, ensure data accuracy, and maintain proper documentation.
  9. Generate performance reports and analytical summaries for management review.
  10. Maintain project-wise reports related to site progress, expenses, work completion, and pending activities.
  11. Prepare data comparisons, trend analysis, and business performance reports.
  12. Support management with ad-hoc reports and data analysis whenever required.

Preferred candidate profile

  • Strong knowledge of MS Excel, including:
    • VLOOKUP / XLOOKUP
    • Pivot Tables
    • IF, SUMIF, COUNTIF formulas
    • Data Validation and Conditional Formatting
    • Charts and Dashboards
  • Good knowledge of Google Sheets.
  • Knowledge of Power BI will be an added advantage.
  • Strong analytical, numerical, and problem-solving skills.
  • Good communication and coordination skills.
  • Ability to handle large volumes of data with accuracy and confidentiality.

Perks and benefits

Skills Required

Senior Management HLOOKUP Advanced Excel Formatting Reporting Management Information System Tables

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
Kshethra Group logo
Kshethra Group

RecommendedJobs for You

Kshethra Group logo

Senior Mis Analyst

Kshethra Group

Bengaluru

Kshethra Group logo

Senior Mis Analyst

Kshethra Group

Bengaluru