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 transparent 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.
Solid interpersonal skills and the ability to collaborate effectively with teams across the organization.
📌 Senior Executive Mumbai
🏢 Writer
📍 Mumbai