Data Analyst (Excel/MIS specialist)

Job description The Data Analyst (Excel Specialist) is responsible for collecting, analyzing, and interpreting data using Microsoft Excel to provide insights and support decision-making within the firm This role involves working extensively with Excel functions, formulas, and tools to manipulate, visualize, and analyze data effectively Responsibilities: 1.Data Collection and Preparation: Collect, clean, and organize data from various sources, ensuring accuracy and completeness. Use Excel functions and features to preprocess and format data for analysis. 2.Data Analysis: Perform data analysis using advanced Excel functions (eg, VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS) to identify trends, patterns, and correlations in the data. 3.Data Visualization: Create visually appealing and informative charts, graphs, and pivot tables in Excel to summarize and present analysis results effectively. 4.Dashboard Development: Design and develop interactive dashboards and reports in Excel to track key performance indicators (KPIs) and provide stakeholders with actionable insights. 5.Data Mining: Utilize Excels data analysis tools (eg, Data Analysis ToolPak, Solver) to perform data mining and exploration, uncovering hidden patterns and relationships in the data. 6.Quality Assurance: Ensure data accuracy and integrity by conducting thorough validation and reconciliation checks within Excel spreadsheets. 7.Collaboration: Collaborate with cross-functional teams to understand data requirements and deliver timely analysis and reporting solutions using Excel. 8.Documentation: Document data analysis processes, methodologies, and assumptions in Excel workbooks to maintain transparency and facilitate knowledge sharing. 9.Continuous Learning: Stay updated on new Excel features, best practices, and tips/tricks to enhance data analysis capabilities and efficiency. Qualifications: Bachelors degree in Mathematics, Statistics, Economics, Computer Science, or a related field. Proficiency in Microsoft Excel, including advanced functions (eg, VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS), pivot tables, and charting tools. Strong analytical and problem-solving skills, with the ability to translate business requirements into actionable insights using Excel. Attention to detail and a commitment to data accuracy and integrity. Excellent communication and presentation skills, with the ability to convey complex technical concepts to non-technical stakeholders. Ability to work independently and collaboratively in a fast-paced environment. Prior experience in a data analysis role using Excel is preferred. Additional Skills (Preferred): Familiarity with other data analysis and visualization tools (eg, Tableau, Power BI) is a plus.