TA

Mis Executive

Tanserv Business Process Verified Enterprise Gurugram
2.25-3.75 Lacs PA
Exp: 3-8 Yrs
Full Time
0-Ghosting Guarantee
Takes 30 seconds

Job Description & Scope

Job description Job Summary: We are seeking an experienced and detail-oriented MIS Executive to manage and streamline our management information systems. The ideal candidate will have a strong background in Excel (including advanced functions, Macros, and Pivot Tables), Power BI, and data visualization tools. You will be responsible for data management, reporting, analysis, and creating dashboards to support decision-making processes across departments. Key Responsibilities: Develop, maintain, and automate MIS reports and dashboards using Excel, Power BI, and other tools. Create and manage Pivot Tables, Pivot Charts, and Macros to analyze large datasets effectively. Use Advanced Excel functions (VLOOKUP, HLOOKUP, INDEX-MATCH, nested IFs, conditional formatting, etc.) for data manipulation and reporting. Develop and publish interactive dashboards in Power BI to visualize performance metrics and KPIs. Perform regular audits of data for accuracy, completeness, and consistency. Collaborate with cross-functional teams to gather data and reporting requirements. Provide support in automating routine processes and enhancing existing MIS frameworks. Monitor performance trends and generate actionable insights to support strategic planning. Ensure timely delivery of daily, weekly, and monthly MIS reports. Required Skills & Qualifications: Minimum 3 years of experience in an MIS Executive or similar role. Proficient in Microsoft Excel (including Advanced Excel features, Macros, Pivot Tables & Charts). Hands-on experience in Power BI (data modeling, DAX, report publishing, and dashboarding). Strong analytical and problem-solving skills. Knowledge of basic SQL (optional but preferred). Excellent communication and presentation skills. Ability to manage multiple tasks and deadlines in a fast-paced environment. Bachelors degree in Computer Science, Information Systems, Business Administration, or related field. Role: Data Entry / MIS Industry Type: Miscellaneous Department: Customer Success, Service & Operations Employment Type: Full Time, Permanent Role Category: Back Office Education UG: ITI Certification in Any Specialization, B.Sc in Computers, B.Tech/B.E. in Any Specialization, BCA in Any Specialization Key Skills Skills highlighted with ‘‘ are preferred keyskills Pivot TablePower BiVLOOKUPAdvanced ExcelMacros ExcelFormulas

Job Summary

Company
Tanserv Business Process
Location
Gurugram
Salary Range
2.25-3.75 Lacs PA
Experience
3-8 Yrs
Verification
Government Verified Recruiter
TrueCV Commitment Pledge

Zero Ghosting Guarantee

Every recruiter on TrueCV commits to review applications, respect interview time, and authenticate joining via our Day 1 Handshake.

100% Backed by TrueCV Platform
Mis Executive
2.25-3.75 Lacs PA
Get Android App