Assistant Team Leader - Budgeting and Analysis

Job description:

Who we are

Pioneering the production of dairy and juice products for over three decades, Juhayna Food Industries is a leading Egypt-based manufacturer specialized in the production, processing and packaging of milk, yoghurt, cooking products, juice and juice concentrate. Since its founding in 1983, it has secured a frontrunner position in the dairy and juice industries in Egypt and has expanded its presence in the Middle East, a feat made possible through its firm commitment to delivering a wide range of high-quality, healthy, and safe products that have become trusted household names.

Today, with four fully operational facilities, a vast network of distribution centers serving more than 136,000 retail outlets nationwide, and a 5000-feddan, fully-owned dairy farm that has the capacity to house +7,000 milking cows covering a sizeable portion of the company’s raw milk needs, Juhayna continues to raise the benchmark for premium quality Egyptian manufactured products.

We firmly believe that any company is only as successful as the efforts and dedication put forth by its people. Accordingly, it is of great importance to have a team that is an ambassador of our values upon which the company was established. At Juhayna, we church our values of Integrity, Achievement, Continuous Improvement, Innovation, Ownership, and Positivity .

Job Purpose

Responsible for the execution of financial analysis and reporting tasks. This role focuses on ensuring timely and accurate data collection, analysis, and presentation to support the section head in achieving departmental objectives and driving financial performance

What you will do in your role

• Preparing COGS budget, comparing the forecast with actual every month, analyzing the variance and implementing corrective action.
• Preparing comparison report between procurement purchasing plan and Forecasted consumption. 
• Reviewing the COGS Budget on monthly basis.
• Establishing New weighted average price each month like SAP, taking into consideration Forex LOSSES and new prices.
• Preparing Act COGS per SKU report on monthly basis and analysis unusual Cost.
• Preparing price, variance report on monthly basis.
• Updating & controlling bill of materials for each product.
• Preparing Purchasing plan by category & by Factory.
• Preparing study before any change in bill of material and send the approval to costing team to open the change number.
• Reviewing the change before closing the change number.
• Preparing Cash flow for Raw and pack materials on monthly basis.
• Partner with department heads and business units to provide financial insights.
• Support ad hoc analysis requests to aid strategic decision-making.
• Assist with presentations for leadership and board-level meetings.
• Ensure compliance with company policies and financial reporting standards.
• Maintain documentation of processes and controls for reporting activities. 

What you will bring to the role

• Bachelor's degree in Finance or any equivalent
• 1-3 years of experience in the Budgeting and Analysis department
• Excellent communication skills
• Ability to analyze financial data
• Precision in calculations and data entry