Business Intelligence Analyst
Egypt3d ago
Key details
- Location
- Egypt
- Work style
- Onsite
- Level
- Mid level
- Experience
- 3–5 yrs
- Function
- Data & ML
- Focus area
- Data engineering & Analytics
- Posted
- 3d ago
Skills
budgetingbusiness intelligencedata analysisexcelfinancial analysisfinancial modelingfinancial statementsforecastingfp&apower bi
About the role
- Financial Performance Analysis: Analyze actual financial results against budget, forecast, and prior-year performance; investigate significant variances and identify the underlying financial and operational drivers.
- Management Reporting & Dashboards: Prepare consolidated performance reports, management dashboards, and KPI summaries that provide a clear view of portfolio performance and highlight areas requiring management attention.
- Data Consolidation & Quality: Coordinate with finance teams across portfolio companies to collect, consolidate, validate, and reconcile financial and operational data, ensuring accuracy, consistency, and timeliness.
- Budgeting & Forecasting Support: Support the review of budgets, business plans, and forecasts by analyzing key assumptions, evaluating performance trends, and conducting scenario and sensitivity analyses.
- Business & Profitability Analysis: Assess revenue trends, cost structures, margins, and other key performance indicators to identify potential risks, improvement opportunities, and value-creation initiatives.
- KPI Monitoring: Maintain standardized performance indicators across portfolio companies, monitor progress against targets, and flag material deviations or emerging trends.
- Analytical Models & Databases: Develop and maintain structured financial databases, analytical models, and reporting tools to improve the quality and depth of portfolio-level analysis.
- Process Improvement & Automation: Contribute to standardizing reporting templates, improving data collection processes, and automating recurring reports to enhance efficiency and reduce manual effort.
- Management Decision Support: Develop clear, evidence-based analysis and presentation materials to support in preparing insights and recommendations for the Group CFO.
- Stakeholder Coordination: Follow up with relevant finance and business teams to clarify performance movements, validate explanations, and ensure timely delivery of required information.
Educational Background: Bachelor’s degree in finance, Accounting, Economics, Business, or a related field.
Professional Experience: 3-5 years of related experience in financial analysis, FP&A, management reporting, corporate finance.
Technical Skills:
- Strong understanding of financial statements, budgeting, forecasting, and financial performance analysis.
- Advanced Microsoft Excel skills, including financial modeling, data analysis, and reporting.
- Experience with Power BI or other business intelligence and visualization tools is an advantage.
- Strong analytical and problem-solving skills, with the ability to investigate variances and translate data into meaningful business insights.
- Excellent attention to detail and a commitment to data accuracy and reporting quality.
- Strong communication and coordination skills, including the ability to work with multiple stakeholders across different businesses.
- Ability to manage multiple deliverables, meet deadlines, and present complex financial information in a clear and structured manner.
How well do you match this job?
Skills
Experience
Level
Title
Location
Salary
Freshness
Similarity
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.