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