Key Responsibilities
Data Collection & Integration: Pull raw data from internal ERP systems, CRM platforms, and department spreadsheets.
Data Cleaning & Validation: Reconcile numbers, fix broken formulas, audit team sheets, and ensure data integrity.
Reporting & Dashboards: Produce recurring daily, weekly, and monthly reports (sales performance, stock levels, budget vs. actuals).
Exception Flagging: Proactively spot unusual drops, spikes, or variances before leadership asks.
Cross-Functional Coordination: Follow up with sales, HR, operations, and finance teams to gather missing inputs.
Required Skills & Qualifications
Technical Skills
Advanced Excel: Pivot Tables, XLOOKUP, VLOOKUP, SUMIFS, Power Query, Macros, and large dataset handling (100,000+ rows).
Business Intelligence: Proficiency in Microsoft Power BI or Tableau for interactive dashboards.
Database Management: Working knowledge of SQL for direct data extraction