Data Analyst

EGMED · Cairo, Egypt · Posted 2026-06-17

Main Responsibilities1. Sales Performance Analysis• Analyze sales by product, sales representative, territory/region, and customer segment.• Identify trends, opportunities, and performance gaps.• Track achievement against sales targets and budgets.2. Dashboard & Reporting• Create and maintain dashboards for management.• Prepare daily sales reports, weekly performance reviews, monthly business reviews, and forecast reports.• Ensure data accuracy and consistency.3. Forecasting & Planning• Support sales forecasting.• Analyze historical sales trends.• Predict future demand and revenue.• Help management set realistic targets.4. Customer Analysis• Analyze customer purchasing behavior.• Identify high-value customers, customers at risk of leaving, and growth opportunities within accounts.• Support customer segmentation strategies.5. Pricing & Profitability Analysis• Analyze gross margins, product profitability, discount impact, and customer profitability.• Recommend actions to improve profitability.6. CRM & Data Quality Management• Monitor CRM data quality.• Ensure opportunities, customer records, and sales activities are correctly recorded.• Identify missing or inaccurate data.7. Business Intelligence Support• Build reports using Microsoft Power BI, Tableau, Microsoft Excel, and SQL Server.• Automate reporting processes where possible.Key KPIs for a Sales Data Analyst• Report Accuracy %• Dashboard Adoption Rate• Forecast Accuracy %• Data Quality Score• Time Required to Generate Reports• Number of Actionable Insights Implemented• Revenue Opportunities Identified• Margin Improvement Recommendations  Bachelor's Degree in , Computer Science, Information Systems, Engineering, or a related field. Professional certifications in Data Analytics, Business Intelligence, Power BI, SQL, or Data Science are a plus. 3–5 years of experience in Sales Analysis, Business Analysis, Commercial Excellence, Revenue Management, Business Intelligence, or a related analytical role. Proven experience in analyzing sales performance, forecasting, budgeting, and KPI reporting. Hands-on experience with Power BI, Microsoft Excel (Advanced), SQL, and CRM systems. Experience developing dashboards, management reports, and automated reporting solutions. Strong understanding of sales processes, pipeline management, pricing analysis, and profitability analysis. Experience in healthcare, medical devices, pharmaceuticals, distribution, or FMCG industries is preferred. 

Apply for this role

Other open roles at EGMED

See all 3 open roles at EGMED →

Related jobs in Data & Analytics