Senior Operations Executive || 2- 4 years || Flipkart

Job Description

The Operations Executive will play a key role in supporting operational processes, data analysis, and performance optimization. This role requires advanced proficiency in Microsoft Excel to analyze complex data sets, automate reports, track key performance indicators (KPIs), and enhance operational efficiency. Key Responsibilities: Data Analysis & Reporting: Utilize advanced Excel functions such as VLOOKUP, INDEX-MATCH, pivot tables, and advanced formulas to analyze large data sets. Prepare and maintain detailed reports on operational performance, including daily, weekly, and monthly reports. Develop custom dashboards and visualizations using Excel to present insights and trends to management. Process Optimization: Assist in identifying inefficiencies in operational processes and propose improvements. Use Excel tools to track, manage, and automate workflows to enhance productivity. Create and implement Excel-based templates and systems for easier tracking and reporting of key metrics. Forecasting & Planning: Use historical data to assist with forecasting demand, resource allocation, and operational planning. Apply advanced Excel functions such as statistical analysis tools and forecasting models to predict trends. Collaboration & Coordination: Collaborate with cross-functional teams (e.g., sales, finance, customer service) to gather data, share insights, and align operational goals. Prepare presentations and reports for senior management on key operational metrics and strategic initiatives. Data Integrity & Management: Ensure the accuracy, integrity, and consistency of data being used for reports and analyses. Clean and validate data within Excel using advanced data-cleaning techniques to ensure accuracy in all reporting processes. Automation & Tools Development: Leverage Excel macros, Power Query, and other tools to automate repetitive tasks and reporting processes. Create automated templates to streamline tasks such as inventory management, financial forecasting, and project tracking. Training & Support: Provide Excel training to junior staff and team members, ensuring the department's proficiency with advanced Excel functions. Support other departments with Excel-related tasks, ensuring data accuracy and effective analysis. Key Skills & Qualifications: Advanced Excel Skills: Strong command over advanced Excel functions including VLOOKUP, INDEX/MATCH, PivotTables, Power Query, macros, and complex formulas. Data Management: Experience in managing, cleaning, and transforming large data sets to derive actionable insights. Problem-Solving: Strong analytical skills to identify trends, solve operational problems, and implement solutions. Attention to Detail: Accuracy and precision in working with data and generating reports. Communication: Excellent verbal and written communication skills to present complex data insights to non-technical stakeholders. Experience with Automation Tools: Knowledge of Excel macros and automation features to improve efficiency. Operational Understanding: Knowledge of business processes, KPIs, and operations management. Software Knowledge: Familiarity with other office software and operational tools (e.g., SAP, SQL, or ERP systems) is a plus. Degree: Bachelors degree in business, operations management, or a related field. Preferred Qualifications: Experience with Excel-based reporting tools and dashboards. Knowledge of data visualization tools like Power BI or Tableau (optional). Prior experience in an operations role or similar function is a plus. Role & responsibilities Preferred candidate profile Perks and benefits