Job
Description
Responsibilities: Data Management & Reporting: Collect, compile, and maintain large datasets from various sources. Generate accurate and insightful daily, weekly, monthly, and ad-hoc MIS reports using advanced Excel functionalities. Develop and maintain dashboards and visualizations to present data clearly and effectively to management. Ensure data integrity, accuracy, and consistency across all reports. Advanced Excel Proficiency: Utilize a wide range of Excel formulas and functions, including but not limited to: Lookup & Reference: VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET Logical: IF, AND, OR, NOT, IFERROR Statistical: SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS Text: CONCATENATE, LEFT, RIGHT, MID, FIND, REPLACE, TRIM Date & Time: TODAY, NOW, DATE, MONTH, YEAR, DATEDIF Create and manipulate Pivot Tables and Pivot Charts for in-depth data analysis and summarization. Implement Conditional Formatting to highlight key trends, anomalies, and critical data points. Automate repetitive tasks using Excel Macros and basic VBA (Visual Basic for Applications) to improve efficiency. Work with Power Query and Power Pivot for advanced data modeling and transformation (desirable). Data Entry & Accuracy: Perform efficient and accurate data entry with a strong focus on detail. Maintain a high typing speed (e.g., 30+ WPM) to handle large volumes of data efficiently. Verify and cross-reference data to identify and resolve discrepancies promptly. Analysis & Insights: Analyze data to identify trends, patterns, and insights relevant to business performance. Assist in interpreting complex data sets and providing actionable recommendations. Collaboration & Communication: Collaborate with various departments (e.g., Sales, Operations, HR, Finance) to understand their data requirements and provide tailored reports. Communicate findings and insights effectively to both technical and non-technical stakeholders. Documentation: Maintain clear and organized documentation of all reports, processes, and data sources.
