Data Management Analyst

1. Advanced Reporting and Dashboard Development

• Design and build dynamic, interactive dashboards and reports primarily using Advanced Microsoft Excel functionalities (Pivot Tables, Power Query, Power Pivot, advanced formulae) and potentially secondary tools (like Power BI).
• Generate and distribute periodic (daily, weekly, monthly) and ad-hoc reports for various departments (Sales, Operations, Finance, etc.).
• Automate repetitive reporting tasks using Excel Macros (VBA) or Power Query to increase efficiency and reduce manual errors.

2. Data Management and Analysis

• Collect, compile, validate, and clean data from multiple internal and external sources, ensuring data integrity and accuracy .
• Perform in-depth data analysis to identify trends, patterns, anomalies, and key performance indicators (KPIs) relevant to business performance.
• Translate analytical findings into clear, concise, and professional presentations and visualizations for senior management.

3. System and Process Support

• Assist in maintaining and optimizing the current MIS framework and data storage systems.
• Troubleshoot reporting and data-related issues, ensuring minimal downtime for critical reports.

Propose and implement improvements to data collection and reporting processes to enhance overall business efficiency

I. Technical Expertise (Must-Haves)

• Expert Proficiency in Advanced Microsoft Excel (Non-negotiable):
• Mastery of complex formulas (e.g., VLOOKUP, HLOOKUP, INDEX/MATCH, SUMIFS, OFFSET, INDIRECT ).
• In-depth experience with Pivot Tables, Pivot Charts, and Slicers for data summarization and visualization.
• Strong working knowledge of Power Query (Get & Transform) for data extraction and cleansing.
• Experience with Power Pivot/Data Model for handling large datasets and creating relationships.
• Practical experience in writing and editing VBA Macros to automate tasks.
• Data Visualization: Proven ability to create clean, visually effective charts and graphs that convey complex data simply.
• SQL Knowledge (Preferred but not mandatory): Basic ability to write simple SQL queries to extract data from databases.
• BI Tools (Advantageous): Familiarity with business intelligence tools like Power BI or Tableau is a significant plus.

II. Experience and Education

• Bachelor's Degree in Business, Finance, Information Technology, Computer Science, or a related field.
• [Insert Number] years of proven experience in an MIS, Data Analyst, or Reporting role.
• Demonstrated experience in designing and maintaining analytical dashboards from scratch.

III. Core Competencies

• Exceptional Analytical and Problem-Solving Skills: Ability to critically evaluate data, identify underlying issues, and suggest data-backed solutions.
• High Attention to Detail and Accuracy: A strong commitment to error-free reporting and data validation.
• Strong Communication Skills: Ability to clearly articulate technical findings to non-technical stakeholders, both verbally and in writing.
• Proactive and Self-Managed: Ability to prioritize tasks, work independently, and meet tight deadlines.