MIS Executive

• Advanced Excel Development & Automation:

  • Design, develop, and maintain highly complex and dynamic Excel models, dashboards, and automated reports (daily, weekly, monthly, quarterly, annual, and ad-hoc) that provide critical business insights.

  • Utilize VBA (Visual Basic for Applications) and Macros extensively to automate repetitive tasks, create custom functions, build user-friendly interfaces, and integrate Excel with other applications (e.g., pulling data from databases, generating emails, manipulating external files).

  • Implement and optimize advanced Excel functions and formulas, including but not limited to: INDEX/MATCH, XLOOKUP, array formulas (CSE), SUMPRODUCT, OFFSET, INDIRECT, AGGREGATE, FORECAST.ETS, GETPIVOTDATA, and various statistical and financial functions.

  • Develop and manage complex Pivot Tables and Pivot Charts with calculated fields/items, Slicers, and Timelines for interactive data exploration.

  • Apply sophisticated Conditional Formatting rules, Data Validation techniques, and advanced data manipulation methods (Text to Columns, Flash Fill, Remove Duplicates, Consolidate) for data cleaning and preparation.

• Data Analysis & Visualization Excellence:

  • Conduct in-depth data analysis to identify trends, outliers, root causes, and business opportunities, translating raw data into actionable intelligence.

  • Create compelling and insightful data visualizations and dashboards using advanced charting techniques, sparklines, and other Excel visualization tools.

  • Perform "What-if" analysis, Goal Seek, Solver, and Data Tables to model scenarios and support strategic planning.

• Data Integrity & Efficiency:

  • Ensure the highest level of data accuracy, consistency, and reliability across all reports and analyses.

  • Optimize existing Excel files for performance, reducing file size and improving calculation speed.

  • Develop and implement best practices for Excel file management, version control, and data security.

• Cross-Functional Collaboration & Training:

  • Act as a subject matter expert for Excel, providing technical support, guidance, and training to other team members on advanced Excel functionalities and reporting best practices.

  • Collaborate closely with various departments (Sales, Marketing, Operations, Finance, HR) to understand their specific data requirements and deliver tailor-made reporting solutions.

• Process Improvement:

  • Continuously identify opportunities to streamline data collection, processing, and reporting workflows, leveraging Excel's automation capabilities to enhance overall efficiency.

• It is a Full Time Back Office / Data Entry job for candidates with 1 - 3 years of experience.

More about this MIS Executive job

1. What is the eligibility criteria to apply for this MIS Executive job?
   Ans: The candidate should be Graduate and above and above with 1 - 3 years of experience of experience
2. How much salary can I expect for this job role?
   Ans: You can expect a salary of ₹18000 - ₹20000 per month that depends on your interview. It's a Full Time job in Delhi.
3. How many working days are there for this MIS Executive job?
   Ans: This MIS Executive job will have 6 working days.
4. Are there any charges applicable while applying or joining this MIS Executive job?
   Ans: No, there is no fee applicable for applying this MIS Executive job and during the employment with the company, i.e., ETERNAL HR SERVICES PRIVATE LIMITED.
5. Is it a work from home job?
   Ans: No, it’s not a work from home job and can't be done online.
6. How many openings are there for this MIS Executive role?
   Ans: There is an immediate opening of 2 MIS Executive at ETERNAL HR SERVICES PRIVATE LIMITED
7. Who can apply for this job?
   Ans: Only Male candidates can apply for this Back Office / Data Entry job.
8. What are the timings of this MIS Executive job?
   Ans: This MIS Executive job has 09:00 AM - 06:00 PM timing.