Reporting & Advanced Analytics Analyst

Global Business Solutions+ Market Research Egypt, Cairo, Cairo Full Time Regular
Apply for this role
germany-brandbar-1090x158

About this Position

The position is part of the Global Business Solution in Cairo (GBS+ Cairo), in the Market Data Solutions Process specifically handling the operation of Reporting & Advanced Data Analyst. 

What you´ll do

  • Execute market, client, and customer reporting, and perform data analysis across key business areas such as market share, brand performance, sales effectiveness, promotions, and pricing.
  • Perform data extraction, processing, and transformation to support reporting and analytics solutions using Excel, VBA, Power Query, KNIME, and Python, sourcing data from multiple systems while ensuring accuracy, quality, and consistency.
  • Design and build data models following best-practice methodologies (e.g., Star Schema, Snowflake Schema).
  • Develop and maintain dashboards and reports using Excel and Power BI, integrating existing and new data sources to deliver clear, actionable insights to stakeholders.
  • Support data preprocessing, analysis, and validation activities to ensure reliable outputs.
  • Participate in projects related to system enhancements, reporting automation, and process improvement initiatives.
  • Proactively share knowledge within the team and contribute to continuous improvement of analytics practices.
  • Support the team in building, optimizing, and troubleshooting Power BI reports and dashboards, including handling large and complex datasets

What makes you a good fit

  • Bachelor’s degree in Business Informatics, Information Systems, Computer Science, or a related field.
  • 2–4 years of relevant experience in data analysis, business analysis, or reporting roles.
  • Fluent in English (written and spoken).
  • Advanced proficiency in Microsoft Office, especially Excel (advanced functions, Power Query, VBA) and PowerPoint.
  • Strong expertise in Power BI, including DAX and data modeling.
  • Solid foundation in databases and data concepts.
  • Preferred experience or knowledge of SQL, Python, KNIME, and/or Alteryx.
  • Strong analytical thinking, problem-solving skills, and the ability to translate data into meaningful business insights.
  • Excellent communication and presentation skills

Some perks of joining Henkel

  • Flexible work scheme with flexible hours, hybrid work model, and work from anywhere policy for up to 30 days per year
  • Diverse national and international growth opportunities
  • Global wellbeing standards with health and preventive care programs
  • Gender-neutral parental leave for a minimum of 8 weeks
  • Employee Share Plan with voluntary investment and Henkel matching shares
  • Comprehensive Health Insurance for employee + dependents
  • Employee Assistance Programme provides a wide range of mental health and wellbeing benefits

At Henkel, we come from a broad range of backgrounds, perspectives, and life experiences. We believe the uniqueness of all our employees is the power in us. Become part of the team and bring your uniqueness to us! We look for a diverse team of individuals who possess different backgrounds, experiences, personalities and mindsets.

JOB ID: 26091647

Job Locations: Egypt, Cairo, Cairo

Contact information for application-related questions: recruitmenteg@henkel.com

Please do not use this email address for sending your application or CV. To apply, please click on the "Apply for this role" button below. Applications sent via e-mail will not be accepted.

Application Deadline: As long as the vacancy is listed on our Career Site, we are happy to receive your application

Job-Center: If you have an application already, you can create or log in to your account here to check the status of your application. In case of new account creation, please use your email address that you applied with.

YouTube Thumbnail Functions (Thumbnail)
How is work at Henkel

About Henkel

Building on a strong legacy of almost 150 years, we are leading the way to reimagine and improve life every day. Today and for generations to come. Through our innovative and sustainable brands and technologies, across our teams around the world.
Henkel holds leading positions in both industrial and consumer businesses: Our portfolio includes well-known hair care products, laundry detergents, fabric softeners as well as adhesives, sealants, and functional coatings.

YouTube Thumbnail This is Henkel (Thumbnail)

FAQ

Yes – simply fill out your profile in our online application system. Once your online profile is complete, you can apply for multiple positions.

Yes, please. As Henkel is an international company, you will be working with colleagues from all over the world, and English is our official company language. Generally, our recommendation is to please write the application in the same language as the job ad. 

Each position that we have open with Henkel is unique, and finding the right candidate is important for both the hired candidate as well as for Henkel. We want to make sure that both the candidate and the company are a good fit for each other. We will provide feedback to the candidates throughout the entire process.

Yes, in fact, it is our expectation that Henkel employees will want to grow and explore different career paths during their time with us. This helps to support the company on a broad, global level. 

Our “Triple Two” philosophy promotes this expectation, by allowing you to work in at least two different roles, in two different business areas and in two different countries. The reason behind this philosophy is that we believe working in different roles, business units and functions is good for your personal development and improves your understanding of Henkel as a global company.

Our recruiting team will help you with all requests regarding your application. Contact the team here.

Reporting & Advanced Analytics Analyst Apply for this role