MIS Executive (Kanpur)

MIS Executive (Kanpur)

19 Nov
|
RATAN HOUSING DEVELOPMENT LIMITED- BPO UNIT
|
Kanpur

19 Nov

RATAN HOUSING DEVELOPMENT LIMITED- BPO UNIT

Kanpur

Industry: BPO / IT

Department: MIS

Experience: 2–5 Years

Employment Type: Full-Time, Permanent

Work Mode: Work from Office

Job Location: Fazalganj, Kanpur, Uttar Pradesh

Shift: Candidates must be flexible with day and night shifts, as per business requirements.

Job Overview

We are looking for a skilled and detail-oriented MIS Executive with hands-on experience in Advanced Excel, VBA, and Power BI. The candidate will be responsible for preparing MIS reports, developing dynamic dashboards, automating reporting processes, and analysing data to support business operations and management decisions.

Key Responsibilities

· Prepare and maintain daily, weekly, and monthly MIS reports.

· Create dynamic dashboards and performance reports using Advanced Excel and Power BI.

· Automate reporting processes using VBA and Macros.

· Analyse large datasets, identify discrepancies, and ensure data accuracy.

· Generate operational insights and track key performance indicators (KPIs).

· Ensure timely submission of reports to the management.

Required Skills & Technical Expertise

Advanced Excel:

· VLOOKUP, XLOOKUP, INDEX-MATCH, INDEX-MATCH-MATCH

· COUNTIFS,



SUMIFS, IF, AND, OR

· Pivot Tables & Dynamic Pivot Tables

· OFFSET, FILTER, CHOOSECOLS, VSTACK

· TEXTBEFORE, TEXTAFTER, TEXTJOIN

· DATE, TEXT and other advanced Excel functions

· Reverse VLOOKUP and VLOOKUP with MATCH/COLUMN

Additional Skills:

· VBA & Macro Automation

· Power BI – Dashboard Creation & Data Visualization

· MIS Reporting & Data Management

· Data Analysis and Reporting Automation

Desired Candidate Profile

· Any Graduate.

· 2–5 years of relevant experience in MIS, preferably in the BPO/IT industry.

· Robust hands-on expertise in Advanced Excel, VBA, and Power BI.

· Excellent analytical and problem-solving skills.

· Good understanding of data management and reporting processes.

· Must be comfortable working in day and night shifts, as per business requirements.

Note: Candidates should have practical working knowledge of the above-mentioned Excel functions and the ability to independently create and manage MIS dashboards and reports.

📌 MIS Executive (Kanpur)
🏢 RATAN HOUSING DEVELOPMENT LIMITED- BPO UNIT
📍 Kanpur

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: mis executive (kanpur) / kanpur

Subscribe to this job alert:

Get the latest job offers by email for: mis executive (kanpur) / kanpur