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.
Senior Reporting & Advanced Analytics Analyst
Apply for this role
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 Senior Reporting & Advanced Data Analyst.
What you´ll do
- Execute and Lead 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) with strong structuring, scalability, and best practice governance. - Develop, enhance, and troubleshoot sophisticated Power BI dashboards using complex
DAX, advanced modeling, incremental refresh, and optimized performance for large/
complex datasets. - Ensure data reliability through rigorous preprocessing, validation, and quality checks.
- Drive reporting automation, process optimization, and system enhancement initiatives,
ensuring continuous improvement and innovation. - Mentor and support team members by sharing technical knowledge, best practices, and
analytical methodologies. - Support the team in building, optimizing, and troubleshooting Power BI reports and
dashboards, including handling large and complex datasets.
across key business areas such as market share, brand performance, sales effectiveness,
promotions, and pricing.
analytics solutions using Excel, VBA, Power Query, KNIME, and Python, sourcing data
from multiple systems while ensuring accuracy, quality, and consistency.
Snowflake Schema) with strong structuring, scalability, and best practice governance.
DAX, advanced modeling, incremental refresh, and optimized performance for large/
complex datasets.
ensuring continuous improvement and innovation.
analytical methodologies.
dashboards, including handling large and complex datasets.
What makes you a good fit
- Bachelor’s degree in Business Informatics, Information Systems, or a
related field. - 4–6 years of hands-on experience in business analysis, reporting, and data analytics
- Fluent in English (written and spoken).
- Strong expertise in Power BI, including advanced DAX, applying Row level security,
large-data modeling following best-practice methodologies (e.g., Star Schema,
Snowflake Schema), and performance optimization - Strong knowledge of databases, data concepts and SQL for data transformation
activities. - Hands-on experience or working knowledge in Python for data transformation, data
analysis, and automation - Experience with KNIME and/or Alteryx is a plus.
- Advanced proficiency in Microsoft Office, especially Excel (advanced functions, Power
Query, VBA) and PowerPoint. - Strong analytical thinking, problem-solving skills, and the ability to translate data into
meaningful business insights. - Excellent communication and presentation skills.
- FMCG Background is a huge plus.
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: 26096110
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.
About Henkel
FAQ
I am interested in several jobs. Can I apply for multiple positions at the same time?
Yes – simply fill out your profile in our online application system. Once your online profile is complete, you can apply for multiple positions.
The job offer is written in English – should I write my application in English as well?
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, the ‘rule’ is: please write the application in the same language as the job ad.
Do I get feedback during the application process about the state of my application?
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.
Can employees move between business areas and/or to a different country?
Yes, in fact it is an expectation within Henkel that our talent is flexible and mobile. 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 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.
Here you will get further information on our training programs.
Whom do I contact if I have questions concerning my application?
Our recruiting team will help you with all requests regarding your application. Contact the team here.