Data Analyst
Job Description
Main Responsibilities
1.
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.
Requirements & Qualifications
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.
Quick Role Summary
Opportunity as "Data Analyst" at EGMED located in القاهرة on a Full-Time basis, suited for Senior Level candidates, within Technology & IT. Key details from listing: Main Responsibilities 1. Sales Performance Analysis • Analyze sales by product, sales representative, territory/region, and customer segment. • Identify…
The Egyptian Job Bank editorial team prepares curated overviews and actionable application guidance for every listing, preserving official employer details.
Application Tips
- Tailor your CV headline to match "Data Analyst" and feature measurable achievements in the top third of your resume.
- Customize your cover note for القاهرة: explain why this location and work arrangement suit your availability and how you add value to the team.
- Highlight relevant practical experience, key responsibilities, and specific business impact.
- Demonstrate team leadership, budget stewardship, and tangible business KPIs — concrete numbers carry maximum weight.
- After applying, monitor your status from your dashboard and stay prepared for an interview invitation.
Readiness Checklist
- Updated CV in standard PDF format with a professional filename
- Skills aligned with the stated role requirements
- Availability for work in القاهرة or remote if specified
- Measurable achievement examples prepared for interview talking points
- Egyptian Job Bank candidate profile ready for application tracking