Junior FP&A Analyst

About the role

Homzmart, Egypt's marketplace for furniture and home goods, is hiring a Junior FP&A analyst. The role supports financial planning and performance analysis, pricing and promotions checks, and reporting for the business.

Key responsibilities

• Support the preparation of annual budgets and forecasts, and monitor actual performance against budget and targets, identifying key variances and their drivers.
• Prepare periodic financial reports and dashboards on revenue, margins, marketing spend and profitability, and analyse performance by SKU, category, sales channel and payment method.
• Validate pricing updates and promotions for accuracy and alignment with approved financial targets, coordinating with Commercial and Marketing to obtain inputs and approvals before prices go live.
• Monitor SKU-level price changes and flag unusual movements, margin risks or potential financial impacts.
• Maintain and update financial models, trackers and reporting files, prepare recurring performance reports and help automate and improve reporting processes.
• Ensure data accuracy and consistency across reporting sources.

Required profile

• Bachelor's degree in Finance, Accounting, Economics, Business Administration or a related field.
• 0-1 years of experience in FP&A, financial analysis, accounting or a similar role.
• Strong analytical skills and attention to detail, good communication skills, and ability to work with large datasets and manage multiple deadlines.
• Ability to coordinate with cross-functional teams.

Required skills

• Strong Excel skills, including PivotTables, SUMIFS, XLOOKUP and other analytical formulas.
• Good understanding of financial statements, budgeting and profitability analysis.