Role & responsibilities
- Excel Data Management: Handle large datasets efficiently using advanced Excel features such as VLOOKUP, pivot tables, conditional formatting, and array formulas.
- Macro Development: Design, create, and maintain automated macros to improve business processes, reduce manual work, and ensure data consistency.
- Reporting: Develop custom reports and dashboards, leveraging Excel and macros to provide insightful, accurate, and timely data visualizations for decision-makers.
- Insights: Analyze data to identify trends, discrepancies, and opportunities for optimization, presenting findings in clear, actionable formats.
- Process Improvement: Identify opportunities to automate repetitive tasks and optimize workflows using Excel and macros.
- Collaboration: Work closely with cross-functional teams to understand business needs and provide tailored solutions through Excel-based tools and automation.
- Training & Support: Provide training and support to staff on advanced Excel functionalities and macro usage,
enhancing overall team proficiency.
- Documentation: Maintain clear documentation for all macros and Excel-based solutions to ensure ease of use, scalability, and future enhancements.
- Troubleshooting: Address and resolve issues related to data integrity, macro performance, and Excel functionality in a timely manner.
Preferred candidate profile
- Bachelor's degree in a relevant field (e.g., Business, Finance, Data Analytics, Information Technology) is preferred.
Personal Attributes
- Robust analytical mindset with a focus on efficiency and process improvement.
- High level of organizational skills and ability to prioritize tasks.
- A proactive approach to problem-solving with a solution-oriented mindset.
- Strong interpersonal skills and the ability to collaborate effectively with teams across the organization.
📌 Senior Executive (Mumbai)
🏢 Writer
📍 Mumbai