MIS Executive - NIGHT SHIFT

Job Title: Advanced Excel Operator
Position Title: Advanced Excel Operator
Department: Operations
Location: Ahmedabad

Reports to: Operations - Manager
Position Overview: Full-Time

Position Overview:
We are seeking an experienced and highly skilled Advanced Excel Operator to join our team. The ideal candidate will have extensive experience with Excel, including advanced functions, data analysis, and reporting. This role involves creating complex spreadsheets, managing large datasets, and generating reports to support decision-making processes.
Key Responsibilities:

• Data Management:
• Create, modify, and maintain complex Excel spreadsheets and databases.
• Use advanced functions (e.g., VLOOKUP, HLOOKUP, INDEX/MATCH, pivot tables) to manage and analyze large datasets.
• Ensure data integrity and accuracy through rigorous data validation processes.
  
• Reporting and Analysis:
• Develop and maintain dashboards, charts, and reports to present key metrics and trends.
• Analyze data to identify patterns, trends, and anomalies.
• Provide actionable insights based on data analysis to support business objectives.

• Automation and Efficiency:
• Utilize macros, VBA (Visual Basic for Applications), and Power Query to automate repetitive tasks and improve workflow efficiency.
• Create and maintain automated reporting processes to reduce manual effort.

• Collaboration and Support:
• Collaborate with other departments to gather requirements and understand their data needs.
• Provide technical support and training to team members on Excel functionalities and best practices.
• Troubleshoot and resolve issues related to Excel files and data processes.

• Documentation and Compliance:
• Document processes, procedures, and Excel models for transparency and future reference.
• Ensure compliance with data protection regulations and company policies.

Qualifications:

• Education:
• Bachelors degree in Data Analysis, Business Administration, Finance, or a related field, or equivalent experience.

• Experience:
• Minimum of 2 years of experience working with advanced Excel functions and data analysis.
• Proven experience with macros, VBA, and other automation tools.

• Skills:
• Advanced proficiency in Microsoft Excel, including pivot tables, advanced formulas, and data visualization.
• Strong analytical and problem-solving skills.
• Ability to manage and manipulate large datasets efficiently.
• Excellent attention to detail and accuracy.
• Strong communication skills with the ability to explain complex data concepts to non-technical stakeholders.
• Experience with other data analysis tools (e.g., Power BI, Tableau) is a plus.