Data Analytics and Insights Analyst

Egypt (Cairo)

Finance

Hybrid

Experienced Professionals

ABOUT YOUR NEW JOB

• We are seeking a skilled and motivated Data Analytics & Insights Analyst to join our dynamic team in the food and beverage industry. In this role, you will contribute to our data-driven initiatives by analyzing data, providing insights, and supporting strategic decision-making. You will work closely with senior analysts and cross-functional teams to identify trends, track key performance indicators (KPIs), and help improve our product offerings and customer satisfaction. This is a great opportunity to enhance your analytical skills, gain experience in the food and beverage industry, and contribute to our mission of delivering outstanding products to our customers. We are looking for a candidate who is passionate about data, eager to learn, and possesses strong communication skills.

ABOUT YOUR NEW JOB RESPONSIBILITIES

1-Analytics & Insights:

• Support the deployment of advanced analytics use cases, focusing on segmented execution (tailoring marketing and sales efforts to specific market segments for optimized performance), demand forecasting, and post-promotion analysis.
• Assist in the development of new features for segmented execution strategies, enhancing targeting and effectiveness.
• Collaborate with Commercial, Marketing, and Sales managers to adapt to regional specifics, ensuring localized strategies are supported.
• Assist in delivering outlet, product, and sales staff segmentation based on internal and external data sources.

2-Problem Solving:

• Assist in structuring and identifying key business problems that data and analytics can help solve.
• Support the development of project plans for related use-case deployments, ensuring timely and effective implementation.
• Help ensure the adoption of new capabilities into regular business processes

3-Performance & Value Tracking:

• Assist in building value models to track performance and propose ongoing corrective actions.
• Develop and maintain Power BI reports and dashboards, providing clear and actionable insights to stakeholders.
• Identify opportunities to improve model prediction accuracy, under the guidance of senior analysts.

4-Data Management:

• Assist in data inventory and data management processes, ensuring data quality and accessibility.

ARE THSES YOUR SECERET INGRIDENTS?

1-Education:

• University degree in a quantitative field such as Business, Mathematics, Economics, Finance, Statistics, or a related Science.

2-Language:

• Proficiency in English at a B2 level or higher.

3- Years of Experience:

• Minimum of 1 year of experience in Business Analysis or Product Management, with a focus on data analytics.

4-Technical Skills:

• Good knowledge of MS Office, including advanced Excel functions (Power Pivot / Power Query).
• Experienced user and developer of Microsoft Power BI Reports / Dashboards.
• Basic proficiency in Exploratory Data Analysis in Python is desirable.
• Basic proficiency in SQL is required, and familiarity with the Microsoft SQL Server Stack (SSIS, SSAS, SSRS) is a plus.

5-Professional Skills:

• Good project management and accountability skills, with the ability to manage multiple projects simultaneously.
• Demonstrated ability to work effectively in cross-functional teams.
• Strong data processing agility and the ability to work with large datasets.
• Good communication skills, with the ability to effectively communicate complex information.
• Strong analytical and problem-solving skills, with a focus on delivering actionable insights.
• Ability to learn new technologies and adapt to new developments in the field of data analytics and artificial intelligence

6-Preferred Qualifications:

• Experience in the food and beverage industry.
• Familiarity with cloud-based data platforms (e.g., AWS, Azure, GCP).
• Experience with statistical modeling and machine learning techniques is a plus.

HOW WE WILL SUPPORT YOU

• You'll have a buddy who will introduce you to the business, your daily routines during your onboarding period.
• International career opportunities: As a large and expanding company, we offer unique opportunities for role changes and enriching experiences and capabilities, including cross-functional transitions and international assignments.
• 4 unique core values: Customer first, We over I, Make it simple and Deliver sustainably form the foundation of a robust culture that enables continuous and sustainable growth.
• Competitive remuneration and social package

ABOUT YOUR NEW TEAM

• We are Coca-Cola Hellenic, a growth-focused consumer goods business and strategic bottling partner of the Coca-Cola Company. We bottle, distribute and sell an unrivalled range of products in 29 markets in Europe, Africa and Eurasia. As we do, we create value for all stakeholders, support socio-economic growth and build a more positive environmental impact.
• We bring together more than 30,000 people from over 70 nationalities, coming from five continents. The diversity of our markets, from mature to emerging economies, provides a wide range of attractive opportunities for growth.
• We nurture our talents. We give opportunities to people across all functions and levels, as well as different geographies, backgrounds and education. We are willing to take a risk on the people we believe in, even if they don't have the perfect experience. We have faith in what every person can be.
• And although we have so much to be proud of, we always stay humble. We believe the real magic happens – for us and for you – when we OPEN UP."
• At Coca-Cola HBC, we are an inclusive employer that thrives on diversity. This means our environment provides equal opportunities for all, regardless of race, color, religion, age, disability, sexual orientation, or gender identity. Join us in nurturing a culture where everyone belongs and contributes to our collective success.

Development opportunities

Flexible Time

IT Equipment

Learning programs

Medical Insurance

Free product quota

Supportive team

Work from home